sql server reporting services: How do you create a report using a stored procedure passing a parameter to
the stored procedure?

Thanks,

On Jun 21, 3:03 pm, Ryan Mcbee <RyanMc...@discussions.microsoft.com>
[quoted text, click to view]


If you are using the Report Wizard, set up the report initially with a
base query that has the same structure as the stored procedure will
return. Setup the report parameter via either static values or a new
dataset. Then in the Data tab, select the dataset for the stored
procedure and select the Edit Dataset button [...], select the
Parameters tab and select the report parameter(s) that should be
passed to the stored procedure.

Regards,

Enrique Martinez
Sr. Software Consultant