title: SSRS Putting field from executed Dataset as Parameter to Second Dataset
body: <p>My issue is when executing a stored procedure in a DataSet (exec pStoredProcedure) and SSRS populates different Fields for me to use. I wish to make an additional query to one of these fields.
  DataSet 1 is:</p>
  
  <pre><code>exec pInfos @SessionGUID=@SessionGUID 
  </code></pre>
  
  <p>Dataset 2 is simply:</p>
  
  <pre><code>select * from myTable where infoHeader is @HeaderInfo
  </code></pre>
  
  <p>In this query, @HeaderInfo is my dataField from the first DataSet that is returned. Note that the tablix is expanding for the number of @HeaderInfo there happens to be.</p>
  
  <p>What's a simple way to put this field in as the parameter and put the result onto a tablix? (note the tablix data source is dataset1).</p>