Report Export to excel with sheet name same as group name

• p.nagaravikumar

  SSC Eights!

  Points: 844

  More actions

  July 22, 2008 at 1:30 am

  #210251

  Hi,

  I am exporting the report which is grouped by fieldname then i selected the grouping and sorting properities and in expression selected the field name and set the page break and end check box.then exported to excel.Actual report consists of A ,B,C field names under field name group.It is exported to excel in 3 excel sheets separetly. but i need the sheet name as A,B,C Like that instead of sheet1,sheet2,sheet3..

  Please help me

• antonio.collins

  SSCrazy Eights

  Points: 9600

  More actions

  July 23, 2008 at 3:54 pm

  #847428

  you can do it by transforming report services XML output into Excel's XML format.

  http://spacefold.com/lisa/post/Changing-the-Sheet-names-in-SQL-Server-RS-Excel-QnD-XSLT.aspx