title: SSRS - Multiple stored procedure calls based on 1 parameter in 1 Report?
body: <p>In <code>SQL Server Reporting Services</code>, I was able to make a report that accessed <code>SQL Server</code> via a stored procedure.  In this stored procedure, I passed along a parameter and the stored procedure returned only data related to that parameter.  This worked correctly. </p>
  
  <p>Is it possible to, take that same parameter and pass it to another stored procedure so that 2 different reports on queried and returned at the same time, while being displayed on the same report?</p>
  
  <p>For example:</p>
  
  <pre><code>Stored Procedure 1:
  Parameter passed to Stored Procedure 1: OrderID
  Returns Data 1
  
  Stored Procedure 2:
  Parameter passed to Stored Procedure 1: OrderID
  Returns Data 2
  
  Report:
  Data1
  Data2
  </code></pre>