In my report I have a text box, which is reading data from database table using below query:
SELECT TOP 1 * FROM [dbo].[Table] ORDER BY [ID] DESC
The strange thing is, for the 1st time its reading/rendering the content from the table and displaying. However, when the database table value is updated, the updated value/string is NOT getting populated/rendered in the text box.
Note: From "data set properties" -> "query designer" , I'm getting updated string. I'm unclear, why the updated table string NOT getting updated/rendered in the text box.
Is there anything I am missing?
In below Image report1.rdl.data file, I am sure in your project workspace there is similar file. just delete this file. This file is caching data for your report when viewing.
Note:Issue is with caching.