Generate separate reports (1 Viewer)

[mariaw]

Hi

I currently have a report that prints a summary of progress of legal matters for all departments.

I have now been asked to provide a separate report for each department, rather than one big report.

The departments are contained in a Table.

Is there some way of running a macro so that I don't have to type in each department name as criteria so that each report runs separately???

thanks

Maria

 

[KeithG]

Group the report by department. Then set each group to print out on a seperate page.

 

[mariaw]

Thanks Keith, but I should have also told you that I email the reports, rather than print them out, so I need the system to physically generate, say , 20 different reports?

thanks

Maria