Long reports

[Samuel]

I noticed that I can stretch the report only to a certain extent, is there
settings to change that, I need a report 3 or 4 pages long (not including
sub reports or fields set CanGrow)

Thank you,
Samuel

 

[Allen Browne]

The height of one section is limited to about 22 inches in height. If you
need more than that, use multiple sections.

In report design view, open the Sorting And Grouping box (View menu.) Select
a field that doesn't change (e.g. the ClientID if you are grouping by
client.) In the lower pane of the dialog, set Group Header to Yes, and Group
Footer to Yes. This gives you 2 more sections, and you can get 2 pages out
of each of them. Repeat with more ClientID rows in the Sorting'n'Grouping
box if necessary.

If you don't have any unchanging field to use, you can create one by typing
an expression like this into the Field row in query design:
AlwaysFalse: False
and then group on this field in your report.