topic Re: Report Builder - Header and footer problems in print layout mode in Report Server

Report Builder - Header and footer problems in print layout mode

chris_199777 — Wed, 10 Apr 2024 11:40:38 GMT

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!

Re: Report Builder - Header and footer problems in print layout mode

Anonymous — Thu, 11 Apr 2024 03:09:20 GMT

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.

Re: Report Builder - Header and footer problems in print layout mode

chris_199777 — Thu, 11 Apr 2024 14:30:05 GMT

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