SSRS Report Designer - Only show headers on the first page (with page numbers)

So, I ran into a problem when the title of my report is displayed on every page, but I want to show it only on the first page. The solution that people on this forum have provided is simply to put the title in the main content. The problem is that my title shows the page number + common pages (i.e. Page 1 of 3 pages). I cannot move my title to the body because I will lose access to page numbers. For some reason, the report builder will only have access to page numbers through the header. Anyone have a solution to this problem?

+7
source share
2 answers

Write an expression to hide text fields containing header data.

The expression will look like this:

=iif(Globals!PageNumber = 1, FALSE, TRUE) 

To get an expression property: right-click the text field → text field properties → visibility → select Show or hide based on expression → paste the expression above

amuses

+12
source

I had the same problem when I wanted the title to appear on the first page. The solution I came across was to insert all my objects from the header into a rectangle, so it now became a container. Then I put this container in the body. In the report properties in the code section, I borrowed from this message the Access Page Number in the report body in SSRS to create functions that would allow me to display page numbers in the body. Then in my rectangle / container I set the visibility property = code.PageNumber> 1. Hope this helps!

+2
source

All Articles