When creating the report with the wizard, if this parameter has no default value, you’ll have to do something like this: EXEC usp_MyStoredProcedure ‘Value Name’ in order to get through the wizard.
It will pre-populate the Data Values for you.
HowTo: Create a SQL Server Reporting Services Report from a Stored Procedure
– November 9, 2007Posted in: Dot Net
