title: How to control execution of a subreport based on its visibility in SQL Server 2008 Reporting Services?
body: <p>I have sever nested subreports that by default are hidden and are only made visible when toggled via an element in the parent report. I want SSRS to not execute the query statements for these subreports untill they are toggled and made visible. The subreports recieve their parameters from their parents, and not from any user input. Is there a way to implement this?</p>
  
  <p>I am using SQL Server 2008 Business Intelligence Development Studio.</p>