Solved

SSRS report showing old data.

Posted on 2016-07-26
5
125 Views
Last Modified: 2016-10-10
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
Comment
Question by:Bharat Guru
  • 2
  • 2
5 Comments
 
LVL 65

Expert Comment

by:Jim Horn
ID: 41730179
Is your SSRS server caching data at regular intervals, say a day?
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 41730184
Are you viewing/exporting from the Report Viewer or from the preview on the Report Designer?

Kelvin
0
 

Author Comment

by:Bharat Guru
ID: 41730244
Preview of report designer
0
 
LVL 22

Accepted Solution

by:
Kelvin Sparks earned 500 total points
ID: 41730261
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
 

Author Closing Comment

by:Bharat Guru
ID: 41836939
Thanks
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question