Solved

SSRS report showing old data.

Posted on 2016-07-26
5
115 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
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…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

810 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