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.
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