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!

Printing several reports at once as one big report - pages problem 1

Status
Not open for further replies.

inso18

Technical User
Dec 30, 2006
147
IL
Hello users and experts.

I have several different reports I'm sometimes asked to print as one long report. Each of the several different reports has a changing number of pages dependent on the database.

If the first report has 5 pages is it possible to initialize the second report to start with the page 6 and so on?

Is it possible to print them with one queue print?

Inso.
 
Sort of a hack-job cause it's partially manual: in the footer of the reports (other than the first one), put:

Code:
="Page " & [Page]+[Start Page]

Then it will prompt you for the Start Page and add to that. So say Report1 had 10 pages in it; when you get prompted when running Report2, enter 10. Then say Report2 ended on Page 17 (it had 7 pages but numbered to 17); Then put in 17 when prompted for Report3. Or something like that....

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top