Forum Discussion

NB8's avatar
NB8
New Member
1 month ago

Paginated Report Matrix with Dynamic Columns Causing PDF Export Issues

Hi everyone, I'm working on a Paginated Report (RDL) that contains a matrix. The matrix columns are grouped by Product Type, so the number of columns grows dynamically depending on the data returned...
data hub
v-abhinavmu's avatar
v-abhinavmu
Icon for Community Support rankCommunity Support
25 days ago

Hi NB8​,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to ShivekMaharaj​ for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

Thank you for being part of the Microsoft Fabric Community.

 

NB8's avatar
NB8
New Member
25 days ago

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.

  • v-abhinavmu's avatar
    v-abhinavmu
    Icon for Community Support rankCommunity Support
    21 days ago

    Hi 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

    Control row & column headings in a paginated report - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn

    I hope this helps. Please feel free to reach out if you have any further questions.
    Thank you.

    • v-abhinavmu's avatar
      v-abhinavmu
      Icon for Community Support rankCommunity Support
      18 days ago

      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.

      • NB8's avatar
        NB8
        New Member
        17 days ago

        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