Page Header Change with respective to table data

Question

question

NAG1234 asked Nov 3, '11

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-2005 sql t-sql ssrs ssrs-2005

10 |1200

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

Answer 1 · 2011-11-03T10:26:57Z

WilliamD answered Nov 3, '11

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

10 |1200

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

NAG1234 commented · Nov 03, 2011 at 01:57 PM

Hi William can you explain a little bit more in detail I am a new user of SSRS 2005. Thanks a lot

0 ·

Answer 2 · 2011-11-10T14:10:00Z

NAG1234 answered Nov 10, '11

Can you please help me how to set up Boolean value I need it very urgent.

10 |1200

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

question