Performance Question

Just curious if anyone has experience with this.
SSRS2005
I have a report that has a dataset and populates a table.
I have 8 sub-reports that are placed on this report.
Is this approach the best for performance, or should I add the other 8
datasets to this one report,
and then include a table for each of them.
Just wondering what kind of overhead this is creating using the Sub Reports.
Thanks in advance for your reply'sIt sounds like this not a master-detail type of thing. I use subreports if I
plan on using the report inside multiple reports or if I am doing
master-detail. Otherwise I put it all in the same report.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris" <cexley@.enableconsulting.com> wrote in message
news:%23Fgv55x4GHA.772@.TK2MSFTNGP02.phx.gbl...
> Just curious if anyone has experience with this.
> SSRS2005
> I have a report that has a dataset and populates a table.
> I have 8 sub-reports that are placed on this report.
> Is this approach the best for performance, or should I add the other 8
> datasets to this one report,
> and then include a table for each of them.
> Just wondering what kind of overhead this is creating using the Sub
> Reports.
> Thanks in advance for your reply's
>|||Thanks Bruce. I created them as seperate reports so that I could use them
in multiple places. I was just wondering about performance hits and whether
there was a preferred method of achieving better performace.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ercR5Oy4GHA.1496@.TK2MSFTNGP05.phx.gbl...
> It sounds like this not a master-detail type of thing. I use subreports if
> I plan on using the report inside multiple reports or if I am doing
> master-detail. Otherwise I put it all in the same report.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Chris" <cexley@.enableconsulting.com> wrote in message
> news:%23Fgv55x4GHA.772@.TK2MSFTNGP02.phx.gbl...
>> Just curious if anyone has experience with this.
>> SSRS2005
>> I have a report that has a dataset and populates a table.
>> I have 8 sub-reports that are placed on this report.
>> Is this approach the best for performance, or should I add the other 8
>> datasets to this one report,
>> and then include a table for each of them.
>> Just wondering what kind of overhead this is creating using the Sub
>> Reports.
>> Thanks in advance for your reply's
>>
>