Search results for query: *

Thank you that worked great!

Hi: I have a report that pulls additional rental charges such as pet rent and garage fee. each charge has a status of either being part of the renter's current lease or being part of a renewal proposal. Such as: Charge type charge description amt Current garage $50 Current...

Thank you

Hi: I have records for a renter's renewal options. From my SQL query I get lease term offer rental rate 1 month renewal $1200 2 month renewal $950 6 month renewal $700 etc. I also have the current rent the person is paying and whether they are already on a...

Nevermind, didn't realize there was also a format with multiple columns on the common tab for the section expert. Unchecked it and i's all good.

Hi: I have a report that had the format groups with multiple columns on the layout tab of the section expert for the detail section checked. I no longer want the multiple columns, i unchecked the box and then saved the file but the detail section is still showing in design mode the column setup...

Thanks I will give it a try

I did put in the group field as a replacement in exactly the place you had group field

When I try the formulas and check them, I get an error that says this field has no previou or next value

Hi: Yeah, I will try the formula route as the group footer option sometimes puts the signature in the middle of the page but the page footer consistently is in the appropriate location.

Hi: I have a report which is basically in run of renewal letters being sent to apartment renters. The letter to each renter may be 1 or 2 pages depending on the length of the detail section. The group is the apartment unit #. The page footer is the letter closing (signature, title of sender...

Hello Again: So now that the lowest price shows as bold, they love it! However, now they want the lease term (crosstab column header) above the lowest price to also be bold. Is there any easy way to do that? Thanks so much!

Brilliant!!!!!! Thank you

Thanks, I will give it a try

Hi: I have a report which is grouping based on the following hierarchy: propertyname, eventtype (rented or available), floorplan style, apartmentcategory (standard or non-standard pricing), apartment# I have a crosstab in the apartment # group which basically lists by lease term the rent for...

Yes!!!!!! Thank you so much

Hi: I have a SQL script where I use in the select statement: rank () over (partition by t.person order by lp.dsumest) as rankedbyrent I would like to break up this query into multiple union statements, so I can add a hardcoded "type" field for each select statement section based on multiple...

Sorry missed part of it, was doing it from memory, here is what I had: if {Command.ProposedTerm} = 2 then {Command.ProposedRent} else 0

Hi: I have a report that is really a letter template for sending to apt. renters that are up for renewal. My SQL script pulls in all the possible lease proposals months 1 - 12 ranked by price lowest to highest (some of the rankings can be the same if the same price exists for more than one...

this was my solution (in basic syntax): dim propamenities as string if ISNULL({Command.communityamenity}) or {Command.communityamenity} = "" then propamenities = "None" else propamenities = Replace ({Command.communityamenity}, ",", Chr(10)) propamenities = Replace (propamenities...