Post reply

SSRS - Can we export different reports as separate excel sheets into one excel workbook?

  • September 26, 2011 at 3:07 pm

    #257742

    Hi,

    SSRS 2005

    Can we export different reports as separate excel sheets into one excel workbook?

    From SSRS and may be using SSIS OR Any Other Possibility?

    Any idea, if this is possible in SSRS 2008 Now? just for info but solution required in 2005.

    Thanks.

  • September 26, 2011 at 3:16 pm

    #1386846

    Make a master report with subreports on it. It'll export all into 1 workbook on different worksheet (might have to set new page on the subreport for that, but I'm sure the export will do just what you need).

  • September 29, 2011 at 12:42 am

    #1388193

    Excellent! yes it works. However, the next proble is sheet names in the same workbook.

    They appears as sheet1, sheet2,sheet3.....

    But with one individual report and export it actualy gives the sheet correct name as report name.

    So any work around?

    Thanks.

  • September 29, 2011 at 5:40 am

    #1388292

    MidBar (9/29/2011)

    Excellent! yes it works. However, the next proble is sheet names in the same workbook.

    They appears as sheet1, sheet2,sheet3.....

    But with one individual report and export it actualy gives the sheet correct name as report name.

    So any work around?

    Thanks.

    Takes at least SSRS 2008 R2.

Viewing 4 posts - 1 through 3 (of 3 total)

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