Parameters SSRS

Posted on 2012-08-14
Last Modified: 2012-08-16
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
Question by:spoye
    LVL 65

    Accepted Solution

    (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.

    Author Comment

    Thank You.
    LVL 65

    Expert Comment

    by:Jim Horn
    >typing t@ followed by the parameter name.
    Correction:  typing @ followed by the parameter name, e.g. @invoice_number, @first_name, @year, etc.
    LVL 65

    Expert Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
    A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now