Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Fear is a natural reaction to moving closer to the truth
 
Pema Chodron
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!!!!

15
October

Why is My SSRS Reports Still Showing the Old Data, even after the Stored Procedure has been Updated?

One of my clients who has a suite of SQL server reporting services 2016 reports, based on a number of stored procedures.

They had updated some of these stored procedures, but when the reports was run, they still returned the original (old) data.


Solution:


SQL server reporting services, has a slight anomaly, that Visual Studio caches the report underlying data, as a way of saving time and resources.

Part of writing and designing and testing reports, is that a report will be run over and over again, sometime with just small changes.

To avoid long execution times from re-querying the same query, Visual Studio creates a data file, with the extension .data.

Unfortunately, when the stored procedure is updated, the *.data file is not.

To get the report to look at the updated stored procedure the *.data file has to be deleted from the project file in Windows Explorer.



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 *