Report height / Multiple Charts

[QB]

I've created a report which currently is comprised on 3 charts in which I
have maximized each chart to take up a full page and then placed a page break
after each one.

Now I need to add a fourth chart and I can`t seem to add it as Access does
not allow me to place anything beyond 22".

What would be the proper approach in such a case? (Please don't tell me to
create 4 separate report and then make a 5th to combine them -- This will
quickly become unmanageable!)

Thank you,

QB

 

[Marshall Barton]

I've created a report which currently is comprised on 3 charts in which I
have maximized each chart to take up a full page and then placed a page break
after each one.

Now I need to add a fourth chart and I can`t seem to add it as Access does
not allow me to place anything beyond 22".

What would be the proper approach in such a case? (Please don't tell me to
create 4 separate report and then make a 5th to combine them -- This will
quickly become unmanageable!)

Use the Sorting and Grouping window (View menu) to create a
group with header and/or footer using the same field the
report is sorted by. Then you can spread the charts across
two or three sections.