Unusually I'm using a production procedure in our of my reports, so we return *identical* data with the logic centralised. This proceduer has a number of parameters, I wish to return the data set when all of these are as per their specified defaults. I.e. in Management Studio 'EXEC Procedure' is all I need to do.
When I do this in Visual Studio for a report I'm prompted to enter values for the parameters before the report will run.
I could find out and 'hard code' these default values, however, as I want to maintain exact synchronicity with the production procedure I'd rather pull these through than specify them.
Is there any way I can do this?
Edit: besides creating a separate procedure which simply executes the product facing one and doesn't have any parameters, which would work.