Batch reports

[mattbrem]

I have been asked to come up with a solution for printing a batch of reports. It would work like this, there would be a table with employer names along with employee information. The process should cycle through all the employers and group all of the employees belonging to an employer on a report, it should repeat this for each employer, and the employer name should be at the top of the report. There should only be one employer on each page along with the corrosponding employees.

Now I know how to group the employees by employer on the report, but im not sure how to cycle through the employers and create a seperate report for each and then print. After the report groups the first set of employees to an employer I need the next page printed to be the next employer with the corrosponding employees. Any suggestions would be greatly appreciated!

 

[mattbrem]

Would it be possible to write some kind of vba script which looks through the table, counts the number of unique employers, and then generates and prints a report for each?

 

[khawar]

You can do this in a single report

Use group by employer in report

Insert new page after each employer

Reset page number to 1 again when a new employer starts this will be like seperate report for each employer