Outputting multiple reports to file (1 Viewer)

[Hunter]

Is there a way to print mutliple reports (all the same report but based on different ID#'s) with one push of a button? There are generally 20 reports or so that an admin must print and export to file. We are trying to save time by automating this in one operation. Is it possible to set up some code to loop through to print these reports?

Thanks...

 

[KevinM]

It is possible, but you need to post more information.

Basically...
You'll need a query set up that the report is based on.

Open this as a recordset in vb.

Loop through each record and set a WHERE condition on the ID to print each report and output the report using the OuputTo Action.

You will also have to set the file name in the Output Fle argument of the OuputTo line (I would rename it to the report name with the ID tagged on the end). So this will change on each loop, so as not to overwrite the previous file

HTH