exporting multiple reports into one Excel Book

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Saptagiri - 28 Sep 2004 19:13 GMT

Hello,

Is there a way to export multiple reports(lets say 2 different reports) into
one Excel book at the same time??

please help

Signature

Saptagiri Tangudu
PNT Marketing Services

Reply to this Message

Ravi Mumulla \(Microsoft\) - 28 Sep 2004 22:27 GMT

One way to do it would be to add these reports to a parent report as
subreports and export the parent report.

Signature

Ravi Mumulla (Microsoft)
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.

> Hello,
>
> Is there a way to export multiple reports(lets say 2 different reports) into
> one Excel book at the same time??
>
> please help

Reply to this Message

Saptagiri - 29 Sep 2004 19:29 GMT

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.
[quoted text clipped - 6 lines]
> >
> > please help

Reply to this Message

Ravi Mumulla \(Microsoft\) - 30 Sep 2004 15:47 GMT

After the reports are generated, you could use Excel object model to merge
the files into one file.

Signature

Ravi Mumulla (Microsoft)
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.

> The sub report seems to have limitations, and also does not render as a
> seperate sheet in an Excel book.
[quoted text clipped - 24 lines]
> > >
> > > please help

Reply to this Message

Saptagiri - 30 Sep 2004 15:57 GMT

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.
[quoted text clipped - 32 lines]
> > > >
> > > > please help

Reply to this Message

puneet - 28 Dec 2006 06:27 GMT

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.
[quoted text clipped - 32 lines]
> > > >
> > > > please help

Reply to this Message