Tuesday 26 October 2010

Exporting to Excel and renaming sheets in 2008 R2

In Reporting Services 2008 R2 Microsoft has added functionality to rename multiple sheets, so if your report is more than one page and you want to rename the worksheets this will work automatically out of the box.

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.


3 comments:

  1. Hi,

    I 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

    ReplyDelete
  2. 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'.
    Let me know how you get on.

    ReplyDelete
  3. Superb, works perfectly

    Thanks

    ReplyDelete

Keep SSRS (SSRS2016) report manager awake

When running a report for the first time in report manager it takes a while to run, after this initial run reports run fine.  There are a ...