Solved

Report Caching

Posted on 2011-09-09
6
278 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 101

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

Database Solutions Engineer FAQs

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller single-server environments.

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
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 shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

623 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