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!
How to embed group name on the header?
I successfully made invoices to my customers, using the following post directions. https://community.fabric.microsoft.com/t5/Desktop/Single-Company-Data-in-each-page-using-Power-BI-Report-Builder/td-p/2389714 But my customers purchase details are too many to fit on one page. There are 2 or 3 pages at each customer. So, I want my report header that has current customer name. How can I do this? I tried =First(ReportItems!Tablix2.Value) (or something like this) on the textbox in the header, but it does not work.
