Pulling From and To Parameters from Stored Procedure
Posted on 2011-05-11
I have a SQL Reporting Services 2008 report that pulls data from a stored procedure.
I want to add a simple set of "From" and "To" parameters in the report itself, based on one of the fields from the stored procedure. (It's the Customer ID field.)
This is pretty simple to do, when your report is based on a table or a view. But, I'm finding this difficult for a report that is based solely on a stored procedure.
For one thing, when I try to create a new dataset for the parameters based on customer ID, I can't say "select distinct customerid from 'the name of the stored procedure'" order by customerid. When I try this, the app barks at me claiming "invalid object name".
I don't want to put the parameter in the stored procedure. I just want to put a simple from and to parameter, in the report. I just don't know how to do it, since I cannot say "select customerid from 'the name of the stored procedure'".
How do I get this very simple task accomplished?