SSRS Report data window

Posted on 2012-08-17
Last Modified: 2012-09-06
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 dates.  

Is this possible?

If so how do i access?

I have acctached a screen shot of where I am.

Question by:spoye
    1 Comment
    LVL 65

    Accepted Solution

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
    Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    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