You can either rename the sheets for a group, if each group has a page break between them or you can rename sheets if there is page break between objects.
To rename sheets in a table with groups all you have to do is select the group as shown below and then in the properties window (press F4 if the properties window is not shown) change the setting for pagename under the Group section to the value you want. This could be text or a field from your dataset.
The export to excel will rename the sheets with the group name.
Hi,
ReplyDeleteI have follow the steps as you have suggested me to Renaming of Sheets when get exported into Excel from SSRS, But it is not working for me. I have two sheets. Both have name Sheet1, Sheet2 respectively.
Plz help me :- Mail me at pioneerpathan@gmail.com
Hi, Have you created a page break between the groups ? you need right click on the group and go to properties and then page breaks and check the tickbox 'between each instance of a group'.
ReplyDeleteLet me know how you get on.
Superb, works perfectly
ReplyDeleteThanks