Grouping Report Pages

[TitaniaTiO2]

I would like to generate a report that has a general template but each page
is a different Department (one of my table headings).

I am generating the report off of a query looking for a specific Document
Number ( table heading). I want each report page to display everyone within
Department Y who has Document # X.

The report currently displays everyone who has Document Number X, and it
sorts by Department, but it will not make them separate pages.

I want to avoid making the query specify the department since I want this to
essentially generate all the report pages and print them without too much
user thought.

Any suggestions?

 

[Klatuu]

Put the field for the department in your sorting and grouping.
Set the Group Header to Yes.
Select the group header and select Properties
Set the Force New Page property to Before Section.

 

[AndyB via AccessMonster.com]

Hi,

What you need to do is introduce grouping and sorting on the report itself.
In design view of your report, right click and select sorting and grouping.
Select to group on the 'Department' field,
Select to have both group header and group footer.
These will appear above and below your detail section repectively.
Put your Department text box in the header and insert a page-break in the
footer.

You will probably have to play with the format of your report a little, but
you should end up with what you're after.

Your query should sort & filter all the other required criteria.

Andy

 

[TitaniaTiO2]

THANK YOU!