A 2 Pages Report Becomes a 64 Pages Report!

[Telesphore]

Using Office Access 2000 database, the students in our school receive a
report of their marks at the end of their program.

The report is grouped and sorted by student, inscription dates and by
courses names.

Some students take different programs. In one case, a student took a major
in philosophy (54 credits or 20 subjects) and a minor in theology (36
credits or 12 subjects).

For this student we need a single report (BA of Arts) in which the major and
the minor will be embedded as subreports.

In resumé, the rptBA report will include the rsubPH and rsubTH reports.

Up to now, it works fine, but the report (rptBA) has 64 pages instead of 2!
I suspect it depends on the number of subjects (courses names): 32 (20 and
12) multiplied by 2?

Any ideas of what is needed?

Any help will be appreciated. Thank you.

Telesphore

 

[Duane Hookom]

I can only guess that your main report contains the level of detail that
your subreports contain. Without knowing your table structures and report
record sources, we are left to guess and assume.

 

[Telesphore]

Thanks Duane

Trying to make it clearer:

Here are the fields used in the different tables;

tbStudents
- StudentName
- Street
- State
- etc.

tbInscriptions
- InscriptionDate

qryCourseInscription

- tbCourses
o CourseName
o CreditNumber
o etc.

- tbInscriptionDetails
o Mark


The main report rptBA is based on the query "qryMarksCard" taking its values
from 2 tables: "tbStudents" and "tbInscriptions", and based also on 1 query
"qryCourseInscription" taking its values from 2 tables: "tbCourses" and
"tbInscriptionDetails"

- Header contains Control Boxes for the fields StudentName, Street, City,
etc.
- Details contains sub reports: rsubPH and rsubTH
- PageFooter contains labels and a control box for "Page x of y Pages"
- There is a Class Object "Report_rptBA" for the Control Box for "Page x of
y Pages"
Nothing is grouped and sorted here in this main report.

The sub reports "rsubPH" and "rsubTH" are based on the same query of the
main report: "qryMarksCard".
- No PageHeader, nor pageFooter
- Details contains control boxes for the fields: CourseName, CreditsNumber,
YearTerm, Mark
- The dialog box groups and sorts the fields StudentName, InscriptionDate
and CourseName
- GroupFooter "InscriptionDate" contains one control box to sum up the
average of the fields Mark corresponding to the different fields CourseNames
during the year term.
- GroupFooter "StudentName" contains one control boxe to sum up the total of
the credits from the fields CreditsNumber and another control box to sum up
the Marks average of the marks corresponding to the different fields
CourseName.

Hope this helps.

 

[Duane Hookom]

Normally, the main report will not contain the same level of detail as the
subreport. Is there a reason why you are using the same query for all
reports?

 

[Telesphore]

It is because we need to group under two different titles in the main report
detail section the marks of the two different sub reports.

For example in the detail section of the main report:
*********************************
MAJOR IN PHILOSOPHY
Course NameA CreditNumber Mark
Course NameA CreditNumber Mark
Course NameA CreditNumber Mark
etc.
**********************************
MINOR IN THEOLOGY
Course NameA CreditNumber Mark
Course NameA CreditNumber Mark
Course NameA CreditNumber Mark
etc.

This is also the reason for the same query.

 

[Duane Hookom]

I still think you can make your main report's record source into a totals
query. Your emails don't suggest anything that looks like details from some
of your related tables other than sums or averages. It is still difficult to
tell since your earlier email contained some fields and tables but there
were no relationships or common fields. There were also no relationships
described between the report and subreports.

 

[Telesphore]

When you say "I still think you can make your main report's record source
into a totals query", do you mean that I can do what I want in a single
report? No need of sub reports?

So that in the detail section of the report, I could put two labels
MAJOR IN PHILOSOPHY and MINOR IN THEOLOGY
and under each label insert the control boxes: Course Name CreditNumber,
Mark, etc. ?

 

[Duane Hookom]

No, I still think you probably need the subreports however I don't think you
need the same level of detail records in both the main report and the
subreport(s).

 

[Telesphore]

Thanks a lot. Solution found!

Create a Group Footer named "Program" and copy the 2 sub reports in it
instead of the Detail section.