Solved

Report Caching

Posted on 2011-09-09
6
270 Views
Last Modified: 2012-08-13
I'm having issues  with reporting services caching Reports.     Is there any way to completely turn  caching off so nothing is ever cached?    It only lets me limit history to 1.  

The problem is if the back end data change in the database from some process  and the user calls the reports  they do not see  the updated information until they pass the report a different set of parameteres first then put the original parameters back in.  

0
Comment
Question by:unreal400
6 Comments
 
LVL 17

Accepted Solution

by:
dbaSQL earned 500 total points
ID: 36513461
0
 
LVL 17

Expert Comment

by:dbaSQL
ID: 36513467
double check this, but you may just need to have this in your rsreportdesigner.config:

<Add Key="CacheDataForPreview" Value="False
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 36529241
Remove caching from report.
0
 
LVL 2

Author Comment

by:unreal400
ID: 36530621
CacheData for preview only really help with design mode correct?

Is there no setting directly in the server for production usage  as I'm not totally sure  the first will work with the way we are calling our code.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 36967111
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

867 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now