Records in Groups conserving space

78 Views Last edit Sep 12, 2017 at 04:53 PM 2 rev

Hi Folks. I've read so much all over the internet and I'm done searching. I really hope you can help. I'm stumped on how to conserve space when displaying records on a report. This is the scenario:

First

I have 3 groups:

30 Days
90 Days
12 Months

Each "House" {@House} belongs in one of the groups. Works fine with this formula:

if CurrentDate - {HOUSEMASTER.SETTLEMENT_DATE}>= 30 and CurrentDate - {HOUSEMASTER.SETTLEMENT_DATE}<= 89 then "30 Days" else if CurrentDate - {HOUSEMASTER.SETTLEMENT_DATE}>= 90 and CurrentDate - {HOUSEMASTER.SETTLEMENT_DATE}<= 364 then "90 Days" else if CurrentDate - {HOUSEMASTER.SETTLEMENT_DATE}>= 365 and year({HOUSEMASTER.SETTLEMENT_DATE})+ 1 = year(currentdate) then "12 Months" else ""

Second

I need columns for each record to fall into based on the {HOUSEMASTER.SETTLEMENT_DATE} field.

Example (these results are in the details section of the report:

@January = If Month ({HOUSEMASTER.SETTLEMENT_DATE}) = 1 then {@House} else ""
@ February = If Month ({HOUSEMASTER.SETTLEMENT_DATE}) = 2 then {@House} else ""
and so on....

I get the results I want, but the report becomes 20 pages long, because it evaluates each record for each group in each column. How can I get rid of the blank fields and condense my report to one page?

I tried creating 12 different reports and passing a value by column, but I can't get it to reset on the group.

Thank you, in advance, for your help!!!