Main Report Page with multiple visible/nonvisible sub reports

Hi,
I have mainly the problem, that when I use a lot of subreports and
I get error messages by the report server.
Even I think it will not a got solution in matter of performance.
But how can I create a report, which will be configured by a
a field record ?
Up to now, I only use the sub reports with the function "hide " sub report.
The main page of the report will have the parameter selection box, to select
the datasets.
Depending on a record field information, I show only the depending reports,
which are shown different datas from different tables. Even different chart
data.
But I get the impression, that internally all query will be execute, even,
when the
visible flag is set to "hidden".
Need help for a better solution.
Best regards
RichardOn Nov 26, 8:59 am, Ritchie <Ritc...@.discussions.microsoft.com> wrote:
> Hi,
> I have mainly the problem, that when I use a lot of subreports and
> I get error messages by the report server.
> Even I think it will not a got solution in matter of performance.
> But how can I create a report, which will be configured by a
> a field record ?
> Up to now, I only use the sub reports with the function "hide " sub report.
> The main page of the report will have the parameter selection box, to select
> the datasets.
> Depending on a record field information, I show only the depending reports,
> which are shown different datas from different tables. Even different chart
> data.
> But I get the impression, that internally all query will be execute, even,
> when the
> visible flag is set to "hidden".
> Need help for a better solution.
> Best regards
> Richard
In terms of the auto-execution of datasets, I'm not sure; however, you
might want to include all the subreports in the main report as table
controls (where applicable). Then toggle the visibility of the
individual table controls (via: right-clicking the top-left corner of
the table control >> select Properties >> select Visibility >> select
'Visibility can be toggled by another report item' >> then select a
control from the list below 'Report item:'). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Main report Calls subreport Sps when subreport is set to invisible.

Hello,
I have about 15 subreports in main report, and i am making then visible/invisible based on the selection criteria. Currently even i make a subreport invisible, then also i found using profiler that it is calling SP. so the performance doesnot gets improved !

I want to stop these calls when the subreport is invisible! that helps me a gr8!
OR -
Is there any setting in the config file to avoid this ?

please reply ASAP.

Thanks in advance,
Abhay Lakkad

Currently, subreports will still get executed if the end up being invisible in the main report. We will improve this in future releases.

-- Robert

|||

Just wondered if there is any kind of work-around for this, or if it will be addressed in an upcoming RS 2005 service pack.

Thanks
Marie

Main report Calls subreport Sps when subreport is set to invisible.

Hello,
I have about 15 subreports in main report, and i am making then visible/invisible based on the selection criteria. Currently even i make a subreport invisible, then also i found using profiler that it is calling SP. so the performance doesnot gets improved !

I want to stop these calls when the subreport is invisible! that helps me a gr8!
OR -
Is there any setting in the config file to avoid this ?

please reply ASAP.

Thanks in advance,
Abhay Lakkad

Currently, subreports will still get executed if the end up being invisible in the main report. We will improve this in future releases.

-- Robert

|||

Just wondered if there is any kind of work-around for this, or if it will be addressed in an upcoming RS 2005 service pack.

Thanks
Marie