Blank Pages Issue When Hiding Rows Based on Parameter Value in Power BI Report Builder

[choime]

I am experiencing an issue in Power BI Report Builder with a report composed of group rows and a subreport named “packing list” at the bottom. To print the subreport on a new page, I have set a page break at the end of the group row above it. The subreport’s visibility is controlled by a specific parameter value (Parameters!non_packing.Value), hiding the subreport when the parameter value is 0.

When the subreport is hidden and the main report spans only one page, a blank page is added. However, this issue does not occur if the main report spans more than two pages. Additionally, if I hide the subreport without using the parameter value, no blank pages appear. This suggests there might be an issue with the handling of page breaks and visibility settings based on parameter values. Please assist in resolving this issue.

[choime]

Hi Carson Jian,

Thank you once again for your suggested solutions. I have reviewed the points you mentioned, but the issue still persists.

1. Report Size: The report size is set to A4 with a width of 21 cm, and the width of the main content and the actual data table is 18.7 cm. The sub-report has the same dimensions.
2. ConsumeContainerWhitespace Setting: Both the main report and the sub-report have the ConsumeContainerWhitespace property set to False.
3. Blank Page Occurrence: The blank page appears when the sub-report is hidden and the main report content is only one page long. If the main report content spans more than one page, the blank page does not appear.
4. Display Option: When the report is initially run and the display option is set to hide based on an expression, the blank page does not appear.

Given these conditions, the blank page issue remains unresolved. I would appreciate any further advice or solutions you might have.

[Anonymous]

Hi,@choime .I am glad to help you.

The general cause of blank pages is related to the layout settings of the report, although the sub-report has been hidden by the parameter, but you mentioned that you set the paginated reports, which may cause the report to unexpectedly appear blank pages after printing.
Your current problem is that when the actual content is just about ready to be displayed on the same page of the paginated reports, there is still content that cannot be displayed properly, so this part is displayed on the next page, but in the actual printing process, this part is displayed as blank, so there is a blank page. When the content of the main table is displayed as two pages, the size of the two pages is just enough to display all the contents of the paginated reports, so the normal display of reports.

You may need to double check the layout settings, hopefully the link below will help:

URL:
Avoid blank pages when printing paginated reports - Power BI | Microsoft Learn
Solved: Power BI Report Builder paginated report page brea... - Microsoft Fabric Community
 I'll follow up with the relevant tests to try to reproduce your problem.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.