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.
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.