Chart Preview View

The Chart view is a dynamic chart that allows execution of, and displays results for, and Chart setup in the system and its underlying results from a Pivot and SQL Wrapper. This provides a consistent and easy method for visualising and interacting with the results of the data. 

Chart Features

The chart view is capable of interacting with, and displaying results of any Chart setup in the system.

The chart dynamically loads the series and design from the Chart design and resulting data set applying any formatting and options you've specified into the resulting chart.

The chart first loads the underlying SQL Wrapper specified by the Pivot linked to in the chart. It loads the schema from the SQL Wrapper and the design from the Pivot definition which references that schema. The system then applies the chart definition to the chart display.

Next the system executes the underlying SQL Wrapper itself using any preset parameters, or prompts if required. The results are applied through any Pivot definition dynamically and loaded as part of the data for the chart itself.

Using advanced options you can provide drill down settings so when a user clicks on segment of the chart it opens up another sql wrapper/chart/pivot and passes parameters automatically into that so it can display further details of the data in that segment.

As you are editing Charts if you make changes to the definition and they aren't immediately reflected in this chart, you can just close and re-open the Chart to dynamically load those changes in, or re run the "Run" command.

Running The Results

You can easily run the results of the Chart by clicking the

Run Command.

Just like a SQL Wrapper this will first popup a parameter dialog with the parameters that are specified in the SQL Wrappers Parameters. The system will automatically apply the correct controls for the user to select values from. If you have setup default values or formulas, then they will be evaluated and entered by default for those parameter values.

The system will then execute and display the results in the chart.