title: SSRS passing parameter to subreport
body: <p>I have 2 tables which both have the column "countyID"</p>
  
  <p>I have a main report that brings up reports based on a query like:</p>
  
  <pre><code>SELECT countyID, name, address, state
  FROM TableA
  </code></pre>
  
  <p>---I have a parameter set on TableA where you select the Name to view its report.</p>
  
  <p>I then have a second report based on a query like:</p>
  
  <pre><code>SELECT * 
  FROM TableB
  </code></pre>
  
  <p>I want to use the second report as a subreport, as in, when you select the Name for the top report it should then list all records from TableB with the same CountyID.</p>
  
  <p>Is there a way to set countyID as a parameter and then pass it to the subreport? This way the subreport would always only return records with matching countyID's to the currently selected record of the main report.</p>