Exporting to Excel

I've created several reports in VS2005 and have deployed them to my RS.
I would like each one of these reports to be a seperate worksheet in an
Excel workbook.
Is it possible to Export multiple reports as seperate worksheets to one
Excel workbook'
Thanks
--
ChrisOn May 7, 11:45 am, Chris <C...@.discussions.microsoft.com> wrote:
> I've created several reports in VS2005 and have deployed them to my RS.
> I would like each one of these reports to be a seperate worksheet in an
> Excel workbook.
> Is it possible to Export multiple reports as seperate worksheets to one
> Excel workbook'
> Thanks
> --
> Chris
If you place all of the reports into one report this can work.
Create a new report. Place each report as a sub report in the new
report. Then make "page breaks" after each sub report. The page break
should create a new worksheet in the excel document.
D. Spohn|||Thank you so much!
--
Chris
"dspohn" wrote:
> On May 7, 11:45 am, Chris <C...@.discussions.microsoft.com> wrote:
> > I've created several reports in VS2005 and have deployed them to my RS.
> > I would like each one of these reports to be a seperate worksheet in an
> > Excel workbook.
> > Is it possible to Export multiple reports as seperate worksheets to one
> > Excel workbook'
> >
> > Thanks
> > --
> > Chris
> If you place all of the reports into one report this can work.
> Create a new report. Place each report as a sub report in the new
> report. Then make "page breaks" after each sub report. The page break
> should create a new worksheet in the excel document.
>
> D. Spohn
>|||I have a report with 3 sub reports where I placed page breaks after each one.
When I deploy to my RS and run the report it does come up with 4 pages, but
when I select Excel and then export only 3 worksheets are created instead of
4. Do you have any idea why this is happening'
Thanks in advance.
--
Chris
"Chris" wrote:
> Thank you so much!
> --
> Chris
>
> "dspohn" wrote:
> > On May 7, 11:45 am, Chris <C...@.discussions.microsoft.com> wrote:
> > > I've created several reports in VS2005 and have deployed them to my RS.
> > > I would like each one of these reports to be a seperate worksheet in an
> > > Excel workbook.
> > > Is it possible to Export multiple reports as seperate worksheets to one
> > > Excel workbook'
> > >
> > > Thanks
> > > --
> > > Chris
> >
> > If you place all of the reports into one report this can work.
> >
> > Create a new report. Place each report as a sub report in the new
> > report. Then make "page breaks" after each sub report. The page break
> > should create a new worksheet in the excel document.
> >
> >
> > D. Spohn
> >
> >