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?