New article
Recently updated
Creating a legacy chart BI report
Who is this article for?
Enterprise or Decani users and administrators who want to know about legacy custom charts
No special access or permissions are required. Basic JasperSoft knowledge is helpful.
Overview
Legacy BI reports are generated through a third-party tool called JasperSoft. This tool presents an opportunity to create reports that contain child-level information.
To access this JasperSoft tool, begin by searching for records and applying filters using the Ideagen BI filters on the top of each screen. Once the correct set of records has been set, select Other from the Chart display option in the upper right-hand corner.
By default, all legacy charts are in Summarized view. The level of summarization can be modified by dragging the Columns and Rows sliders that are visible in the Filters regions.
Child-level reporting availability
With release 2.64.4, child data reporting will be made available to new customers as well as existing customers who have completed the search index conversion and are utilizing the redesigned user interface.
As part of this change, child data can be added to both new and existing reports.
Please refer to Unlocking native child data reporting for additional details.
Chart Types
The legacy chart report Summarize data in a graphical presentation. Multiple chart types are available.
Hover over the gear icon in the upper left corner to change types.
Chart restrictions
Some chart types may have restrictions based on the types and number of required reporting measures.
Row return defaulted to One
Every report comes with a standard measure calledCount. It creates charts and crosstab reports based on the number of records returned. This measure is simply set to 1 for every row returned.
Chart Modifications
Example with both Columns and Rows summarized:
Example with only Columns not summarized:
Example with both Columns and Rows not summarized:
View distinct types of charts by clicking the 'Switch to groups' button.
This flips the Columns and Rows positions:
Example of a Pareto chart.
To create a Pareto chart, sort the data by the desired field in Crosstab then switch to Chart. These items may be temporarily hidden. Click the key value again to view the chart elements.
Chart Formatting
Simple chart formatting options are available by selecting Chart Format... from the gear icon.
Advanced Chart Formatting
For change a report's appearance, select Chart Format... from
the Gear Icon, then go to the Advanced tab.
From this tab colors, fonts, labels, and other chart types can be controlled.
All available advanced formatting options can be viewed by clicking the Fields or Option tab, or by going to JasperSoft.com.
Adding advanced formatting to a chart requires two elements: a Property and a Value.
JasperSoft properties
It is recommended to copy and paste the Property from the JasperSoft web page. This web page also lists the available values for each property.
| Advanced Formatting Property | Function | Value | Example |
|---|---|---|---|
| colors | Dictate colors for chart elements | ["Color1", "Color2", "ColorN"'] | ["red", "blue", "green"] |
| plotOptions.series.dataLabels.enabled | Displays data values on a chart | true or false | true |
| plotOptions.series.dataLabels.format | Applies formatting to data labels | {format string} | {point.y:.2f} |
| plotOptions.series.dataLabels.rotation | Rotates data labels from 0 to 360 degrees | Value | 45 |
| plotOptions.series.dataLabels.y | Offsets the label from the chart objects | Value | -20 |
| chart.plotBackgroundColor | Changes the chart background color | "Color" | "Pink" |
For more details, and a list of all available formatting properties, click on the "More information" link in the Advanced window, to connect to the JasperSoft online help.
All available advanced formatting options can be viewed by clicking the Fields or Option tab, or by going to JasperSoft.com.
Adding advanced formatting to a chart requires two elements: a Property and a Value.
Continuous improvement of BI search and reporting tools
The JasperSoft reporting tool represents the "Report" option in the classic user interface. This tool is being integrated into the Ideagen Platform to support child-level reporting. Ideagen has already released many of the JasperSoft features, such as charts and report grouping, into native BI search and filters.With release 2.64.4, child data reporting will be made available to new customers as well as existing customers who have completed the search index conversion and are utilizing the redesigned user interface.
As part of this change, child data can be added to both new and existing reports.
Please refer to Unlocking native child data reporting for additional details.