Multiple Subreports with page break

[rayc]

I have a main report that has four subreports. I need each subreport to begin on a new page. The problem is that whenever a subreport has no data, I get a blank page at the end of my report.

All my sections have CanShrink to Yes. All my subreport placeholders have the same CanShrink to Yes. Why do I still get a blank page?

Thanks in advance.
Ray

[matthewspatrick]

Are all of these subreports in the same section of the main report? If so, did you put in page break controls? If not, do you have the sections configured to start new pages after the section?

[rayc]

I originally tried to put the subreports in the same section with page breaks, but that caused page breaks when subreports were empty, causing a blank page at the end, sometimes in the middle.

So I decided to create 4 separate sections (one for each subreport) and then I configured the sections to start a new page after each section. Again, that caused a blank page at the end, whenever the last subreport had no data.

The problem is that there's no way of knowing which subreport will have no data (that is always possible). Access then adds a page break.

Thanks!

[matthewspatrick]

Do your subreports all have the same layout? If so, we may be able to get creative using a UNION query for your source...

[rayc]

Yes, they do have the same layout but keep in mind, each subreport has very specific conditions. The queries behind each subreport are not trivial.

Thanks!

[matthewspatrick]

That's OK. Can you post the SQL for each query?

[rayc]

Patrick,

I solved my problem.

It was a good idea that I placed the subreports in separate sections. However, I found that I had some sections' KeepTogether property to yes.

This forced page breaks whenever the section couldn't fit on the remaining page. So I set all KeepTogether's to No. Then I placed PageBreak controls in each of the sections. With a little code behind the OnFormat of each section I set the PageBreak controls to False and/or True depending on the HasData property of my subreports.

Everything is fine now.
Thanks !

Ray

[matthewspatrick]

Glad you got it working, Ray