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.