Skip to Content
0
Former Member
Apr 20, 2009 at 05:44 AM

Conditionally suppress details section

268 Views

Hi All

I have a main report with two subreports in the details section, a formula field is in the section below that adds totals from my two subreports. Everything here works beautifully until I want to suppress the details section when the formula field is zero. It appears that if I wanted to print the records that return a zero total, I have no problems, but when logic tells me to change my suppress formula to show not zero, all my records are printing. I have tried all sorts of things including;

whileprintingrecords;

({@grandtotal})=0;

this prints everything

I have also converted my {@grandtotal} to a boolean and tried to suppress that way.

I have tried 'evaluateafter' to no avail.

Any suggestions?