Report Printing Question

[Golfinray]

I have a report with 2 subreports. Let's say I have 5 screwdrivers, with one
subreport telling me that I have 3- 5" and 2- 6" screwdrivers and the other
subreport telling me I have 2 phillips and 3 straight screwdrivers.
I then have in the same report,hammers, chisels, on and on. My question is:
I want only screwdrivers to print on one page, only hammers to print on its
own page, only chisels to print on its own page. Right now I get a page with
some hammers and some chisels. The next page is some chisels and some rivet
tools, etc. Help! Thanks so much!!!

 

[Marshall Barton]

I have a report with 2 subreports. Let's say I have 5 screwdrivers, with one
subreport telling me that I have 3- 5" and 2- 6" screwdrivers and the other
subreport telling me I have 2 phillips and 3 straight screwdrivers.
I then have in the same report,hammers, chisels, on and on. My question is:
I want only screwdrivers to print on one page, only hammers to print on its
own page, only chisels to print on its own page. Right now I get a page with
some hammers and some chisels. The next page is some chisels and some rivet
tools, etc.

Use Sorting and Grouping (View menu in the report's design)
to specify a group with header on the tool type field. Move
the tool type text box to the group header section and set
the section's ForceNewPage property to Before Section.