We help IT Professionals succeed at work.

Parameters SSRS

steven
steven asked
on
I am new to SSRS, i have created a stored proc that will accept 4 variables.  I am not sure how to pass them in.

Thank you
Comment
Watch Question

SQL Server Data Dude
CERTIFIED EXPERT
Most Valuable Expert 2013
Author of the Year 2015
Commented:
(1)  Create a new dataset by going to the Report Data window, datasets folder, and right-click:Add Dataset.  The Dataset Properties dialog will appear.
(2)  Give it a name, then select 'Use a dataset embedded in my report'.
(3)  In the Query Type section select Stored Procedure, then select your Stored Proc.
(4)  On the left side click on Parameters, and enter your four parameters (assuming by 'variables' you mean parameters) by hitting the Add button, and typing t@ followed by the parameter name.
(5)  Save, and there you go.
stevendeveloper

Author

Commented:
Thank You.
Jim HornSQL Server Data Dude
CERTIFIED EXPERT
Most Valuable Expert 2013
Author of the Year 2015

Commented:
>typing t@ followed by the parameter name.
Correction:  typing @ followed by the parameter name, e.g. @invoice_number, @first_name, @year, etc.
Jim HornSQL Server Data Dude
CERTIFIED EXPERT
Most Valuable Expert 2013
Author of the Year 2015

Commented:
Thanks fore the grade.  Good luck with your project.  -Jim

Explore More ContentExplore courses, solutions, and other research materials related to this topic.