Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Cayshin
Frequent Visitor

Report Builder: Printing a matrix, paginated report has extra blank pages

I've created what I think is just a simple report where I'm trying to print a matrix. This is a 4x4 matrix

Cayshin_0-1644595702692.png

 

When I print this report, this is what the page order looks like:

Cayshin_1-1644595868421.png

 

Take note of the blank pages. In the above, Page 1 and Page 5 are the first cell of the matrix, Page 2 and Page 6 are the next cell (going left to right, top to bottom), Page 3 and Page 7 are the next, and so on and so forth. I've noticed this is caused by one cell overflowing onto a second page.

 

So because the cell in what is Page 3 above exceeded the page height and overflowed onto another page, Report Builder did not simply add the overflow page as the next page, it instead continued to add all of the "Page 1"s for each cell then loop back around and add the "Page 2"s of each cell. Then it continues onto the next row and does the same thing: It adds all the "Page 1"s for those cells then, if one or more of the cells exceeded the page height, it adds the "Page 2"s, then possibly even going to "Page 3"s and "Page 4"s if necessary. Each time it does this, for the cells that didn't exceed the page height, they get blank pages added.

 

How do I get Report Builder to stop this behavior? I don't want any blank pages and would like the overflow pages printed immediately after the page they should be after. As is, I have to manually go into the PDF to rearrange and delete pages.

 

Thank you

1 REPLY 1
v-yangliu-msft
Community Support
Community Support

Hi  @Cayshin ,

You can try exporting the report to a hard page format (such as PDF or Microsoft Word) or printing to avoid blank pages:

https://docs.microsoft.com/en-us/power-bi/guidance/report-paginated-blank-page

 

This is the related document, you can view this content:

https://community.powerbi.com/t5/Report-Server/PowerBI-Report-Builder-still-prints-blank-pages/m-p/2...

https://cs.thomsonreuters.com/ua/acct_pr/acs/cs_us_en/report_editor/rpt_ed_proc/proc-removing-blank-...

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors