Pages

Social Icons

Thursday 10 November 2011

Manipulate Header and Footer values at each page


Generally in SSRS Header and Footer value is same for a report. Sometime we require to show different value in the footer or header on the bases of database of each page of SSRS.
For acheiving this we have to refer textbox name which is in report area or if it is not there we have to create a text box and give that value which we want to show in header or footer then we can hide it. Refer Text Box Name AS : ReportItems!Textbox208.value
Now in Header or footer for text box’s expression we can use = ReportItems!Textbox208.value.


With the help of this we can get different value in header and footer at each page of report.

No comments:

Post a Comment