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!

New Page After

Status
Not open for further replies.

ssudha

Technical User
Oct 14, 2002
62
IN
Hi All,

How to use a formula in "New Page After" based on a group name?
Ex: I have a report that has two groups (Site and DeptName). The Site group footer is used to diaplay Site Totals.There should be a new page after every deptName but the new page should not come if the Site group footer can fit in the same page as DeptName group footer.

Also, How can we restrict the page header using a formula.
Eg: I have a subreport in the report footer section for displaying the grand totals for all the sites. But the page header that comes on every page, should not come here.

Please help !

Thanks in advance

Sudha
 
Rather than use a new page after, right click the section, select change group, and select Keep Group Together.

To eliminate the page header, you may have to set up a shared variable and toggle it on or off depending upon whether you want this to display. Not sure though, perhaps if you provide and example someone can flesh it out.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top