This application is designed for creating dynamic charts based on SQL or Procedures.
Inside Scriptcase Charts can be created also within the Grid application, however the Chart application has more settings options available to the end user within the generated application. The idea is to apply the concept of Business Intelligence to Scriptcase users to generate charts and set their own data display .
The configuration settings uses the Drag'n Drop to build dynamic Charts.
The dimensions options is used to set the fields that make up the size of the graph (axis X), used to group the data into categories.
The developer can choose more than one field as a dimension, each new field as a subcategory of the previous field.
To select one field, click its name in the available fields in the left column and drag it to the selected fields in the right column.
Figure 1: Charts Configuration Interface.
The metrics are used to display quantitatively the data grouped by dimensions, starting from version 8.1 of Scriptcase, you can choose more than one metric to create the charts and have a dynamic values display within the application generated. To select one field, click its name in the available fields from the left column and drag it to the selected fields from the right column. In addition to selecting the fields that will be used as a metric.
When records count is the metric selected, the function from "Sum" is disregarded. If you want to group all the values in one, check the "Grand Total". This option is typically used for charts of type "Gauge".
Initial Value checkbox is used to define the default field, when not using the combination or stacked chart types. If you check more then one field Scriptcase will automatically set a multiple value chart type. For single value charts display (Bar, Line, Spline, Line Step, Area, Pie, Pyramid, Funnel, Radar and Gauge) you have to check only one field to appear as initial value during the first generation.
Figure 2: Charts Configuration Interface.
In the Search tab, the developer can choose the fields that will be used as filter parameter. The filtered values for each selected field must be chosen during the development within this interface.
To create dynamic search used at runtime by the end user within the application, we recommend setting through the Search menu interface located in the menu "Search".
Figure 3: Charts Configuration Interface.
In the Chart tab the developer can set the default options for the first Chart that will be generated: chart type, color, theme, and others. Below you can find the description for each one of these options.
Figure 4: Charts Configuration Interface.