Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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?
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.
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.
Another solution is to just press the refresh button within the preview tab of Visual Studio and it will rerun the query.
