question

NAG1234 avatar image
NAG1234 asked

Page Header Change with respective to table data

Hi I have a report with three tables Table 1, Table 2, Table 3. Each table has a page break. When the data in the table 1 shows, the page header needs to have page header name as "Summary".
When the table 2 data appears the page header name needs to be as "Detail".
When the table 3 data shows up the page header name needs to be "Equity". How can I achieve this in SSRS 2005? Some thing like dynamic page header name, changing with respect to table data.
sql-server-2005sqlt-sqlssrsssrs-2005
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image
WilliamD answered
You can make the header text a calculated value and use IIF statements to make your choice. You would need a boolean value to run the IIF, checking the data being presented in the table, then change the title as required.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

NAG1234 avatar image NAG1234 commented ·
Hi William can you explain a little bit more in detail I am a new user of SSRS 2005. Thanks a lot
0 Likes 0 ·
NAG1234 avatar image
NAG1234 answered
Can you please help me how to set up Boolean value I need it very urgent.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.