title: SSRS 2012, produce 2 dataset from single sp with single run
body: <p>is this possible, I have report with details page and then I need total by Account by parameterized period which makes it very complicated to do in RDL ( this is 100% out of questions).
  I'm thinking to.</p>
  
  <pre><code>1. Run sp, where details part stored  in table  trade_details (and  truncated before)
  2. on  the same run  same sp produces  output for trade summary.
  3. in RDL I can use simple select with text for details 
  
  Select * from trade_details
  
  4.  for Summary I will have output from sp.
  </code></pre>
  
  <p>Problem is timing: select * from #3 need to be synced, wait till sp is done, as parameter/data is different each time, not sure if this possible to make any switch/check to see if sp run is completed let say 10 sec ago otherwise go sleep for 10 seconds.</p>
  
  <p>Tx</p>