sql server reporting services: It seems that you can't dynamically choose visibility for the header or
footer. It's either on or off. But you can control the visibility of
elements on the header and footer.

Create a footer. Set DisplayOnFirstPage and DisplayOnLastPage = Yes
Add a rectangle. Add controls to the footer inside the rectangle.
On the Visibility parameter of the rectangle, type
=IIF(Globals!PageNumber>1, False, True)

If your report stretches over 2 or more pages, you will see the content of
the rectangle on page 2 and out. You can change the expression according to
your needs, this was just a quick example.



Kaisa M. Lindahl Lervik



[quoted text, click to view]

I need to show or hide Page Header and Footer on the last page of a report
based on a parameter. Is there a way of doing this?

Thanks in advance

the same way :)

From http://www.developmentnow.com/

Posted via DevelopmentNow.com Groups