Help with long report

[Guest]

I am trying to create an Access report that will print off individual
applicant information.
The report will be used by the interviewing committee during the interview
process.

There are about 12 sections to the report...PersonalInfo, Academic Info,
Work History, etc..
They want each section to be printed on it's own page...no starting of
another section on that page.

Because this is a very long report I am wondering how to organize the
report...
Each page has the applicant name on top...then the data for that
section...but as I add subforms to the report...I have run out of space and
cannot add the last 5 or more sections to the report...

What is the best way to set up this report? Do I add individual pages to the
report for each section...thanks!

 

[Marshall Barton]

I am trying to create an Access report that will print off individual
applicant information.
The report will be used by the interviewing committee during the interview
process.

There are about 12 sections to the report...PersonalInfo, Academic Info,
Work History, etc..
They want each section to be printed on it's own page...no starting of
another section on that page.

Because this is a very long report I am wondering how to organize the
report...
Each page has the applicant name on top...then the data for that
section...but as I add subforms to the report...I have run out of space and
cannot add the last 5 or more sections to the report...

Make each of your subreport's (why use subreport??) about an
inch (or less) tall and set their CanGrow property to Yes.
You can force a new page anywhere you want by using a Page
Break control.

 

[Guest]

Thanks Marshall
I used subforms on the report for each section because all I had to do was
click subform/subreport...choose base it on a form already created...and pick
that form name...

Should I go back and create new subreports for all these sections instead???

 

[Marshall Barton]

No reason to change it if it's doing what you want. My ??
was because you never explained why you're using them. I
guess the question really should have been - Do you have
separate tables for each of your "sections"?

Regardless of that extraneous issue, were you able to get
everything to fit in the design view and on separate pages?