Controlling SubReport Execution
Is there a way to force SSRS to not execute the stored proc associated with a subreport on the initial
load of the main report?
In essence I want the report to skip over the stored proc execution until the user clicks the plus sign beside the textbox that controls the visibility of the subreport and expands the subreport.
I was thinking of passing a parameter to the stored proc based on the visibility property of the subreport. If that's possible I can't find the right combination of where that property would be located. Something to the effect of =IIF(ReportItems!textbox1.Visibility.Hidden
= True, False, True) where textbox1 is the textbox that has the +/- sign next to it on the line above. I also tried the subreport name which is subreport1 and no such luck there either.
Is this even possible? Is there another way to do this?
Thanks
May 30th, 2011 1:22pm
There is a discussion about this topic in the following thread
http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/76a4d3ed-53a0-4f5d-98a4-f7d5013acdd1Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
Free Windows Admin Tool Kit Click here and download it now
May 30th, 2011 10:27pm