Forum Discussion
Paginated Report Matrix with Dynamic Columns Causing PDF Export Issues
Hi NB8,
Thank you for the clarification and for confirming that you have already tested the previously suggested settings.Regarding your question about repeating row headers across horizontal pages, Microsoft documents Repeat header rows on each page under Tablix Properties > Row Headers for a tablix data region.
For more specific control, Microsoft also documents using Advanced Mode in the Grouping pane to select the appropriate static row member and set:
• RepeatOnNewPage = True
• KeepWithGroup = AfterThe selected static tablix member then repeats on each page that the tablix spans. Microsoft also notes that RepeatOnNewPage isn't supported for column group members.
For the PDF behavior, Microsoft explains that PDF uses a hard-page-break renderer. The physical page size determines where horizontal and vertical page breaks occur, and the page size doesn't automatically grow or shrink to accommodate the report body. If the report body extends beyond the physical page width, a horizontal page break is inserted.
For the blank-page issue, since you have already checked the previously mentioned settings, Microsoft recommends ensuring that the report body width doesn't exceed the available page width:
Report body width <= Report page width - (Left margin + Right margin)
Microsoft also recommends removing unnecessary trailing space from the report body and checking that unnecessary page breaks aren't enabled.
Based on these documented behaviors, you can verify the appropriate static row members in the matrix and confirm that the repeating-header properties are configured as described above.
For more details, please refer to the below official Microsoft documentation:
Show Row and Column Headers on Multiple Pages in a Power BI Paginated Report - Power BI | Microsoft LearnPagination in Power BI Paginated Reports - Power BI | Microsoft Learn
Avoid blank pages when printing paginated reports - Power BI | Microsoft Learn
I hope this clarifies the expected behavior and the relevant settings to check.
Thank you.
Hi v-abhinavmu,
Thank you for checking in. At this time, the issue has not been resolved. I reviewed and tested the suggested solutions, but they did not address the problem in my scenario.
I am still looking for a solution and would appreciate any further assistance or recommendations from the community.
Thank you.
Community SupportHi NB8,
Thanks for the update. I would recommend checking the following areas based on Microsoft's guidance for paginated reports:
• For a dynamic matrix, the Product Type column group can expand horizontally and the PDF renderer can paginate the matrix across multiple pages. Consider using landscape orientation, appropriate margins/column widths, and repeating row headers across horizontal pages for readability.
• For the unexpected blank pages, first verify that the report body width doesn't exceed the available page width:
Report body width <= Page width - (Left margin + Right margin)
• Also check for excess whitespace below the report body, unnecessary page breaks on the matrix/groups, and the ConsumeContainerWhitespace property.
• Use Print Preview to determine how the report is being split into physical pages before exporting to PDF.
For more details, please refer to the below Official Microsoft documentation:
Avoid blank pages when printing paginated reports - Power BI | Microsoft Learn
Rendering Behaviors in a Power BI Paginated Report - Power BI | Microsoft Learn
I hope this helps. Please feel free to reach out if you have any further questions.
Thank you.
- v-abhinavmu
Hi NB8,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.Hi @v-abhinavmu ,
Thank you for the suggestions. I have already tested all of the recommendations mentioned, including page width, margins, whitespace, page breaks, ConsumeContainerWhitespace, and Print Preview. The extra blank page is still present in the PDF export.
Regarding "repeating row headers across horizontal pages," could you clarify the expected behavior? My understanding is that the row header should reappear when dynamic columns continue onto the next page, but I was unable to achieve this in my report.
Any further guidance would be appreciated.
Thanks
- v-abhinavmu
Hi NB8,
Thank you for the clarification and for confirming that you have already tested the previously suggested settings.Regarding your question about repeating row headers across horizontal pages, Microsoft documents Repeat header rows on each page under Tablix Properties > Row Headers for a tablix data region.
For more specific control, Microsoft also documents using Advanced Mode in the Grouping pane to select the appropriate static row member and set:
• RepeatOnNewPage = True
• KeepWithGroup = AfterThe selected static tablix member then repeats on each page that the tablix spans. Microsoft also notes that RepeatOnNewPage isn't supported for column group members.
For the PDF behavior, Microsoft explains that PDF uses a hard-page-break renderer. The physical page size determines where horizontal and vertical page breaks occur, and the page size doesn't automatically grow or shrink to accommodate the report body. If the report body extends beyond the physical page width, a horizontal page break is inserted.
For the blank-page issue, since you have already checked the previously mentioned settings, Microsoft recommends ensuring that the report body width doesn't exceed the available page width:
Report body width <= Report page width - (Left margin + Right margin)
Microsoft also recommends removing unnecessary trailing space from the report body and checking that unnecessary page breaks aren't enabled.
Based on these documented behaviors, you can verify the appropriate static row members in the matrix and confirm that the repeating-header properties are configured as described above.
For more details, please refer to the below official Microsoft documentation:
Show Row and Column Headers on Multiple Pages in a Power BI Paginated Report - Power BI | Microsoft LearnPagination in Power BI Paginated Reports - Power BI | Microsoft Learn
Avoid blank pages when printing paginated reports - Power BI | Microsoft Learn
I hope this clarifies the expected behavior and the relevant settings to check.
Thank you.