Forum Discussion

chris_199777's avatar
chris_199777
Frequent Visitor
2 years ago

Report Builder - Header and footer problems in print layout mode

Hello, as the the subject suggests

 I have some problems in print layout mode with header and footer section. 

 

Overview

I have two datasets:

  • First data set has only one row that it needs to be displayed on the header section of every report page
  • Second data set has multiple rows which they are "linked" to the row in the first data set. These rows has to be displayed on the body section: I need to display one row per report page, so one instance per page. 

I would like to divide the page as a standard page with Header, Body and Footer with A4 size.

The structure of the page in normal executed mode is displayed on the Image0

 

Report's goal:

Header Section

I need to display data from the first data set as you can see on the attached image.

 

Body Section

I need to display data from the second data set, one row per report page

 

Footer Section

I need to display only a static item.

 

The problems

Print layout mode problems:

- Part of the header is cut out (Image 1). Comparing Image1 and Image0 you can see that DataQuattro, DataTre, DataDue and DataUno disappeared. Why?

- Although body has to display only one row it has a lot of space for itself (Image1);

- Comparing Image2 and Image0, you can see that, when the report is on the second page, the body part moves up in Image2 (it represents the second page of the report). Why?

 

I also will attach an image of the structure of the report (Structure).

 

Thank you in advance!

 

Image0Image2StructureImage1

 

 

 

 

 

 

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi chris_199777 ,

    For the part of the header being cut out, this could be related to the rendering process in print layout mode. When designing headers and footers in paginated reports, it's crucial to ensure that the content fits within the designated space for the header. This space is determined by the page size and margins. If the content exceeds this space, it might not be displayed correctly in print layout.

     

    Ensure that the page size and margins are correctly set to accommodate the header content. You can adjust these settings in the Page Setup dialog.
    If the header content is too wide or tall for the allocated space, consider resizing or repositioning items within the header.

    More details: Print a report (Power BI Report Builder) - Power BI | Microsoft Learn

     

    How to Get Your Question Answered Quickly - Microsoft Fabric Community

     

    If it does not help, please provide more details.

     

    Best Regards
    Community Support Team _ Rongtie

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

     

    • chris_199777's avatar
      chris_199777
      Frequent Visitor

      Thank you for your reply!

       

      I tried to adapt and resize the report and the elements header, body and footer, but I had the same problem.

       

      I removed margin from the report page size and set the A4 size. Everything, width and height, have the proper size.

       

      I attach the result in print layout mode (Image3) and in developing mode (Image4).

      Image4Image3