Multiple Pages Limited Detail Height

D

debpep

I am designing a report of about 8 pages. I have made multiple pages on the
detail section, however I have come to the end of the detail height of 22
inches. How can I add more pages on the detail section? The page limit of a
report is 65,536, yet a detail height limit is 22 inches. I must be missing
some important peice of information.
 
R

Rick Brandt

debpep said:
I am designing a report of about 8 pages. I have made multiple pages on the
detail section, however I have come to the end of the detail height of 22
inches. How can I add more pages on the detail section? The page limit of a
report is 65,536, yet a detail height limit is 22 inches. I must be missing
some important peice of information.
Click to expand...

What you're missing is that an Access report is assumed to be populated by
*repeating* the bands or sections in the report however many times necessary to
process the records and groups in the data set. A report that has a 1 inch
detail section and 1000 records will produce 1000 inches of output. You don't
embed the entire report's output while in design view.

You can add more sections or embed subreports to get more "design area" in the
report, but that is seldom necessary with a proper design.
 
D

debpep

My report contains only one record (a report is printed for each subject) and
multiple subreports and pages within the detail section. I have come to the
end of the end to the detail section (22 inches) and cannot add more
subreports (i need to add 2-4 more subreports (approximately 3 printed
pages). I cannot find out how to add addtiional detail sections, although i
am searching.
 
R

Rick Brandt

Are you making the existing subreports as small as possible (height-wise)
and then setting their CanGrow to Yes? That should give you plenty of
room.

Otherwise move some of the stuff into the Report Header/Footer or Page
Header/Footer sections or use the Sorting and Grouping dialog to add Group
Header/Footer sections. You can define a Group over a constant like "=1"
and use that to create both a Header and Footer section.
 
Top