rendering to multiple Excel Workbooks from one Report in Reporting Services 2005

Hi Folks,

Is there a way in Reporting Services 2005 to render 1 report into multiple Excel Workbooks?

The report we have already renders to multiple Excel "pages" from the Report, but we need to find out if we can also break and render into a NEW Workbook, based on Groups, for example.

Thanks in advance for any help.

Glen Plantz

Sorry, it's not possible to export one report to multiple workbooks.

You could possibly achieve this by requesting multiple exports with each one receiving different parameter values.

-chris