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!

Page header/footer in subreport become report headers/footers

Status
Not open for further replies.

shera4111

Programmer
Apr 12, 2006
27
CA
Hi all,

I have a subreport which has a page header/footer. In the header/footer there is a simple textfield. Let's say it says "Hello World". The subreport works beautifully when run on its own, and the page header/footer shows up on every page.

When I include it as a subreport in a main report (for the detail oriented, it is in a Report Header section) and run the main report, the header/footer for the subreport appears only on the first page of the subreport (for the header), and the last page of the subreport (for the footer).

Further investigation shows that Crystal has decided when including the subreport to convert my page header/footers from the subreport into report headers/footers. This results in the same effect as if my subreport had report headers/footers instead of page headers/footers.

Can anyone tell me how to get the page headers/footers on every page of the subreport when included in the main?

Thx.
shera4111
 
For a fake page header, create a formula that is true for all subreport records:

whilereadingrecords;
1

Insert a group on this formula and check "repeat group header on each page". Then remove the group name and add your page header to this new group section.

For the page footer, I think you have to set up page line counts using a variable, use a new page after based on a specific line count, and then place the page footer fields in a detail_b section that is suppressed unless it equals the set line count per page.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top