BHScripter
Technical User
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 choosing that particular lease term. I don't necessarily need the crosstab it just lines everything up really nicely. I have the summary as Sum and I am suppressing the Grand totals. There is really nothing to sum as there is only 1 value for each lease term. it looks like:
Apartment 100 (group)
2 month 3months 4months 5months 6months (etc...)
1500.00 1275.00 1100.00 1090.00 1000.00
I need to be able to bold the rent that is the minimum.
I have tried to set a formula on the font style for the rent field in the crosstab:
if Minimum ({Command.Rent}, {Command.AptCode}) = {@minimumrent} then crBold else crRegular
and the formula for the minimum rent calc works as I checked it by making that field visible in the same group.
However, with the above formula each of the summary amounts for every month comes out bold.
Thanks in advance for any assistance.
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 choosing that particular lease term. I don't necessarily need the crosstab it just lines everything up really nicely. I have the summary as Sum and I am suppressing the Grand totals. There is really nothing to sum as there is only 1 value for each lease term. it looks like:
Apartment 100 (group)
2 month 3months 4months 5months 6months (etc...)
1500.00 1275.00 1100.00 1090.00 1000.00
I need to be able to bold the rent that is the minimum.
I have tried to set a formula on the font style for the rent field in the crosstab:
if Minimum ({Command.Rent}, {Command.AptCode}) = {@minimumrent} then crBold else crRegular
and the formula for the minimum rent calc works as I checked it by making that field visible in the same group.
However, with the above formula each of the summary amounts for every month comes out bold.
Thanks in advance for any assistance.