The Visualization Selector

The Visualization Selector lets you switch between Ad Hoc view types, allowing you to choose the best way to represent your information in the Ad Hoc view, including:

• Table, which displays values corresponding to the rows and columns in the data source.
• Crosstab, which compares one or more values across multiple sets of related fields.
• Column, which compares values displayed as columns.
• Bar, which compares values displayed as bars.
• Line, which compares values displayed as points connected by lines.
• Area, which compares values displayed as shaded areas.
• Spider, which compares three or more values on a series of spokes. Spider charts can use columns, lines, or areas to display values.
• Dual- and Multi-Axis, which display values using two or more measures.
• Time Series, which compares time intervals displayed as points connected by lines. The Time Series chart type is only available for non-OLAP charts.
• Scatter, which compares values as individual points arrayed across both axes of a chart.
• Bubble, which compares three measures displayed as circles of varying sizes arrayed across both axes of a chart.
• Pie, which compares values displayed as slices of a circular graph.
• Range, which displays values as heat and tree maps. Only the Heat Map chart is available for OLAP data sources.
• Gauges, which displays values as a radial or arc gauge, based on a defined minimum and maximum measure setting.

JasperReports Server has limited support for scatter charts created in some older versions. You can use the Ad Hoc views for those scatter charts to generate new reports, but you can't edit them.

To select a new visualization type:

1. In the Ad Hoc Editor tool bar, click the icon to display the Select Visualization Type window.

Select Visualization Type Window
2. Click the type of visualization you want to apply to your report. The selected visualization type is outlined in blue. The Visualization Selector displays a description of the selected visualization and the number of fields and measures it uses.
3. Click Apply and Close to use the visualization type.

 

The following table describes the available visualization types, and rules (if any) affecting their use:

HTML5 Visualization Types

Icon

Description

Data Grid

Data grids display values from the data source in columns and rows as either individual or aggregate values.
Crosstab. Compares one or more measures across multiple sets of related fields.

Table. Displays values corresponding to the columns and rows in the data source.

Column and Bar

Column charts compare values displayed as columns and bars.

Column. Multiple measures of a group are depicted as individual columns.

Stacked Column. Multiple measures of a group are depicted as portions of a single column whose size reflects the aggregate value of the group.

Percent Column. Multiple measures of a group are depicted as portions of a single column of fixed size.

Spider Column. Multiple measures of a group are depicted as portions of individual "columns" along a spoked chart.

Bar. Multiple measures of a group are depicted as individual bars.

Stacked Bar. Multiple measures of a group are depicted as portions of a single bar whose size reflects the aggregate value of the group.

Percent Bar. Multiple measures of a group are depicted as portions of a single bar of fixed size.

Line and Area

Line charts compare values displayed as points connected by lines.

Line. Displays data points connected with straight lines.

Spline. Displays data points connected with a fitted curve.

Spider Line. Displays data points connected with straight lines on a spoked chart.

Area. Displays data points connected with a straight line and a color below the line; groups are displayed as transparent overlays.

Stacked Area. Displays data points connected with a straight line and a solid color below the line; groups are displayed as solid areas arranged vertically, one on top of another.

Percent Area. Displays data points connected with a straight line and a solid color below the line; groups are displayed as portions of an area of fixed sized, and arranged vertically one on top of the another.

Area Spline. Displays data points connected with a fitted curve and a color below the line; groups are displayed as transparent overlays.

Spider Area. Displays data points connected with straight lines and a solid color between the line and the center of a spoked chart; groups are displayed as transparent overlays.

Dual and Multi-Axis

Dual and multi-axis charts compare two or more measures, using multiple charting types or multiple axes.

Column Line. Displays leftmost measures as columns, last measure as a line.

• Requires two or more measures.
• Measures must be placed in the Columns location.
• Fields and dimensions can be placed only in the Rows location.

Stacked Column Line. Displays leftmost measures as stacked bars, last measure as a line.

• Requires three or more measures.
• Measures must be placed in the Columns location.
• Fields and dimensions can be placed only in the Rows location.

Column Spline. Displays leftmost measures as columns, last measure as a spline.

• Requires two or more measures.
• Measures must be placed in the Columns location.
• Fields and dimensions can be placed only in the Rows location.

Stacked Column Spline. Displays leftmost measures as stacked columns, last measure as a line.

• Requires three or more measures.
• Measures must be placed in the Columns location.
• Fields and dimensions can be placed only in the Rows location.

Multi-Axis Line. Displays each measure as a separate axis line.

• Requires two or more measures.
• Measures must be placed in the Columns location.
• Fields and dimensions can be placed only in the Rows location.

