SSRS dataset refresh

Posted on 2009-04-16
Last Modified: 2012-05-06
Hi, I have a report parameter. I pass that value to a stored procedure that populates my table, the dataset for my table on the report. The first time it runs great. However, when I go back to the report parameter and choose a different value, and execute the report (the procedure), it seems as if it is not refreshing the report. In Access I remember there was a property to repaint the screen or requery. Is there such a property in SSRS to ensure the values are all current with each parameter choice?
I tried the refresh icon and it is hit or miss. If I do it a few times, then regardless of the choice I make for a parameter, the value defaults to null.
Question by:Laura2112
    LVL 16

    Accepted Solution


    If you change the parameter value and click the "view Report" button what happens?

    Have you tried manually executing your stored procedure in SSMS w/ two different variables to ensure the data returned the second time is correct?
    LVL 26

    Assisted Solution

    by:Chris Luttrell
    Are you having this problem in the designer or on a deployed report?  The designer tool has a tendency to cache data and not query the database again.  Right click in the Report area and say refresh.

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
    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…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    779 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

    11 Experts available now in Live!

    Get 1:1 Help Now