INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Creating a master report from multiple full length reports

Creating a master report from multiple full length reports

(OP)
I have created reports for five academic subjects: math, humanities, physics, foreign languages etc...They each run more or less the maximum length of a report (22 inches or so). Is there anyway to group all these reports into a master report? In other word, with the student name as an identifier, get all these reports to flow one after the other per student?

Thank you

RE: Creating a master report from multiple full length reports

Are you suggesting that a single section in the report is "22 inches or so"?

You can use a main report with multiple subreports.

Duane
Hook'D on Access
MS Access MVP

RE: Creating a master report from multiple full length reports

(OP)
Yes I am. Every subject has narrative sections (that require memo fields) plus specific fields. The math report alone is 3 pages long, and same for three of the four others. Per kid, each total report is approximately 15 pages. If I create a master report, and bound the other reports as sub reports, will I have a size issue?

Thnaks

RE: Creating a master report from multiple full length reports

You may need to place the subreports in separate main report sections.

Duane
Hook'D on Access
MS Access MVP

RE: Creating a master report from multiple full length reports

(OP)
Sorry for the delay in reply Duane. I am not sure I understand what you are inferring. I have five subjects, each 3 to 4 pages. I create an unbound master report, and create a sub report for each subject, correct? What do you mean by creating sections of the main report?

Thanks for clarifying.

D

RE: Creating a master report from multiple full length reports

You can create up to 10 group headers and footers. If your reporting doesn't work in a single section, I would bind the report to a single record for the student. Then add as many group sections as you need based on the primary key of the student table.

Duane
Hook'D on Access
MS Access MVP

RE: Creating a master report from multiple full length reports

(OP)
Thank you Duane,

I implemented your recommendation, and after a while to build the huge query (220 fields I believe) I created a report with 9 headers. The problem I am encountering is that parts of the 220 fields for Student A are actually showing information for student B. I don't understand how this is possible, but that is happening.

I have nothing in the detail section, nor in the report header, could that be a problem? I have created a master query based on the student ID (which is unique to each student), and then forced the one to one relation between student ID and nine different tables.

Please let me know why some of the fields (memo fields) are not working correctly if you can think of anything.

Thank you,

D.

RE: Creating a master report from multiple full length reports

If the data is wrong, I would copy the datasheet view of the record source and paste into Excel to evaluate.

I have no idea what you mean by "not working correctly".

Duane
Hook'D on Access
MS Access MVP

RE: Creating a master report from multiple full length reports

(OP)
Duane,

I worked out everything regarding the sub reports. Thank you very, very much for all your help.

David

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close