July 7, 2008 at 4:05 am
Hi,
I have created a report in SSRS, with 2 tables and I have set the property to insert a page break after table1.
This of course will ensure that table1 is on sheet1 and table2 is on sheet2 of the exported excel file.
I know I cant rename the sheets, so I want to add a header at the top of each sheet.
So for sheet1 the header must be 'header1' and for sheet2 the header must be 'header2'.
These different headers should also display like that on the report itself.
How will I accomplish this - different headers for each sheet?
July 8, 2008 at 8:07 am
Have you tried adding the entire report header into the table header? You can either do this (I have used this for reports where information from a group needs to be on the header... adding log and all to the group header in the table) or you could add a text box with an IIF to check the page number.
July 8, 2008 at 8:39 am
thank you so much!!!
adding it as a table header works great.
July 8, 2008 at 8:44 am
Your Welcome! Glad it helped.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply