Report Object – Offline Mode

Offline mode let you run Report Objects (Data Grids, Pivot Grids, Reports and Dashboards) without the need to constantly open your database connection. It works by caching and saving your data set to your computer and loading only the data from the cache when required.

The first time you run a offline mode Report Object it will need to execute the Query as usual and then save it tour local computer cache. From the second time on the required data will be loaded form your local cache.

Using offline mode is recommended when your DBxtra Query execution time is taking a long time to execute. A real case scenario to apply offline mode might be that your Query includes many or complex expressions (calculations) which take a considerable time to execute or /and you require to extract historical data which haven’t changed in the last time. The use of offline mode might also be a good idea when you require to work with slow or unavailable data connections.

Enabling Offline Mode

• To enable Offline mode, click the checkbox when saving your Report Object.

• You can also enable / disable Offline Mode in the Report Object’s properties window.
  Right click>Properties) under the General tab.

To run a Report Object in Offline Mode, it must be executed at least once after enabling this feature so the data is cached to your computer.

After that execution, the Report Object loads from the cached data.

Note! You can verify the last date / time update in the status bar.

Important! Clicking on the Refresh button (Data Grid, Pivot Grid, report, Dashboard) automatically retrieves the data from the database and refreshes the cached data.