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

Continued on next page and continued from previous page

Status
Not open for further replies.

MJD500

Technical User
Nov 9, 2001
33
CA
I am able to create a formula for a group header which allows me to include "Continued FROM previous page" in front of the value of the field in the group header by using the following formula:
If InrepeatedGroupHeader then "continued.." & {RESOLVER_GROUPS.RG_NAME} else {RESOLVER_GROUPS.RG_NAME}

BUT I would also like to be able to add "Continued on NEXT page" for the same group header on the previous page.

Anyone know how I can do this?
 
The following will work, assuming you want the "continued on next..." at the bottom of the page.

Insert a formula in the Page Footer
{RESOLVER_GROUPS.RG_NAME}& " is continued on the next page"

Then conditionally suppress the field using
{RESOLVER_GROUPS.RG_NAME}<>next({RESOLVER_GROUPS.RG_NAME})
Mike

 
Thanks Mike... I tried it but it doesn't work all the time because I have a subreport in a group header that overlays into the detailed section and when the subreport is too large to fit, it starts on the next page and the page footer disappears. The beginning of the detailed section starts on the current page with no page footer and runs into the next page with the subreport at the very top of the next detailed section. Make sense?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top