exporting multiple reports into one Excel Book

Hello,
Is there a way to export multiple reports(lets say 2 different reports) into
one Excel book at the same time'
please help
--
Saptagiri Tangudu
PNT Marketing ServicesOne way to do it would be to add these reports to a parent report as
subreports and export the parent report.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Saptagiri" <saptagiri@.gmail.com> wrote in message
news:5A547A03-455A-4B65-894B-EEBF3A41FBDC@.microsoft.com...
> Hello,
> Is there a way to export multiple reports(lets say 2 different reports)
into
> one Excel book at the same time'
> please help
> --
> Saptagiri Tangudu
> PNT Marketing Services|||The sub report seems to have limitations, and also does not render as a
seperate sheet in an Excel book.
We produce serveral Excel reports to be distributed to various branches of a
major bank. I created the reports in the Visual studio editor, and am using a
C# program which supplies the branch name as a parameter and procudes the
excel book reports. now I want to be able to produce several reports into one
excel book at the same time.
Is there a way i can produce these excel books with multiple reports other
than using the sub report technique'
thanks a bunch...
Saptagiri Tangudu
PNT Marketing Services
"Ravi Mumulla (Microsoft)" wrote:
> One way to do it would be to add these reports to a parent report as
> subreports and export the parent report.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Saptagiri" <saptagiri@.gmail.com> wrote in message
> news:5A547A03-455A-4B65-894B-EEBF3A41FBDC@.microsoft.com...
> > Hello,
> >
> > Is there a way to export multiple reports(lets say 2 different reports)
> into
> > one Excel book at the same time'
> >
> > please help
> >
> > --
> > Saptagiri Tangudu
> > PNT Marketing Services
>
>|||After the reports are generated, you could use Excel object model to merge
the files into one file.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Saptagiri" <saptagiri@.gmail.com> wrote in message
news:CD494DE2-7107-4892-94A9-97A126EA175D@.microsoft.com...
> The sub report seems to have limitations, and also does not render as a
> seperate sheet in an Excel book.
> We produce serveral Excel reports to be distributed to various branches of
a
> major bank. I created the reports in the Visual studio editor, and am
using a
> C# program which supplies the branch name as a parameter and procudes the
> excel book reports. now I want to be able to produce several reports into
one
> excel book at the same time.
> Is there a way i can produce these excel books with multiple reports other
> than using the sub report technique'
> thanks a bunch...
> Saptagiri Tangudu
> PNT Marketing Services
> "Ravi Mumulla (Microsoft)" wrote:
> > One way to do it would be to add these reports to a parent report as
> > subreports and export the parent report.
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > "Saptagiri" <saptagiri@.gmail.com> wrote in message
> > news:5A547A03-455A-4B65-894B-EEBF3A41FBDC@.microsoft.com...
> > > Hello,
> > >
> > > Is there a way to export multiple reports(lets say 2 different
reports)
> > into
> > > one Excel book at the same time'
> > >
> > > please help
> > >
> > > --
> > > Saptagiri Tangudu
> > > PNT Marketing Services
> >
> >
> >|||Thanks...
Saptagiri Tangudu
PNT Marketing Services
"Ravi Mumulla (Microsoft)" wrote:
> After the reports are generated, you could use Excel object model to merge
> the files into one file.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Saptagiri" <saptagiri@.gmail.com> wrote in message
> news:CD494DE2-7107-4892-94A9-97A126EA175D@.microsoft.com...
> > The sub report seems to have limitations, and also does not render as a
> > seperate sheet in an Excel book.
> >
> > We produce serveral Excel reports to be distributed to various branches of
> a
> > major bank. I created the reports in the Visual studio editor, and am
> using a
> > C# program which supplies the branch name as a parameter and procudes the
> > excel book reports. now I want to be able to produce several reports into
> one
> > excel book at the same time.
> >
> > Is there a way i can produce these excel books with multiple reports other
> > than using the sub report technique'
> >
> > thanks a bunch...
> > Saptagiri Tangudu
> > PNT Marketing Services
> >
> > "Ravi Mumulla (Microsoft)" wrote:
> >
> > > One way to do it would be to add these reports to a parent report as
> > > subreports and export the parent report.
> > >
> > > --
> > > Ravi Mumulla (Microsoft)
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > "Saptagiri" <saptagiri@.gmail.com> wrote in message
> > > news:5A547A03-455A-4B65-894B-EEBF3A41FBDC@.microsoft.com...
> > > > Hello,
> > > >
> > > > Is there a way to export multiple reports(lets say 2 different
> reports)
> > > into
> > > > one Excel book at the same time'
> > > >
> > > > please help
> > > >
> > > > --
> > > > Saptagiri Tangudu
> > > > PNT Marketing Services
> > >
> > >
> > >
>
>|||Hi ,
Can you please let me know How to use Excel object maodel and where to use it?
Please guide me.
TIA
"Ravi Mumulla (Microsoft)" wrote:
> After the reports are generated, you could use Excel object model to merge
> the files into one file.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Saptagiri" <saptagiri@.gmail.com> wrote in message
> news:CD494DE2-7107-4892-94A9-97A126EA175D@.microsoft.com...
> > The sub report seems to have limitations, and also does not render as a
> > seperate sheet in an Excel book.
> >
> > We produce serveral Excel reports to be distributed to various branches of
> a
> > major bank. I created the reports in the Visual studio editor, and am
> using a
> > C# program which supplies the branch name as a parameter and procudes the
> > excel book reports. now I want to be able to produce several reports into
> one
> > excel book at the same time.
> >
> > Is there a way i can produce these excel books with multiple reports other
> > than using the sub report technique'
> >
> > thanks a bunch...
> > Saptagiri Tangudu
> > PNT Marketing Services
> >
> > "Ravi Mumulla (Microsoft)" wrote:
> >
> > > One way to do it would be to add these reports to a parent report as
> > > subreports and export the parent report.
> > >
> > > --
> > > Ravi Mumulla (Microsoft)
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > "Saptagiri" <saptagiri@.gmail.com> wrote in message
> > > news:5A547A03-455A-4B65-894B-EEBF3A41FBDC@.microsoft.com...
> > > > Hello,
> > > >
> > > > Is there a way to export multiple reports(lets say 2 different
> reports)
> > > into
> > > > one Excel book at the same time'
> > > >
> > > > please help
> > > >
> > > > --
> > > > Saptagiri Tangudu
> > > > PNT Marketing Services
> > >
> > >
> > >
>
>