YF table shows the correct results, but the associated chart shows outdated data
Version 9.4.0. I have a report where the table correctly shows 1,207 results, but the chart has been stuck at 1,113 results. When you open the chart and filter the results to just this year, the count is correct. But when you remove the filter to show all the years, the results for 2021 go back to 1,113. I checked the data connection setting - it is set to 20k. But the report itself (by default) is set to 10k. Once I changed the associated report, the charts updated as they should. But I have to say, it's not really intuitive to have to change both. I would expect if the data connection is set to 20k, then the software should assume that the associated reports would also be 20k. It is a grandfather issue. If we changed the limit to 20k, only new reports would have the new 20k limit. However, all the "old" reports still have the 10k limit.
Is there a way to run an update statement against the repository to change all the "old" report to the new limit setting?