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

REPORT FPW26 Print "Continue" on next page header

Status
Not open for further replies.

fitedgar

MIS
Apr 24, 2002
238
US
I have a report based on table with details lines such as:
YELLOW (color)
item1
item2
etc
GREEN (color)
item1
item2
etc
BLUE (color)
item1
item2
etc
.
.
. and so on Report is grouped by Color
I need the report to print "Continued" on the next page header if details overflow onto the next page. Headers get reprinted on new pages.
Thank you in advance
EMC
 
Add a text "field" to your Report header containing "CONTINUED..."

Then you can use the field print option
Print When.....
then go to
Print Only When Expression is True....
into the expression field use
_PAGENO > 1 && Assuming Page no. re-set


If you are not re-setting the Page counter when the color changes, then try the following.

Add a field (example: CONT_FLG) to your print data table or to a secondary table related to the first which will control when to print "CONTINUED".

With a little bit of pre-processing you can increment the value of this new field on subsequent records, but re-set it to a value (such as 1) when the color changes which will be used to "flag" the report text field to print.

If you do this you will need to change the above expression field content to something like CONT_FLG > 1

Good Luck,


JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com
 
Thank you JRB-Bldr.
You gave me a very good idea.
EMC
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top