MS SQL Server Reporting Services - Subreport design / performance issue

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Subreport design / performance issue

dterrie@sbcglobal.net

2006-04-06, 8:27 pm

If a subreport's hidden property is set to True, does the report still
execute the stored procedure used as it's datasource?

Say I have 10 subreports for which the visibility is determined by a
ReportID value in the dataset for the main report. If the main report's
dataset has 3 records, one for each subreport that needs to run
(containing the parameter values required by the subreports), are only
3 datasets generated or are all 10 generated even if only 3 subreports
are visible?

We have an application with 200+ reports that are now run one at a time
as a datagrid, but are building a system in which these reports are
converted to RS reports that can be run one at a time or as part of a
saved Report Group. Users want to generate a 'book' comprising a batch
run of a variety of reports the parameters for which we store in a
table.

Sponsored Links