CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2012
Vidhselva
Vidhselva

Reputation: 117

How to dynamically change the height of the page header in SSRS?

We have a requirement that displaying different information on the page header of odd/even pages. So obviously both should be different height as per the text placement in the page header. We want to know that how to dynamically change the height of the page header.

As of now its taking constant height in page header through out all of the pages.

Upvotes: 0

Views: 1751

Answers (2)

Vidhselva
Vidhselva

Reputation: 117

Yes I have done the so many investigation that we couldnt control the height of the Report header/footer by dynamically as of sql server 2012 version. Height of the report header and footer is constant for all the pages.

Upvotes: 1

Peter
Peter

Reputation: 850

The height property of the header does not support expressions, but there is a workaround that may work for you.

You can show or hide text boxes based on an expression. Use =iif(Globals!PageNumber Mod 2,True,False) for the textboxes you want on the even pages. Use =iif(Globals!PageNumber Mod 2,False,True) for texboxes you want to see on the odd pages.

Upvotes: 0

Related Questions