A graph or chart is a diagrammatic illustration of a set of data. Data can be easily presented in a visual and meaningful format using the Indigo DRS Chart Designer.
To Add or Edit a Report Chart click on the Report Treeview and select the Section or Group you wish to create Chart in.
Enter the Name, Rules and Size for the Chart and then open the Designer.
Report Chart Designer
The Chart designer allows the Chart Areas, Legends and Series to be defined using the Property Pages. The Chart should be bound to the report data source and the available Columns from the Data Table should be selectable.
Click Edit Chart or right click on the Chart to open the Report Chart Properties for Editing.
Click the Chart Series collection editor to define the Chart Series and styles.
Select the X and Y Axis Data Source and Chart Type. Many other settings can be defined to customise the Chart appearance and style.
Adding Legends to the Chart is easy with the Legend Collection Editor.
Data Filtering and Sorting
A Data Filter can be applied to the Report Chart for Filtering and Sorting. To Enable Data Filtering click the Data Filter button on the property page to open the Filter properties.
Data Table Row Limit
The number of Rows in the Data Table can be limited by specifying a Row Limit. Open the Property Page for the Data Filter and enter a limit for the Data Rows.
Data Filter Designer
The Data Filter Designer can be used to design Data Filters and Sorting on Data Columns.
Select the Data Columns to Filter and / or Sort from the Dropdown lists in the Column Headers.
Click Run Filter to view the Filtered Data output and then OK to apply to the Report Chart.
Inserting a Line Chart into the Report
The following report shows the share prices for IBM and took less than five minutes to create.
Chart Data and Distinct Values
The Distinct Values Function determines how Data is summarized in the Report Chart. The Functions for summarising Data include Sum, Average, Count, Max, Min, First, Last and Exists. Enable Distinct Values and choose the relevant Function for the Report Chart according to how the Data needs to be summarised or presented.
Data Table Row Limit
The number of Rows in the Data Table used to generate the Report Chart can be limited by specifying a Row Limit. Open the Property Page for the Report Chart and enter a limit for the Data Rows.
Select and Sort Filters
Select and sort filters can be applied to the Report Chart to return even more specific results. For example, if a Select Filter is applied for Name = 'Cool Doc Fee' then only the Fees with this Name will be output in the Report Chart.
Chart Data Context and XSLT
The Report Chart can use the Report Data Context or a custom Context specified by the Context Property.
In addition XSLT Reporting features Extensible Stylesheet Language Transformations which is a language for transforming XML documents into other XML documents or other formats such as HTML for web pages or plain text.
To specify an XSLT to Transform the Report Chart Data Context click the Button on the XSLT Property to Open the XSLT Editor.
The URI Query for the Context and XSLT can be a series of XQuery or Python statements to specify the location of the File URI. If the Value Type is a literal the URI location will be determined from the URI property. If the Value Type is Query then the URI location will be determined from the URI Query.
Report Conditional Rules can be applied to Report Charting to determine if the Chart is displayed within the Report. Report Rules are XQuery or Python statements that return True or False and determine if Content is Enabled. By Default if empty the Rule will always be True.
XML namespaces are used for providing uniquely named elements and attributes. If the Data Source contains Namespaces they can be applied to the XQuery Processor.