Export the report data into 1 EXcel with multiple worksheets

• vijay1327-891581

  SSC Veteran

  Points: 225

  More actions

  September 6, 2012 at 4:02 am

  #261574

  Hello,

  I have the requirement where I need to export the MATRIX report to an EXCEL. This report has multiple groups and I would like to export each of these groups into different worksheet of the same excel sheet. I tried using the PAGEBREAK option on the GROUP that I have created but no luck. I am not sure I am missing anything or doing this completely wrong way.

  If anyone has a solution or approach to this requirement please let me know.

  Thanks,

  Vijay

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  September 6, 2012 at 10:39 am

  #1534630

  This probably belongs in one of the Reporting Services/SSRS forums.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]