Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Report Caching

Posted on 2011-09-09
6
Medium Priority
?
280 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 2000 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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
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…

715 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