Records in Groups conserving space

[Former Member]

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!!!

[vitaly_izmaylov · Accepted solution]

It is really hard to troubleshoot without seeing the report.

Can you upload your report to the following URL:

https://mdocs.sap.com/mcm/public/v1/open?shr=1pFBzPHYk0TnbrwYRqOuHiVuSTOJUoHMIHnB0h4iVg0

[Former Member · Accepted solution]

I uploaded the file. Thank you, in advance, for your help.

[Former Member]

I uploaded the file.

[vitaly_izmaylov]

See modified version uploaded to the same location.

[Former Member]

Create columns for each formula.

Add another group which summarises data at the level you want, add summaries of your formula to this new group and suppress details and group header

Move any other fields in Details into the group footer.

Ian

[Former Member]

I already did that. Please see the report I uploaded. It still gives me lines where the details for each item is being evaluated, even if there is a blank.