Hello,
using MSSQL connection, I added new records while looking at the dashboard.
I noticed that dashboards seem to cache data, clicking the refresh icon on the top bar on preview doesn't load new records and the only way to show the new records is to open the design view and syncronize the data source.
These are the main settings
as you can see both the cache data and totals are set to false and the report cache mode is set to off too.
Is there some other setting to change?
Unable to refresh data
Unable to refresh data
Soft System srl
-
- Posts: 6244
- Joined: Tue Mar 20, 2018 5:34 am
Re: Unable to refresh data
Hello,
Please try to add the following code:
Stimulsoft.Report.Dashboard.StiCacheCleaner.clean();
Thank you.
Please try to add the following code:
Stimulsoft.Report.Dashboard.StiCacheCleaner.clean();
Thank you.
Re: Unable to refresh data
Thank you, Lech
The command works fine, I tried it in the Page_Load, and reopening the page loads the new data.
Is it possible to bind it to the refresh button? I didn't find a suitable event for StiWebViewer
The command works fine, I tried it in the Page_Load, and reopening the page loads the new data.
Is it possible to bind it to the refresh button? I didn't find a suitable event for StiWebViewer
Soft System srl
-
- Posts: 6244
- Joined: Tue Mar 20, 2018 5:34 am
Re: Unable to refresh data
Hello,
You can add Clean() method in the StiWebViewer1_GetReport
and add the following code:
Thank you.
You can add Clean() method in the StiWebViewer1_GetReport
and add the following code:
Code: Select all
<cc1:StiWebViewer ID="StiWebViewer1" runat="server"
OnGetReport="StiWebViewer1_GetReport" />
<script>
jsStiWebViewer1.controls.buttons.RefreshDashboard.action = function () {
this.jsObject.postAction("GetReport");
};
</script>
-
- Posts: 6244
- Joined: Tue Mar 20, 2018 5:34 am
Re: Unable to refresh data
Hello
We are always glad to help you!
Please let us know if you need any additional help.
Thank you.
We are always glad to help you!
Please let us know if you need any additional help.
Thank you.