How do I get a subreport on just the last page of an SSRS report with generating a blank page when it has no results?

Question

We have an Electronic Health Record Service with a report that displays patient health screens with page breaks between each patient.

A subreport was added outside this group to display all patients who do not have a health screen saved in our system based on the parameters passed to the initial report. We want this report to be displayed on its own page(s) after the initial dataset. We've done this by checking the 'also at the end' page break option.

We've found that when there's no result set returned from SQL (as happens depending on the parameters passed) we still get a blank page and have found no alternate way of getting the subreport on it's own page.

We're wondering if there's a way to disable the 'also at the end' page break option only if there are no results in the subreport.

I don't know if this will be helpful but here's a mockup for the visual:

Answer 1

Hi @Kyle Coleman

I think you can put the subreport in a rectangle and then control the pagination of the subreport through the rectangle.

I did a simple test, created a subreport placed in a rectangle, and created a parameter Product to pass the parameters.

Then in the rectangle's PageBreak property, set the value of BreakLocation to "Start". Then use an expression in the value of Disabled, that is, when the parameter is empty, the page break is disabled, otherwise the page break is enabled.

Preview:

Last page when subreport has no results:

Last page when the subreport has results:

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya