multiple page print problem based on number of items in subreport

[Scott F]

I am putting together a registration report using family information in the
main report and individual student academic information in one subreport and
individual student health information in a second subreport, all sourced from
the same table and formatted to be on 1 page. With multi-student families, I
get multiple printouts rather than 1 page so am wasting paper. How do I get
this report to printout only a single page per family?

 

[Duane Hookom]

Set your primary sorting and grouping level to the field or fields that
uniquely identify a family. In the family footer, set the New Page property
appropriately.

 

[Scott F]

I may not be doing things properly. I have a page title in the header; the
general family info in the Details section; subreport 1 with student school
info; subreport 2 with student health info; and a page footer with date and
page number.

When I go to the details section and group on family...it still prints
multiple copies. When I insert family info in the header and then group it,
it still prints out multiple copies.

I have also tried page break after the subreports and in the page footer...

 

[Duane Hookom]

Can you provide some information about your tables, fields, and relationships?

 

[Scott F]

I have many data elements for each student. Including Family Name, Student
Name, Father Name, Mother Name, etc. No index on the table.

Since there are several families with the same Family Name, I use Family
Name, Father Name, and Mother Name to group the subreports to the specific
Family and their student(s). I do not display the grouping in the subreports.

Then when I try to add Family Name as a header group, or add Father Name as
another header group, or even add mother as a third header group, it still
prints out for each Family Name with multiple students...a page per student.
Single student families work perfectly.

I added the footers too and inserted a page break but still multiple
printouts.

By the way...Thanks for taking the time to help. This is not a killer for
us...just for a few trees!

 

[Duane Hookom]

So you only have one table and no primary key? How does this create a main
report and two subreports? By "data elements" do you mean "fields"?

Do you have values stored in fields that uniquely identify a "family"?

Again "Can you provide some information about your tables, fields, and
relationships?"

 

[Scott F]

Each line in the table represents information about 1 student...with various
data elements included in the "fields"...some of which pertain to their
family.

The idea is one printout for each family. So basic family information is
included at the top of the report. I use family name, father name and mother
name...3 fields...to group the student information in to one family report.
I can not use only family name as we have multiple families with the same
last name.

Then, under that section is a subreport that shows individual student
information. If 3 students in the same family, then the subreport shows 3
lines...one for each student.

The second subreport works the same way just has specific student health
information instead of school information.

The 3 field family grouping works well in the subreports by including those
3 fields in the subreport without displaying them so that I get the student
detail linked to the correct family.

The only issue is that I get multiple printouts for multiple student families.

 

[Duane Hookom]

Group the main report on the "basic family information" and display the
family header and footer for family information. Then add student information
and subreports in the detail section. Set the subreport link master/child
properties to the appropriate family and student fields.

Set the Force New Page of the family footer section to "After Section". This
should keep the families together as long as there is room.

 

[Scott F]

I had been adding the insert new page after the subreports...so I tried the
Force New Page...after section...in the footer, but still ended up with
multiple printouts.

I do thank you for your assistance but I have to hand it over as is.