May 12, 2015 at 1:49 pm
To all:
I have created an SSRS report, but the data does not refresh. I am using the SSRS Report Buidler to create reports and when I run the query in the dataset, the results return as expected. However, when I run the report itself, the dataset appears old.
Has anyone experiencd this and/or know how to fix?
May 12, 2015 at 2:40 pm
Yes, I believe SSRS Caches data.
Click Manage on your report then select the Processing Options tab.
Select Do not cache temporary copies of this report to always run the report with the most recent data.
This link may help as well
http://blogs.technet.com/b/rob/archive/2010/02/11/caching-ssrs-reports-for-performance.aspx
***SQL born on date Spring 2013:-)
May 13, 2015 at 12:21 am
unselect the option of which allows the report to capture the catch copy. this will cause report to run every time with actual data
WINNERS NEVER QUIT AND QUITTERS NEVER WIN
WINNERS NEVER QUIT AND QUITTERS NEVER WIN
sqlserversdba.wordpress.com
May 19, 2015 at 10:14 am
Hi, I have confirmed my settings under:
1. Processing Options
2. Always run this report with the most recent data
3. Do not cache temporary copies of this report (is selected).
However, this does not solve the issue. My report is resenting old data.
Looking at other articles, many say to delete the "rdl.data" file in BIDS. However, I created this report using SSRS Report Builder and I cannot seem to find the file to remove.
Any addtional thoughts/advice would be very much appreciated and thank you!
May 19, 2015 at 10:38 am
Is there anything Hardcoded in your query? Try changing your parameters and see if the results change.
***SQL born on date Spring 2013:-)
May 19, 2015 at 10:50 am
Hi,
Thank you for your reply.
I just double checked and no I do not have anything accidently hard coded. I use two parameters and when I run and modify them in the dataset/QUeryDesigner the data refreshes as expected. However, at the Report level the data continues to stay stale and will not refresh.
Also, if I change a header name, that refreshes and shows up on the next report run.
???
May 20, 2015 at 12:07 am
thomashohner (5/19/2015)
Is there anything Hardcoded in your query? Try changing your parameters and see if the results change.
Yes there has to be something in query which will be selecting the old data
check the query for where clause
WINNERS NEVER QUIT AND QUITTERS NEVER WIN
sqlserversdba.wordpress.com
October 27, 2016 at 3:45 am
I found this useful
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply