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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppress Blank SubReport

Status
Not open for further replies.

diane55

Programmer
Dec 14, 2004
20
0
0
US
I am developing a report in CR10 - I need to suppress a field in my main report based on if the subReport is suppressed (via no data being returned from subReport).

Is there a function/command to check if the Suppress Blank subReport (checked in the format Editor subReport tab) is true.

Any direction to resolution is appreciated in advance!
Diana

 
Create a shared variable in the subreport report footer:

whileprintingrecords;
shared stringvar id := maximum({table.string});//use a recurring field

Then in the main report, create a reset formula:

whileprintingrecords;
shared stringvar id := "";

Place this in a section above where the subreport is firing, e.g., in GH_a, if the subreport is in GH_b. Then
you can suppress a field in a section (e.g., GH_c) below the one in which the subreport is executing, by right clicking on the field->format field->suppress->x+2 and entering:

whileprintingrecords;
shared stringvar id := "";

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top