New page for subreport

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

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
 
Back
Top