SSRS Report Builder - Only Show Header On First Page (With Page Numbers)

Question

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?

Phaeton

You should be able to put an expression on the text visibility or colour to make them hidden on all but page 1. – Wynellwynn

Answer 1

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

Tung

Answer 2

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!

Schweiker

This is actually a great idea. Sometimes it doesn't matter how it's done as long as it's done. – Accessary

Answer 3

I did this, just to make it easier the two functions you want to add to the Report that were linked above are,...

Function PageNumber() As String    
    Return Me.Report.Globals!PageNumber    
End Function

Function TotalPages() As String   
    Return Me.Report.Globals!TotalPages    
End Function

Logos