Exporting to Excel without Group

• yogesh_pandey

  SSC Veteran

  Points: 204

  More actions

  February 26, 2010 at 9:45 am

  #217331

  Hi,

  I have a report in SSRS 2008 with several grouping and formatting. I would like to export the report in Excel without groups so I can sort and perform other function in excel. How do I do it? Thank you in advance.

• checkai

  Hall of Fame

  Points: 3041

  More actions

  April 9, 2010 at 2:30 pm

  #1149369

  We've accomplished this with a parameter named "Data Only" that will hide the formatted/grouped table data and simply show a flat table of data.