I am modifying one RDL with a dataset calling a stored procedure. I changed the stored procedure for the dataset. Refreshing fields does not take any effect.
Solution:
a.
BIDS uses a data cache when designing reports to speed up the development and improve design-preview iterations.
To turn off the feature, modify the config file that controls the Report Designer in BIDS.
Location: C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\RSReportDesigner.config
Change CacheDataForPreview to “false” , if you want to turn it on, just change CacheDataForPreview to “True”
b. Change the Query Type to Text and provide the parameter values on the EXEC call to the stored procedure.
