XI-Release2- How to Suppress Entire Page

[canyou]

I have a report that like a financial statement with one page per Job. I'm wondering if there is a way to supress (or hide) an entire page (GH's,GF's,PH's,PF's,Details) for Jobs where the Gross Margin (in Group Footer 2) is Zero.

Any help would be appreciated. Thanks.

 

[Turkbear]

Hi,
Why not add a group Selection formula to exclude any records where Grossmargin = 0?






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[canyou]

In all these years I've never had to do a group filter. Worked great. Thanks a bunch!

 

[groggle]

A note of caution when using Group Selection. Group Selection does not exclude any records from the report. It is in fact Group SUPPRESSION, where it stops a group being seen rather than removing the records that make up the group from the report.

One problem with this is that any Grand Totals or Grand Total formulae on the report using a summary function will still include the records that are being suppressed, and could be construed as displaying an incorrect Grand Total.

One way around this is to utilise Running Total fields to replace any Grand Total Summary or Grand Total Formulae fields.