Automatically create multiple reports from a single report

[Tamara]

I have a table that has release/project, project manager, issues, risks, etc.
I need to have each release/project in its own separate report. At this
time I'm creating one report for each release/project then printing to a PDF
(using PDFCreator). I'd like to know if there's a better way to do this
automatically like by using the release/project field as the criteria and
either create multiple reports based on a single report layout -or- print to
multiple PDFs.

Thx -Tamara

 

[Jeff Boyce]

Tamara

That will probably depend on how you define "its own separate report".

It would be very unusual (and unnecessary) to use the Access user interface
to create a separate report definition for each record in a table (that's
the literal definitioin, but not a good idea).

It would be very common to create a single report definition for the data
elements on a table (or in a query), then set that (single) report to start
each section (?i.e., "project") on a new page. You could use the Sort/Group
feature to get a separate group for each project, then set the properties of
that group section to start at the top of a new page for each group/project.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP