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.


at

3 comments:

  1. Pathan the Pioneer30 November 2011 at 06:56

    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. abs6 January 2012 at 14:18

    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. Unknown29 August 2012 at 17:22

    Superb, works perfectly

    Thanks

    ReplyDelete

Subscribe to: Post Comments (Atom)

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

  • Subscriptions SQL query
    Due to the fact the reporting services allows you to query the tables you can easily write SQL which will allow you to return data from the ...
  • Conditional Page Breaks in SSRS 2008 r2
    I have recently been looking at conditional page breaks in SSRS 2008 r2 and did not know that it is possible to do via an expression. For...
  • Alternate Colors in a Matrix/Pivot Table
    To add alternate colors in a matrix the expression should be as follows for the row group: =IIf( RunningValue (Fields!FIELDNAME.Value, Co...