multi-page report to multiple pdf's

N

notDave

I have a report that shows some basic employee information. It is based on a
query with 300 employees in it, and when run for all employees the report is
300 pages, each employee on their own page.

Currently I am looping through the report, once for each employee_id, and
printing each one to a pdf, including the date and employee_id in the
filename. I have seen some code here in the posts that does pretty much the
same as what I'm doing. The problem is that this takes f o r e v e r to
run, especially when my query goes from 300 records to 3000 records.

My question: Is there a better way to design this? Is there a way to run
the report once but print each page to its own pdf using that particular
employee_id in the filename?

I've searched and read posts about creating pdf's from reports but I haven't
really found any logic along these lines.

Thank you for any assistance or guidance you may have to offer.

~notDave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top