Please consider a recommendation to Microsoft regarding SSRS

The ability to compare and contrast a main chart with another user selected chart is an important business intelligence dashboard feature facilitating business decisions by enabling the business user to identify trends in data.
In the context of SSRS the main chart is held within the parent SSRS report and the charts to be compared against are held within sub reports.
When you dynamically select a sub report at run time all the sub reports associated with the current parent report are also refreshed, even if they are currently hidden. This can potentially cause very negative performance for highly interactive dashboard charts for very large data sets.
My proposed solution is; – When the refresh of a container is triggered (e.g. view of a parent SSRS report) the underlying data sets of the hidden child containers (e.g. child / sub SSRS reports) should not be refreshed as the default behaviour.
I have spent many months documenting this recommendation including a work around. Please have a look at the following link; – http://innovativebusinessintelligence.com/HCIEpisodes/DataSetQueryingonUserSelectedReports/tabid/95/Default.aspx
If you agree with my recommendation then cast your vote on the following link; –
https://connect.microsoft.com/SQLServer/feedback/details/817551/ssrs-data-sets-of-hidden-sub-reports-should-not-be-re-requeried
Thank you for your time,
Kind Regards,
Kieran.

Advertisements