[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 529
  • Last Modified:

SSRS Report data window

I have attached a screen shot of the SL REport Project created in ssrs.  I have again been tasked to create a report, being a new to ssrs i am having issues.  

I have a stored procedure that accepts 4 variables.   I would like  to have the report user pass in the variables ...ie dates.  

Is this possible?

If so how do i access?

I have acctached a screen shot of where I am.

1 Solution
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>I have attached a screen shot
I don't see an attachment.

>Is this possible?

(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 @ followed by the parameter name.
(5)  Save, and there you go.

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now