SSRS report showing old data.

Why is my SSRS report showing old data?  
I have a summary report with sub report.  When I export to excel from sub report I'm getting correct data but if I export from summary report I'm getting old data.
Bharat GuruAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

Kelvin SparksConnect With a Mentor Commented:
The report designer always caches your data, so once you've run it once, it doesn't refresh from the database. There's a few articles around on auto refreshing these. I believe if you look in the folder that the rdl is saved in, there's also a .data file. I've heard (but never tried to prove it) that if you delete that file, the designer will then refresh the datafile and give you the latest data.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Is your SSRS server caching data at regular intervals, say a day?
Kelvin SparksCommented:
Are you viewing/exporting from the Report Viewer or from the preview on the Report Designer?

Bharat GuruAuthor Commented:
Preview of report designer
Bharat GuruAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.