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.
- The version of Visual Studio is unable to open .rptproj
- Can I create a multi-grouped report in SSRS formatted with merged cells?
- Using SSRS, how to retrieve custom start and end dates based on 4-4-5 accounting calendar?
- SSRS 2019 permissions granted to user domain\user are insufficient
- Report with padded zeros cell shows as #VALUE! in Excel
- Multiple Value Parameter Returns One Value Power BI Paginated Report
- The report server can’t connect to its database
- SSRS won't expand the row height when exported to Excel
- SSRS trim trailing 0's from double
- Multiple Datasets from Stored Procedure in SSRS
- How do I format date on ssrs report?
- Data Source Not Visible in SSRS Report Manager
- Setting conditional colors per task age
- Report formula for Over90Days
- Keep report header visible while scrolling
- SSRS: Report subscription ran on off-cycle schedule
- Sum result of Sum of textboxes SSRS
- How to update SSRS textbox when database table value/string changes
- Strategies for populating a Reporting/Data Warehouse database
- SSRS Subscriptions - Windows Share Error: Failure writing file: XXX : The network name cannot be found
- Generate report from URL - SQL Server Reporting Services 2008
- How can I add the French trademark symbol (MD)?
- SSRS Custom Assembly Doesn't Recieve Full Trust
- How do I format date and time on ssrs report?
- Change Visual Studio "Current regional settings" value
- How can I get Hebrew formatting (rtl) for my .rdl report
- Is there a way in SSRS to only display specific parts of a report when rendered in MHTML, vs when it is rendered in the Report Viewer?
- SSRS Parameter for "pay period"
- Trying to add sum in one of a column in SSRS table Report
- 'Back To Parent' not showing on Reporting Server 2016 after migrating from 2008