Post reply

rendering to excel

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

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply