Menu
So I am running into the problem where my report header is being displayed on every page, but I only want to display it on the first page. The solution that people on this forum have given is to just put the header in the main content. The problem with this is that my header shows the page number + total pages (i.e. Page 1 of 3 pages). I cannot move my header to the body because I will lose access the page numbers. For some reason, Report Builder will only allow you to have access to the page numbers via the header. Does anyone have any solution to this problem?
795
To display column headers on multiple pagesRight-click the row, column, or corner handle of a tablix data region, and then click Tablix Properties. In Column Headers, select Repeat header columns on each page. Select OK.
To add a page header or footer On the design surface, right-click the report, point to Insert, and then click Header or Footer.
To add a page number or other report properties In the Report Data pane, expand the Built-in Fields folder. If you don't see the Report Data pane, on the View tab, check Report Data. Drag the Page Number field from the Report Data pane to the report header or footer.
On the right side of the grouping pane, click the down arrow, and then click Advanced Mode. Click the static member (row or column) that you want to remain visible while scrolling. The Properties pane displays the Tablix Member properties. In the Properties pane, set FixedData to True.
Write an expression to hide the textboxes that hold the header information.
The expression would look like this:
=iif(Globals!PageNumber = 1, FALSE, TRUE)
To get to the expression property: right-click text box >> text box properties >> visibility >> select "Show or hide based on expression" >> insert expression above
cheers
110
I had the same issue, where I only wanted the header to show on the first page. The solution I came up with was to stick all of my objects from the header into a rectangle, so it was now acting as a container. I then placed that container into the body. In the report properties, in the code section, I borrowed from this post Access Page number in report body In SSRS to create functions, which would allow me to pull the page numbers into the body section. Then in my rectangle/container, I set the visibility property to =code.PageNumber>1. I hope this helps!
36
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
