Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

suppressing sections based on values in other sections

Status
Not open for further replies.

crystal82

Technical User
Joined
Jun 13, 2008
Messages
7
Location
AU
I have a report that contains one group and two subreports sitting underneath that group.

The subreports are suppressed (in the main report) if there is no data in them.

However, I am trying to suppress the Group Header + the Group Footer if there is no data in the subreport.

I have tried suppressing the GH1 and GF1 sections if values passed from the subreport are 0, however this applies the suppression to the next group, not to the group that I am trying to suppress.

Is there a way around this?
 
If the sub reports execute quickly you could add hidden versions of similar Subreports in another Group Header Section. These then generate Shared Boolean Vars to suppress displayed sections if no data found.

Make sure the section containing the new testing SRs is kept as small as possible and set to underlay following sections.

Ian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top