SSRS Subreport architecture
-
I'm currently working with a report with several subreports embedded in it.
There is a line of thought at my workplace that says if the report isn't visible then it's not actually running. I haven't been able to find out if this is true. Does anyone have a link explaining how this architecture actually works behind the scene?
-
To the best of my knowledge, and I don't have a link to point to (maybe I should blog about it, a hidden subreport will execute whether visible or not. One way to verify this is to run a trace when the report is run and you'll see if the query for the subreport is executed when the report is first rendered.
Attached are a parent report with a child report that use AdventureWorks where I have the Hidden property of the subreport set to true and you can see in the Profiler image the number of executions for the subreport even though it is hidden.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
Another way would be to check the Report Server ExecutionLog table. This way you don't need to run a trace.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply