title: SSRS Report Using Stored Procedure
body: <p>I am working with an SSRS Report that uses a stored procedure.</p>
  
  <p>The stored procedure [after the <code>Use ... Set ANSI NULLS On</code>] starts with <code>ALTER PROCEDURE ...</code></p>
  
  <p>While I can understand the SQL in a stored procedure, I have never used one in an SSRS Report [I only use 'straight' SQL statements].</p>
  
  <p>When I use SQL as my Dataset, I can copy that SQL into SSMS and run it and see the data it returns.</p>
  
  <p>With this stored procedure, how do I execute it in SSMS to see the data it returns? The stored procedure has a sample 'EXEC ...' statement with all the parameters populated ... but when I run that - no data is returned.</p>
  
  <p>The SSRS report runs fine, but I want to be able to work with the stored procedure in SSMS and see the data it is returning. My goal is to be able to run the stored procedure in SSMS and then tweak it.</p>
  
  <p>How do I work with this stored procedure in SSMS so I can look at the output?</p>