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

x
 
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.


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

Kelvin
0
 
Bharat GuruAuthor Commented:
Preview of report designer
0
 
Bharat GuruAuthor Commented:
Thanks
0
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.