title: How to build a report with nested subreports in SSRS
body: <p>I'm looking to build an SSRS 2008 R2 report using the Report Builder, such that if a cell in a row of the report is clicked, it causes a hitherto hidden subreport to become visible, populated with data retrieved from a query which uses parameter values from the row of the cell clicked.</p>
  
  <p>To explain further, the report should look like this before clicking:</p>
  
  <pre><code>|  Column 1  |  Column 2  |  Column 3  |  Column 4  |
  |Row 1 Col 1 |Row 1 Col 2 |Row 1 Col 3 |Row 1 Col 4 |
  |Row 2 Col 1 |Row 2 Col 2 |Row 2 Col 3 |Row 2 Col 4 |
  |Row 3 Col 1 |Row 3 Col 2 |Row 3 Col 3 |Row 3 Col 4 |
  |Row 4 Col 1 |Row 4 Col 2 |Row 4 Col 3 |Row 4 Col 4 |
  </code></pre>
  
  <p>Then after clicking <code>Row 1 Col 1</code>, the subreport with data from <code>Row A Col A</code> to <code>Row D Col D</code> should appear, as below:</p>
  
  <pre><code>|  Column 1  |  Column 2  |  Column 3  |  Column 4  |
  |Row 1 Col 1 |Row 1 Col 2 |Row 1 Col 3 |Row 1 Col 4 |
      |  Column A  |  Column B  |  Column C  |  Column D  |
      |Row A Col A |Row A Col B |Row A Col C |Row A Col D |
      |Row B Col A |Row B Col B |Row B Col C |Row B Col D |
      |Row C Col A |Row C Col B |Row C Col C |Row C Col D |
      |Row D Col A |Row D Col B |Row D Col C |Row D Col D |
  |Row 2 Col 1 |Row 2 Col 2 |Row 2 Col 3 |Row 2 Col 4 |
  |Row 3 Col 1 |Row 3 Col 2 |Row 3 Col 3 |Row 3 Col 4 |
  |Row 4 Col 1 |Row 4 Col 2 |Row 4 Col 3 |Row 4 Col 4 |
  </code></pre>
  
  <p>The data in the subreport will be populated from a query based on the values in <code>Row 1</code>.</p>
  
  <p>Can anyone point me to where I can find out how to do this, or suggest how I might do it? Is it even possible in SSRS?</p>