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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
chris_199777
Frequent Visitor

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!

 

Image0Image0Image2Image2StructureStructureImage1Image1

 

 

 

 

 

 

 

2 REPLIES 2
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.

 

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).

Image4Image4Image3Image3

 

 

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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