rendering to excel

• sasi.tripuraneni

  Old Hand

  Points: 384

  More actions

  October 14, 2010 at 6:06 pm

  #225091

  hello,

  I have 5 categories report. I want to render each category to separate excel sheet and I want to name it as per category. please help me in this regard.......

  thanks in advance

  Sasi.

• SQLvis

  SSC Eights!

  Points: 851

  More actions

  November 8, 2010 at 1:56 pm

  #1247876

  You can create a new list/table/matrix for each categorization of data. Using the properties of the object, you can append a page break to the object. When exporting to excel (versions 2003 and up), the page breaks will render as separate worksheets within the same workbook.

  I'm not sure how you'd name worksheets though I've heard that R2 may support this by using the title of your tablix/list object.