reporting-servicesssrs-2017

How to update SSRS textbox when database table value/string changes


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?


Solution

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

    enter image description here