Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Be the change that you want to see in the world
 
Gandhi
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

29
April

How Do I Ensure the Latest Data is Being Returned in BIDS SQL Reporting Services 2008?

Recently I have had a number of clients contacting me due to their reports displaying the wrong data, when the report is previewed in BIDS SQL Server Reporting Services 2008.

The issue is that in SQL Server Reporting Services 2008 when report designers previews  reports within the BIDS environment SSRS 2008 caches the data for each report.

The main reason for this is to increase performance, as every time the report is preview it no longer has to go back to the original datasource to return the report dataset.

The downside is that if the report properties, (such as fields, formulas, functions), does not change it will bring back the cached (old) dataset, and so if the underlying data has been changed it will not be displayed within the report.


Solution:

There are three solutions:

Quick and Easy:
  1. Click on the Preview Tab
  2. Press the Refresh button on the Preview toolbar

This usually does the trick, but if not, then


Permanent - Completely turn this feature off:
  1. You will need to change the file: RSReportDesigner.config
  2. This file is located:  C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\RSReportDesigner.config
  3. Change the value for the key: CacheDataForPreview from True to False
  4. Save the file

Manual solution:
  1. Within the Solution Tab
  2. Right click on the Reports folder
  3. Select Add Existing Item
  4. Select the Show All Files in the dropdown
  5. Sort by Type
  6. Delete any file with the extension *.data

If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us


MAKE A COMMENT

Name *

Email Address *

Comment *