Help with suppressing a group...

[stormtrooper]

Hi there. I have a report in which I have 3 amt totals (positive, negative and equals). If the amt_owing is pos. then group by "Funds Due", if amt_owing is neg. then group by "In Arrears". What I need now is if the amt_owing is equal then suppress the group. That is not display anything in the report. Here's what I have so far:

if {@TotPd/PermitValueDiff} < 0 then &quot;IN ARREARS&quot;
else if {@TotPd/PermitValueDiff} > 0 then &quot;FUNDS DUE&quot;

The above formula is called: @InArrears/FundsDueStts

This formula is also what I'm grouping by. That is, it is my Group #1 Name.

This is CR7.

Thanks

 

[dgillz]

Please be advised that suppressed records will still evaluate in any sub or grand totals. Since the groups in question would total to zero there is no difference to the user, but the best way to do this is to exclude these groups from the report altogether with a group selection formula.

Click on report, edit selection formula, group and enter a formula like the following:

Sum({amount},{groupbyfield}<>0

you should be able to go find the subtotal object in report fields, dbl click on it and finish the rest of the formula manually.

Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[dgillz]

Please be advised that suppressed records will still evaluate in any sub or grand totals. Since the groups in question would total to zero there is no difference to the user, but the best way to do this is to exclude these groups from the report altogether with a group selection formula.

Click on report, edit selection formula, group and enter a formula like the following:

Sum({amount},{groupbyfield})<>0

you should be able to go find the subtotal object in report fields, dbl click on it and finish the rest of the formula manually.

Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com