Keep Together Possible?

I have a report which contains multiple sub-reports to display different data types that do not relate, but are needed on the same report (the reason for the various sub-reports).

Everything was working fine, until....

The first sub-report is very small, prints maybe 4 inches down the first page. The second sub-report is very large, and now has grown larger than the remainder of the page.

So the second sub-report pushes down and prints of on the 2nd page, leaving most of the first page blank (looks HORRIBLE). I have placed all the sub-reports into a rectangle property, but still do not see anyway to keep the sub-reports together (so they look continuous).

Does anyone know of a work around for this?

Thank you for you help.

T.J.

I'm sorry, there is not a way to override this implicit keep-together on the subreport. The closest you'll get is if you combine the two reports into one.

|||

Thank you for your help.

What is really weird is on the 2nd page of the report, where the 2nd sub-report starts, a 3rd sub-report prints as well.

The 3rd sub-report does print on two pages (where the 2nd sub-report will not do this). And I can find nothing different in the properties of the sub-reports, the main report, or the tables used on the sub-reports.

Very weird. It is like SQL reporting services just picks and chooses when it wants the sub-report to behave correctly.

Hate to have to go back to Crystal, but that might be the only option.

Let me know if you have any other ideas.

Thank you,

T.J.

|||Was the third subreport too large to fit on a single page? If so, it means we can't honor the keep-together and will not try and push it to the next page.|||

Yes, the 3rd sub-report is too large to fit on one page (like the 2nd sub-report), but it breaks out correctly and prints on the 2nd and 3rd page (as expected, the third sub-report starts on the 2nd page, and continues to the 3rd page).

Only the 2nd sub-report forces down to a new page. And I cannot find anything different in these sub-reports at all.

Very strange deal.

Thank you for your help. If worse comes to worse, I can build it in Crystal and run it for the users and send them a .pdf.

|||

Printing it out and looking closely, it appears the report footer in the 2nd sub-form just barely does not fit on the first page.

I cannot find any properties to control this, but maybe the glitch is caused by the report forcing the page footer to print on the same page as the rest of the sub-report.

I then expanded the vertical white space in my 2nd sub-report, and the overall report printed as I had hoped (the 2nd sub-report correctly starts on the first page). The bad thing is now my 2nd sub-report has vertical white space on each record that I did not need added.

A start though.

Any thoughts?

I

|||

Just wanted to follow up, for other report developer's sake.

Maybe I caught a glitch with SQL reporting services, in which the footer forces the entire sub-form to move to the next page? Maybe this is already known?

Any thoughts?

Thank you!

T.J.