Subreports and page breaks

I have a main report with 3 subreports lined up in 2 columns. The report on the left is the height of the page (but varies in height by up to 6 lines). The other reports are smaller and fit on the right, one below the other. The main report also has a couple of fields at the top (not a header).

My problem occurs when the report on the left is too big to fit on the first page. Instead of filling up the first page and spilling 3-4 lines onto the 2nd page, it instead skips entirely to the 2nd page (since there is enough room there - there are no header fields).

Is there a way to force a subreport to be dumb and not try and fit onto one page?

[673 byte] By [dsavill] at [2007-12-20]

SQL Server

Site Classified