0

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.

2
  • How is your report set up? Are you using a stored procedure or query to return data? Mar 20, 2020 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, 2020 at 14:54

2 Answers 2

0

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.

0

enter image description hereAnother solution is to just press the refresh button within the preview tab of Visual Studio and it will rerun the query.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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