Multi-Axis Spline. Displays each measure as a separate axis spline.

• Requires two or more measures.
• Measures must be placed in the Columns location.
• Fields and dimensions can be placed only in the Rows location.

Multi-Axis Column. Displays each measure as a separate axis column.

• Requires two or more measures.
• Measures must be placed in the Columns location.
• Fields and dimensions can be placed only in the Rows location.

Time Series

Time Series charts illustrate data points at successive time intervals.

Line. Displays date and time data points connected with straight lines.

• Requires a single date/time field in the Rows location.
• Field must be set to the "day" group function.

Spline. Displays date and time data points connected with a fitted curve.

• Requires a single date/time field in the Rows location.
• Field must be set to the "day" group function.

Area. Displays date and time data points connected with a straight line and a color below the line; groups are displayed as transparent overlays.

• Requires a single date/time field in the Rows location.
• Field must be set to the "day" group function.

Area Spline. Displays date and time data points connected with a fitted curve and a color below the line; groups are displayed as transparent overlays.

• Requires a single date/time field in the Rows location.
• Field must be set to the "day" group function.

Scatter

Shows the correlation between two or three measures.

Scatter. Displays first measure as the x-axis, the second measure as the y-axis. Other fields and dimensions in the column group become data points.

• Requires exactly two measures.
• Measures must be placed in the Columns location.

Bubble. Displays first measure as the x-axis, the second measure as the y-axis, and the third measure determines the size of the disk.

• Requires exactly three measures in the Columns location.
• The measures cannot be placed between other fields.

Pie

Pie charts display values as slices of a circular graph.

Pie. Multiple measures of a group are displayed as sectors of a circle.

Dual Pie. Multiple measures of a group are displayed as sectors of concentric circles.

• Requires at least one measure and one field.
• Fields must be placed in the Rows location. Only one field can be placed in the Rows location if it contains a measure.
• Two fields can be placed in the Rows location if it contains no measures.
• Multiple measures are allowed in the Rows location, but only one measure is allowed in the Columns location.
Semi-Pie. Multiple measures of a group are displayed as sectors of a half-circle.

Range

Range charts display values as heat maps.

Heat Map. Individual values represented as colors.

Non-OLAP:

• One field, followed by one Measure, required in the Columns location.
• One field required in the rows location.

OLAP:

• One Dimension level, followed by one Measure, required in the Columns location.
• One Dimension level required in the Rows location.

Time Series Heat Map. Individual values across dates/times represented as colors.

• One Measure required in the Columns location.
• One Date/Time field required in the Rows location.
• Only available for non-OLAP data sources.

Dual Measure Tree Map. Displays data as color-coded rectangles; the size of each rectangle is proportional to the first measure and the color represents the second measure.

• Two Measures required in the Columns location.
• One field required in the Rows location.
• Only available for non-OLAP data sources.

Tree Map. Displays data as rectangles; the size of each rectangle is proportional to the measure of the data it represents. The tree map displays nested rectangles when you have more than one field; the parent rectangle represents the leftmost measure while the nested rectangles represent the current level of aggregation. Click on a parent rectangle to drill down to the nest rectangles.

• One Measure required in the Columns location.
• One or more fields required in the Rows location.
• Only available for non-OLAP data sources.

Parent Tree Map. Displays data as nested rectangles; the size of each rectangle is proportional to the measure of the data it represents. The nested rectangles represent the current level of aggregation while the larger rectangle represents the parent level in the hierarchy. Click on a parent rectangle to drill down to the nest rectangles.

• One Measure required in the Columns location.
• Two or more Fields required in the Rows location.
• Only available for non-OLAP data sources.

Gauges

Gauges display values as a portion of a radial or arc gauge.

Gauge. Displays a single data value as a portion of a circle; the length of the circle is the data's numeric value proportional to the maximum size defined for the measure.

• One or more Measures required in the Columns location.
• One or more Fields required in the Columns location.
• Define the minimum and maximum sizes, color stops, and layout on the Appearance tab.

Multi-level Gauge. Displays one or more data values as concentric circles; each circle represents a measure and the length of the circle is the data's numeric value proportional to the maximum size defined for the measures.

• Two or more Measures required in the Columns location.
• One or more Fields required in the Columns location.
• Define the minimum and maximum sizes, color stops, and layout on the Appearance tab.

Arc Gauge. Displays a single data value as a portion of a semi-circular arc; the length of the arc is the data's value proportional to the maximum size defined for the measure.

• One or more Measures required in the Columns location.
• One or more Fields required in the Rows location.
• Define the minimum and maximum sizes, color stops, and layout on the Appearance tab.