New page for subreport

I have a report with a subreport.

I am setting up the subreport to have grouping. However, I need each
grouping to be started on a new page.

Example:
Report of School Classes with Class Attendees.
Some classes have NO attendees, but the class still needs to have a page
printed. Therefore, the main report source is a list of classes (and this
page would show teh class info with no attendees)
Each detail section needs to print a different page for each school grade of
attendees.

Desired Effect:
Page 1: Report Header is detail of Class A
Page 1: Report Detail is list of Freshman Attendees

Page 2: Report Header is detail of Class A
Page 2: Report Detail is list of Sophmore Attendees

Page 3: Report Header is detail of Class A
Page 3: Report Detail is list of Junior Attendees

Page 4: Report Header is detail of Class B
Page 4: Report Detail is list of Freshman Attendees

I have set the subreport to group the attendees by school grade and set the
"School Grade" property of "Force New Page" to be "After Section"

The problem is that the main report is not printing the second page. It is
only showing the first section of detail (i.e. the Freshman Class
Attendees".

How do I setup a report that will start a new page based on teh new page of
the detail section?

-Stephen

Hi Stephen.
What you outlined can be accomplished by placing the
current fields from your report header into the page
header instead.
Now group the report by Class and by Attendees, to solve
the issues with no having certain attendees for all
classes, you can add a table listing all types attendees
to the undelying query without setting a link, this will
ensure that all classes have an entry for each type of
attendee.
Hope this helps.
Fons

-----Original Message-----
I have a report with a subreport.

I am setting up the subreport to have grouping. However,
I need each
grouping to be started on a new page.

Example:
Report of School Classes with Class Attendees.
Some classes have NO attendees, but the class still needs
to have a page
printed. Therefore, the main report source is a list of
classes (and this
page would show teh class info with no attendees)
Each detail section needs to print a different page for
each school grade of
attendees.

Desired Effect:
Page 1: Report Header is detail of Class A
Page 1: Report Detail is list of Freshman Attendees

Page 2: Report Header is detail of Class A
Page 2: Report Detail is list of Sophmore Attendees

Page 3: Report Header is detail of Class A
Page 3: Report Detail is list of Junior Attendees

Page 4: Report Header is detail of Class B
Page 4: Report Detail is list of Freshman Attendees

I have set the subreport to group the attendees by school
grade and set the
"School Grade" property of "Force New Page" to be "After
Section"

The problem is that the main report is not printing the
second page. It is
only showing the first section of detail (i.e. the
Freshman Class
Attendees".

How do I setup a report that will start a new page based
on teh new page of
the detail section?

-Stephen


.