I have a report, which includes a number of sub-reports in the "Report footer".

The problem I have is that the sub reports vary in size from month to month & in a month where there is more data, the text appear on top of the second sub report, which mean I have to go in and manually move the sub report further down.

Is there a way to "auto size" sub reports, so that when there is a lot of data, they display without covering text in the next sub report below?

Any help would be very much appriciated.

Kind regards,

Iain.

Thanks for the reply.

This does not seem to be an option in the "Report footer", "New page after" is greyed out.

I have six sub reports in the "Report footer".

Any ideas?

create 6 report footer sections and place each subreport on the its own footer section. the secion will expand and contract per report so they never overlap.

in design mode point your curser at the RF section label (all the way to the left of the screen)

Edited by DBlank - 27 Sep 2011 at 4:07am