I have created and tested a report in Visual Studio and it returns data from a SQL server database. Once uploaded to SSRS, the report returns old data.

What would I need to check as it appears the data source has cached?

Result in Visual Studio

Results from SSRS Report

Update: I have created a table in the SQL database, and can query it from VS and report builder, but not from a report in SSRS.

  • How is your report set up? Are you using a stored procedure or query to return data? Mar 20 '20 at 14:09
  • I am running a query, using a shared datasource. I have also tested this with an embedded data source with the same result
    – Jamesttuk
    Mar 20 '20 at 14:54

When a report is first run in Visual Studio, it creates a cache of the data that is used for all subsequent executions, as long as you don't change parameters. You can refresh the data by either changing parameters, or deleting this cache of the data.

To do so, navigate to your solution file and find the file for the report like YourReport.rdl.data and delete that. The next time you preview your report, it will query the database for the fresh data.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.