Periodic automatic server side export of chart in QV 11 AJAX environment
I am using DynamicUpdate Action on a button to update in-memory fields. It works fine. Now I need to persist the changes to disk. One way to do it is periodic and automatic export of a chart that captures the changes on the server.
To accomplish this I created a variable vTimeMinutes = Minutes(Now(1)) and created a trigger in document properties to run vbscript macro on vTimeMinutes change. The macro uses serverSideExportEx to export the chart on the server. The problem is that this only works if the variable is displayed on the dashboard and the user clicks on the dashboard. Apparently variable value change is only recognized when the change is displayed.
Any ideas on how to make this work would be greatly appreciated!