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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors