Why do multiple subreports forces page break ?

[Former Member]

I have a report that uses many subreports, some have varying amount of data.

If the page is printed halfway down and the next subreport is larger than the rest of the previous page, a page break occurs which leaves much blank space on the report.

I would like each subreport to be printed immediately after the previous subreport so that there is no page break.

Can this be done in CR 13 on VS 2010?

Thanks 🙂 .

[former_member292966 · Accepted solution]

Hi Anas,

Subreports are container objects and do not have a concept of the main report's paging. It works similar to images or tables in Word. If add an image onto a page and that image is larger than the remaining free space on that page, Word will start it on a new page.

Brian

[vitaly_izmaylov]

Page break usually caused by "Keep together" settings. There are two places to uncheck: in the Section Expert for the section where the subreport is located and for the subreport itself - right-click the subreport in Design mode and select Format

[Former Member]

Thx Vitaly but i already tried this and it still don't work .

[Former Member]

Thx for the answer Vitaly but i already tried this and it still don't work.

[vitaly_izmaylov]

You probably need to uncheck "Keep Together" in the subreport as well for the section where the text located and right click the Text field select format and uncheck "Keep Object together"

If Subreport is located in the Group section then there is a "Keep Group Together" check as well in Group Section.

[Former Member]

Thx brian that's exactly what i noticed ! is there any other way to do it in your opinion ?

[former_member292966]

Hi Anas,

The only way I've been able to work around it is to not use subreports. I created a Stored procedure and put the logic for the main report and the subreports into the Stored Procedure. This gave me all the records in one result set. This allowed me to create a group for each subreport and drop the records into the appropriate section.

Good luck,

Brian