Outputting multiple Reports to Files

[Steven547]

I have a report that prints out roughly 20 pages. Each page represents different information. Is there a way to have each page placed into it's own "file" or "snapshot" when I click generate report?

thanks

steven

 

[lameid]

Not without code...

What follows is a basic description of what the code would need to do and assumes you know something about VBA. If you do not, posting the sql statement behind the report and describing what fields or columns force a new page will help (assuming you are using a section footer to give you multiple pages).

What you would do is open a recordset that contains a list of all the things you want to print the report for.

Then as you read each record, export the report to a file using a field in the record as criteria.