Disable Auto Refresh Mode
When you disable the Auto Refresh Report feature in Analyzer you can design your report layout first, including calculations and filtering, without querying the database automatically after each change. You can enable the Auto Refresh Report option at any time. When you enable data retrieval, your report will display the requested data.
Use these steps to disable auto refresh and build a report.
Login to the User Console, then from the Home page, click Create New, then Analysis Report.
When the Select Data Source dialog box appears, clear the Auto Refresh Report check box.
Click OK. The Analyzer workspace appears.
To begin creating your report layout, select a field and drag it to the Layout panel at the left of the workspace. A message appears when you place the first field allowing you to refresh the report. Right-click menus are available for each of the fields you have dragged to the field layout area. They also indicate the position of the fields once they are placed in the report. Notice that the Analyzer workspace is disabled (greyed out) if you are not in live query mode. You can click the enable/disable Auto Refresh
button in the toolbar to toggle between the two modes.Continue to build your report and query the database when the layout is complete. You may only build your report in the field layout area when Auto Refresh is disabled.
When your report is complete, click Refresh in the pink band of the field layout area. Alternatively, use the toggle button.
The Analyzer report updates based on the report definition and display the results. You can continue to edit the report as needed and click Refresh or enable the Auto Refresh ability to run the query again.