Is it possible to call a SP in an SSRS report without having to provide parameters outside of the query?

• christophermcne

  SSC Rookie

  Points: 31

  More actions

  September 24, 2015 at 10:38 am

  #320862

  I apologize for my ignorance; I am new to SSRS and can't seem to find the answer to this question anywhere on the internet. I'm automating an SSRS report for a client using a simple query that calls a stored procedure and feeds it parameters (there are about a dozen of them) based on data gathered in temp tables in the first part of the query. When I run the query in SSMS, obviously, it will simply produce the feedback I require in the grid. However, when I set up the report in SSRS and specify the query, SSRS is prompting me to input values for each parameter.

  I have written some additional queries for a few of the parameters, set them as 'default' values, and the subscription works fine. My question is this: is there not a way in SSRS to simply dump a query in to the report and have SSRS spit out the raw results without having to worry about specifying a default value for every parameter the report sees? I apologize if the question doesn't make sense, but I feel like the process would be easier if I could just use a pre-composed query that feeds its own parameters into a SP, and then have SSRS simply display the results. I am using SQL Server 2014.

  Thanks for any insight you can provide.

  😀