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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics