[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 271
  • Last Modified:

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.
0
Bharat Guru
Asked:
Bharat Guru
  • 2
  • 2
1 Solution
 
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
 
Kelvin SparksCommented:
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
 
Bharat GuruAuthor Commented:
Thanks
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now