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

Section suppression formula to exlude a PH if a subreport is in RF

Status
Not open for further replies.

DoPLeGaNgA

IS-IT--Management
Aug 30, 2002
9
US
Hello:

Is there a way I can suppress a page header section of a report if there is a subreport in the report footer of the the report?

I've manually created a cross-tab that has header info in the Page Header E section and I've created a subreport with detail in the Report Footer b section. I'd like to be able to use a suppression formula in the section expert to suppress Page Header e when printing/evaluating the subreport in the report footer b section.

Any help or insight anyone can provide would be greatly appreciated.

Thanks in advance.
 
If you are passing shared variables from the subreport in the Report Footer to determine the suppression of the Page Header, then it won't work. The subreport has to be in the Report Header so the shared variable is available for use in the Page header.

-lw
 
To suppress the header when the main report has finished, do a running total and a summary total on one of its field. When these are the same, the last detail has been shown and the page header should be suppressed.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Create two formulas:

//{@false} to be placed in the report header and in report footer_c if there are sections after RF_b:
whileprintingrecords;
booleanvar flag := false;

//{@true} to be placed in RF_b:
whileprintingrecords;
booleanvar flag := true;

Then go into the section expert->PH_e->suppress->x+2 and enter:
whileprintingrecords;
booleanvar flag;
flag = true;//note no colon

This assumes you have a new page before set on RF_b.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top