A Detailed Reference of JReport Charts

About Charts

Charts organize and visualize data and make it easy for users to see comparisons, trends, and patterns in data. A chart in JReport is based on the data retrieved from database and represented by a report. It represents the report data in a visually straightforward form.

JReport Chart Elements

JReport chart consists of three major parts: chart platform, chart coordinate paper, and chart legend, where chart platform is the container of other chart components and chart coordinate paper furthermore holds walls, axes, data markers, axis values, and category names.

Option Description

Chart platform The container of the other chart elements, such as chart coordinate paper, chart legend, and so on.

Chart coordinate paper The canvas on which the main chart is drawn. The chart coordinate paper contains walls, axes, data markers, axis values, category names, and so on.

Chart legend Chart legend is a box to identify the patterns or colors assigned to the data series or categories in a chart. Each chart can have at most two legends, category legend and series legend. A chart legend may contain one or more legend entries; each entry contains an icon and a label object.

Chart label A chart label can be used as chart title, part of a chart legend entry, value axis title, category axis title, or more; you can insert a label anywhere inside a chart.

Axis values JReport Designer creates the axis values from the report data. You can change the default value range, the interval of the tick marks, the number of tick marks, and so on.

Category names DBFields and formulae in the report can be used for category axis names. You can choose (not) to show category axis names in the chart legend.

Data series names DBFields and formulae in the report can be used for series names. You can choose (not) to show data series names in the chart legend.

Data markers Data markers with the same pattern represent one data series. Each data marker represents one number from the report data.

Hint A hint message that displays the value of a data marker when you move your mouse pointer over the data marker.

Option	Description
Chart platform	The container of the other chart elements, such as chart coordinate paper, chart legend, and so on.
Chart coordinate paper	The canvas on which the main chart is drawn. The chart coordinate paper contains walls, axes, data markers, axis values, category names, and so on.
Chart legend	Chart legend is a box to identify the patterns or colors assigned to the data series or categories in a chart. Each chart can have at most two legends, category legend and series legend. A chart legend may contain one or more legend entries; each entry contains an icon and a label object.
Chart label	A chart label can be used as chart title, part of a chart legend entry, value axis title, category axis title, or more; you can insert a label anywhere inside a chart.
Axis values	JReport Designer creates the axis values from the report data. You can change the default value range, the interval of the tick marks, the number of tick marks, and so on.
Category names	DBFields and formulae in the report can be used for category axis names. You can choose (not) to show category axis names in the chart legend.
Data series names	DBFields and formulae in the report can be used for series names. You can choose (not) to show data series names in the chart legend.
Data markers	Data markers with the same pattern represent one data series. Each data marker represents one number from the report data.
Hint	A hint message that displays the value of a data marker when you move your mouse pointer over the data marker.

A Detailed Property Reference

BorderStyle Property

Specifies the border style for an object.

The settings for BorderStyle are:

Option Description

Empty The object has no visible border line (default).

Lined The object has a single-line border.

Raised The object has a 3D border that appears as if it is raised off the page.

Recess The object has a 3D border that appear as if it is pressed into the page.

Shadow The object has a shadowed border, beneath and to the right of the object.

Option	Description
Empty	The object has no visible border line (default).
Lined	The object has a single-line border.
Raised	The object has a 3D border that appears as if it is raised off the page.
Recess	The object has a 3D border that appear as if it is pressed into the page.
Shadow	The object has a shadowed border, beneath and to the right of the object.

ChartType Property

Specifies a type for a chart object. Applies to Chart Platforms.

Can be one of the following:

Chart type Option Description

Bar Clustered Bar 2-D Clustered Bar. Displays and compares data values across categories.

Stacked Bar 2-D Stacked Bar. Displays and compares the contribution of each data value to a total across categories.

100% Stacked Bar 2-D 100% Stacked Bar. Displays and compares the percentage that each data value contributes to a total across categories.

Clustered Bar 3-D Clustered bar with a 3-D visual effect.

Stacked Bar 3-D Stacked bar with a 3-D visual effect.

100% Stacked Bar 3-D 100% stacked bar with a 3-D visual effect.

Bar 3-D 3-D Bar. Displays and compares data values across categories and series.

Bench Clustered Bench 2-D Clustered Bench. Displays and compares data values across categories.

Stacked Bench 2-D Stacked Bench. Displays and compares the contribution of each data value to a total across categories.

100% Stacked Bench 2-D 100% Stacked Bench. Displays and compares the percentage that each data value contributes to a total across categories.

Clustered Bench 3-D Clustered bench with a 3-D visual effect.

Stacked Bench 3-D Stacked bench with a 3-D visual effect.

100% Stacked Bench 3-D 100% stack bench with a 3-D visual effect.

Bench 3-D 3-D Bench. Displays and compares data values across categories and series.

Line Line 2-D Line. Displays trend over categories.

Stacked Line 2-D Stacked Line. Displays the trend of the contribution of each data value over categories.

100% Stacked Line 2-D 100% Stacked Line. Displays the trend of the percentage each data value contributes over categories.

Line 3-D Line with a 3-D visual effect.

Area Area 2-D Area. Displays the trend of values over time or categories.

Stacked Area 2-D Stacked Area. Displays the trend of the contribution of each data value over categories.

100% Stacked Area 2-D 100% Stacked Area. Displays the trend of the percentage each data value contributes over categories.

Area 3-D Area with a 3-D visual effect.

Stacked Area 3-D Stacked area with a 3-D visual effect.

100% Stacked Area 3-D 100% stacked area with a 3-D visual effect.

Pie Clustered Pie 2-D Pie. Displays the contribution of each data value to a total over time or categories.

Clustered Pie 3-D Pie with a 3-D visual effect.

Radar Radar 2-D Radar. Displays and compares the data values relative to a center point.

Gauge Gauge Dial 2-D Gauge. Usually displays the performance of each member in a group, using three colors, green, yellow, and red (by default) to represent three levels: normal, alert, and error. This type, displays each data value by a dial.

Gauge Bar 2-D Gauge. Displays each data value by a bar.

Gauge Bubble 2-D Gauge. Displays each data value by a colored bubble.

Surface Surface 3-D Surface. Indicates what level of different values reside in, and shows the cross-relationships between category and series.

Scatter Scatter 2-D Scatter. Compares pairs of values.

Scatter Straight Line 2-D Scatter with data points connected by lines.

Scatter Curved Line 2-D Scatter with data points connected by smoothed lines.

Bubble Bubble 2-D Bubble. Compares sets of 3 values. Like a scatter chart with the third value displayed as the size of the bubble marker.

Stock High-Low 2-D High-Low. Requires two series of values in this order.

High-Low-Close 2-D High-Low-Close. Requires three series of values in this order.

Open-High-Low-Close 2-D Open-High-Low-Close. Requires four series of values in this order.

Combo Combo Combination charts. Two types of data markers are used to represent different data values.

Chart type	Option	Description
Bar	Clustered Bar 2-D	Clustered Bar. Displays and compares data values across categories.
	Stacked Bar 2-D	Stacked Bar. Displays and compares the contribution of each data value to a total across categories.
	100% Stacked Bar 2-D	100% Stacked Bar. Displays and compares the percentage that each data value contributes to a total across categories.
	Clustered Bar 3-D	Clustered bar with a 3-D visual effect.
	Stacked Bar 3-D	Stacked bar with a 3-D visual effect.
	100% Stacked Bar 3-D	100% stacked bar with a 3-D visual effect.
	Bar 3-D	3-D Bar. Displays and compares data values across categories and series.
Bench	Clustered Bench 2-D	Clustered Bench. Displays and compares data values across categories.
	Stacked Bench 2-D	Stacked Bench. Displays and compares the contribution of each data value to a total across categories.
	100% Stacked Bench 2-D	100% Stacked Bench. Displays and compares the percentage that each data value contributes to a total across categories.
	Clustered Bench 3-D	Clustered bench with a 3-D visual effect.
	Stacked Bench 3-D	Stacked bench with a 3-D visual effect.
	100% Stacked Bench 3-D	100% stack bench with a 3-D visual effect.
	Bench 3-D	3-D Bench. Displays and compares data values across categories and series.
Line	Line 2-D	Line. Displays trend over categories.
	Stacked Line 2-D	Stacked Line. Displays the trend of the contribution of each data value over categories.
	100% Stacked Line 2-D	100% Stacked Line. Displays the trend of the percentage each data value contributes over categories.
	Line 3-D	Line with a 3-D visual effect.
Area	Area 2-D	Area. Displays the trend of values over time or categories.
	Stacked Area 2-D	Stacked Area. Displays the trend of the contribution of each data value over categories.
	100% Stacked Area 2-D	100% Stacked Area. Displays the trend of the percentage each data value contributes over categories.
	Area 3-D	Area with a 3-D visual effect.
	Stacked Area 3-D	Stacked area with a 3-D visual effect.
	100% Stacked Area 3-D	100% stacked area with a 3-D visual effect.
Pie	Clustered Pie 2-D	Pie. Displays the contribution of each data value to a total over time or categories.
	Clustered Pie 3-D	Pie with a 3-D visual effect.
Radar	Radar 2-D	Radar. Displays and compares the data values relative to a center point.
Gauge	Gauge Dial 2-D	Gauge. Usually displays the performance of each member in a group, using three colors, green, yellow, and red (by default) to represent three levels: normal, alert, and error. This type, displays each data value by a dial.
	Gauge Bar 2-D	Gauge. Displays each data value by a bar.
	Gauge Bubble 2-D	Gauge. Displays each data value by a colored bubble.
Surface	Surface 3-D	Surface. Indicates what level of different values reside in, and shows the cross-relationships between category and series.
Scatter	Scatter 2-D	Scatter. Compares pairs of values.
	Scatter Straight Line 2-D	Scatter with data points connected by lines.
	Scatter Curved Line 2-D	Scatter with data points connected by smoothed lines.
Bubble	Bubble 2-D	Bubble. Compares sets of 3 values. Like a scatter chart with the third value displayed as the size of the bubble marker.
Stock	High-Low 2-D	High-Low. Requires two series of values in this order.
	High-Low-Close 2-D	High-Low-Close. Requires three series of values in this order.
	Open-High-Low-Close 2-D	Open-High-Low-Close. Requires four series of values in this order.
Combo	Combo	Combination charts. Two types of data markers are used to represent different data values.

DataFilter Property

Specifies the data filter for the specified axis (the X, Y1, Y2, or Z axis) to display the tick mark labels the way you want. Applies to Chart Platform.

Click the downward arrow to the right and select the filtering options you want.

The filter types can be one or more of the following:

Filter Type Option Description (Sample)

Scale Divides the value by hundreds, thousands, and so on.

Logarithm Calculates the value to logarithm to base 10.

Hundreds Divides the value by one hundred.

Thousands Divides the value by one thousand.

Millions Divides the value by one million.

Billions Divides the value by one billion.

Trillions Divides the value by one trillion.

Number Re-formats the number value (Original example: 123456)

0 Formats a decimal number to an integer (123456).

#,##0 Formats a decimal number to a digit grouped integer (123,456).

#,##0;-#,##0 Formats a decimal number to a digit grouped integer; minus sign is used as the negative prefix (123,456/-123,456).

0.00 Formats a decimal number to a fix-point number retaining 2 digits after decimal separator (123456.00).

#,##0.00 Formats a decimal number to a digit grouped number retaining 2 digits after decimal separator (123,456.00).

#,##0.00;-#,##0.00 Formats a decimal number to a digit grouped number retaining 2 digits after decimal separator; minus sign is used as the negative prefix (123,456.00/-123,456.00).

0.00E00 Formats a decimal number to a number in scientific notation; the mantissa is often in the range 1.0 <= x < 10.0, and the number of digit characters after the exponent character (E) gives the minimum exponent digit count (1.23E04).

##0.0E0 Formats a decimal number to a number in scientific notation; the minimum number of integer in the mantissa is 1, and the number of digit characters after the exponent character (E) gives the minimum exponent digit count (12.34E3).

$0 Format a decimal number to an integer, prefixed with a currency symbol $ ($123456).

$#,##0 Formats a decimal number to a digit grouped integer, prefixed with a currency symbol $ ($123,456).

$#,##0;-$#,##0 Formats a decimal number to a digit grouped integer, prefixed with a currency symbol $; minus sign is used as the negative prefix ($123,456/-$123,456).

$0.00 Formats a decimal number to a fix-point number retaining 2 digits after decimal separator, prefixed with a currency symbol $ ($123456.00).

$#,##0.00 Formats a decimal number to a digit grouped number retaining 2 digits after decimal separator, prefixed with a currency symbol $ ($123,456.00).

$#,##0.00;-$#,##0.00 Formats a decimal number to a digit grouped number retaining 2 digits after decimal separator, prefixed with a currency symbol $; minus sign is used as the negative prefix ($123,456.00/-$123,456.00).

$0.00E00 Formats a decimal number to a number in scientific notation, prefixed with a currency symbol $; the mantissa is often in the range 1.0 <= x < 10.0, and the number of digit characters after the exponent character (E) gives the minimum exponent digit count ($1.23E$04).

$##0.0E0 Formats a decimal number to a number in scientific notation, prefixed with a currency symbol $; the minimum number of integer in the mantissa is 1, and the number of digit characters after the exponent character (E) gives the minimum exponent digit count ($12.34E$3).

0% Formats a decimal number to percentage: multiplies by 100 and shows as an integer percentage (12%).

0.00% Formats a decimal number to percentage: multiplies by 100 and shows a fix-point number percentage retaining 2 digits after decimal separator (12.34%).

Notes:

The number of "0" that appears in a pattern indicates the minimum digits, show 0 if that digit is zero. The number of "#" that appears after the decimal point in a pattern indicates the maximum digits of decimal, zero shows as absent.

Use "'" (single quotation mark) to quote special characters in a prefix or suffix, for example, "'#'#" formats 123 to "#123". To create a single quote itself, use two in a row: "# o''clock".

Date/Time Re-formats the date/time value (Example, Wednesday, December 25, 00:00:00 GMT-08:00 2002)

G Formats a date to era designator (AD).

yyyy Formats a date to year (2002).

yy Formats a date to year in short form (02).

yyyy G Formats a date to year, tagged with era designator (2002 AD)

MM Formats a date to month in year, shows in number format (12).

MMM Formats a date to month in year, shows in the abbreviated form (Dec).

MMMMMMMM Formats a date to month in year, shows in the full form (December).

dd/MM/yy Formats a date to a simple date form (25/12/02).

dd-MMM-yy Formats a date to a simple date form (25-Dec-02).

dd-MMM Formats a date to a simple date form (25-Dec).

MMM-yy Formats a date to a simple date form (Dec-02).

MMM yyyy Formats a date to a simple date form (Dec 2002).

dd Formats a date to day in month (25).

DDD Formats a date to day in year (359).

ww Formats a date to week in year (52).

W Formats a date to week in month (4).

EEE Formats a date to day in week, in short form (Wed).

EEEEEE Formats a date to day in week (Wednesday).

HH Formats a date to hour in day, 0~23 (00).

kk Formats a date to hour in day, 1~24 (24).

KK a Formats a date to hour in am/pm, 0~11, with am/pm marker (00 AM)

hh a Formats a date to hour in am/pm, 1~12, with am/pm marker (12 AM)

mm Formats a date to minute in hour (00).

hh:mm a Formats a date to hour in am/pm, 1~12, and minute in hour, with am/pm marker (12:00 AM).

ss Formats a date to second in minute (00).

hh:mm:ss Formats a date to hour in am/pm 1~12, minute in hour, and second in minute (12:00:00).

hh:mm:ss a Formats a date to hour in am/pm 1~12, minute in hour, and second in minute, with am/pm marker (12:00:00 AM).

mm:ss Formats a date to minute in hour and second in minute (00:00).

MMMMM dd yyyy G (EEEEEE) hh:mm:ss aa z Formats a date to a full form date, which contains month in year, shows in the full form, day in month, year in full form, era designator, day in week, shows in the full form, hour in a day, 1~12, minute in hour, second in minute, am/pm marker, and time zone (December 25 2002 AD (Wednesday) 12:00:00 AM GMT-08:00).

Notes:

Any characters in the pattern that are not in the ranges of ['a'..'z'] and ['A'..'Z'] will be treated as quoted text. For instance, characters like ':', '.', ' ', '#' and '@' will appear in the resulting time text even they are not embraced within single quotes.

A pattern containing any invalid pattern letter will not be able to add to the filter stack.

Text Specifies the length for the value.

Default Length Uses the length of the string "Default Length", which is 14, as the length of the string. Letters exceed the length will be cut. You can modify this string, add or delete letters to increase or decrease the length limit. For example, type "Teddy", the label displayed may probably be "Wed D", which originally could be "Wed December 25 2002". If you want to show all, you can type "Teddy is a lovely bear!", where the length of it is larger than the length of string "Wed December 25 2002".

Mapping Maps new value to one or more values.

One-to-one Mapping Maps a new value to one value. Type the argument number that you want to replace, and then specify the new value in the Map to box. For example, if you want to replace the second data label on the X axis, which is originally "Thu Jul 04 2002", with a new string "US National Day", just type 2 in the Argument# box, and then type "US National Day" in the Map to box. Click Add to add it to the Filter Stack. If you want to map more values, repeat this procedure.

Range Mapping Maps a new value to a range of values. Type the argument numbers to define the range you want to map together, and then specify the new value in the Map to box. For example, if you want to replace from the second data label to the fifth data label with a new name "My Holiday", just type 2 in the first Argument# box and 5 in the second Argument# box, and then type "My Holiday" in the Map to box. Click Add to add it to the Filter Stack. If you want to map ranges that are not consecutive, repeat this procedure.

Text Mapping Change the data in the axis data label to a customized string. For example, if you want to change "Chen" in the first data label of the X axis to "Jinfonet", please type "Chen" in the Original Text box and type "Jinfonet" in the Map to box. Click Add to add it to the Filter Stack. You can only change the data one by one. Make sure that your spelling in the Original Text box is exactly the same as the data shown on the axis label.

Prefix Add a string before the data in the data label of the axis. For example, if you want to add "NA" before the data in the data label of the X axis, please type "NA" in the Map to box, and click Add to add it to the Filter Stack.

Suffix Add a string behind the data in the data label of the axis. For example, if you want to add "NA" behind the data in the data label of the X axis, please type "NA" in the Map to box, and click Add to add it to the Filter Stack.

Note:

The data labels along each axis counts from 0, which means the number of the first data label you see on the axis is 0, the second is 1, the third is 2, and so on.

Filter Type	Option	Description (Sample)
Scale		Divides the value by hundreds, thousands, and so on.
	Logarithm	Calculates the value to logarithm to base 10.
	Hundreds	Divides the value by one hundred.
	Thousands	Divides the value by one thousand.
	Millions	Divides the value by one million.
	Billions	Divides the value by one billion.
	Trillions	Divides the value by one trillion.
Number		Re-formats the number value (Original example: 123456)
	0	Formats a decimal number to an integer (123456).
	#,##0	Formats a decimal number to a digit grouped integer (123,456).
	#,##0;-#,##0	Formats a decimal number to a digit grouped integer; minus sign is used as the negative prefix (123,456/-123,456).
	0.00	Formats a decimal number to a fix-point number retaining 2 digits after decimal separator (123456.00).
	#,##0.00	Formats a decimal number to a digit grouped number retaining 2 digits after decimal separator (123,456.00).
	#,##0.00;-#,##0.00	Formats a decimal number to a digit grouped number retaining 2 digits after decimal separator; minus sign is used as the negative prefix (123,456.00/-123,456.00).
	0.00E00	Formats a decimal number to a number in scientific notation; the mantissa is often in the range 1.0 <= x < 10.0, and the number of digit characters after the exponent character (E) gives the minimum exponent digit count (1.23E04).
	##0.0E0	Formats a decimal number to a number in scientific notation; the minimum number of integer in the mantissa is 1, and the number of digit characters after the exponent character (E) gives the minimum exponent digit count (12.34E3).
	$0	Format a decimal number to an integer, prefixed with a currency symbol $ ($123456).
	$#,##0	Formats a decimal number to a digit grouped integer, prefixed with a currency symbol $ ($123,456).
	$#,##0;-$#,##0	Formats a decimal number to a digit grouped integer, prefixed with a currency symbol $; minus sign is used as the negative prefix ($123,456/-$123,456).
	$0.00	Formats a decimal number to a fix-point number retaining 2 digits after decimal separator, prefixed with a currency symbol $ ($123456.00).
	$#,##0.00	Formats a decimal number to a digit grouped number retaining 2 digits after decimal separator, prefixed with a currency symbol $ ($123,456.00).
	$#,##0.00;-$#,##0.00	Formats a decimal number to a digit grouped number retaining 2 digits after decimal separator, prefixed with a currency symbol $; minus sign is used as the negative prefix ($123,456.00/-$123,456.00).
	$0.00E00	Formats a decimal number to a number in scientific notation, prefixed with a currency symbol $; the mantissa is often in the range 1.0 <= x < 10.0, and the number of digit characters after the exponent character (E) gives the minimum exponent digit count ($1.23E$04).
	$##0.0E0	Formats a decimal number to a number in scientific notation, prefixed with a currency symbol $; the minimum number of integer in the mantissa is 1, and the number of digit characters after the exponent character (E) gives the minimum exponent digit count ($12.34E$3).
	0%	Formats a decimal number to percentage: multiplies by 100 and shows as an integer percentage (12%).
	0.00%	Formats a decimal number to percentage: multiplies by 100 and shows a fix-point number percentage retaining 2 digits after decimal separator (12.34%).
	Notes: The number of "0" that appears in a pattern indicates the minimum digits, show 0 if that digit is zero. The number of "#" that appears after the decimal point in a pattern indicates the maximum digits of decimal, zero shows as absent. Use "'" (single quotation mark) to quote special characters in a prefix or suffix, for example, "'#'#" formats 123 to "#123". To create a single quote itself, use two in a row: "# o''clock".
Date/Time		Re-formats the date/time value (Example, Wednesday, December 25, 00:00:00 GMT-08:00 2002)
	G	Formats a date to era designator (AD).
	yyyy	Formats a date to year (2002).
	yy	Formats a date to year in short form (02).
	yyyy G	Formats a date to year, tagged with era designator (2002 AD)
	MM	Formats a date to month in year, shows in number format (12).
	MMM	Formats a date to month in year, shows in the abbreviated form (Dec).
	MMMMMMMM	Formats a date to month in year, shows in the full form (December).
	dd/MM/yy	Formats a date to a simple date form (25/12/02).
	dd-MMM-yy	Formats a date to a simple date form (25-Dec-02).
	dd-MMM	Formats a date to a simple date form (25-Dec).
	MMM-yy	Formats a date to a simple date form (Dec-02).
	MMM yyyy	Formats a date to a simple date form (Dec 2002).
	dd	Formats a date to day in month (25).
	DDD	Formats a date to day in year (359).
	ww	Formats a date to week in year (52).
	W	Formats a date to week in month (4).
	EEE	Formats a date to day in week, in short form (Wed).
	EEEEEE	Formats a date to day in week (Wednesday).
	HH	Formats a date to hour in day, 0~23 (00).
	kk	Formats a date to hour in day, 1~24 (24).
	KK a	Formats a date to hour in am/pm, 0~11, with am/pm marker (00 AM)
	hh a	Formats a date to hour in am/pm, 1~12, with am/pm marker (12 AM)
	mm	Formats a date to minute in hour (00).
	hh:mm a	Formats a date to hour in am/pm, 1~12, and minute in hour, with am/pm marker (12:00 AM).
	ss	Formats a date to second in minute (00).
	hh:mm:ss	Formats a date to hour in am/pm 1~12, minute in hour, and second in minute (12:00:00).
	hh:mm:ss a	Formats a date to hour in am/pm 1~12, minute in hour, and second in minute, with am/pm marker (12:00:00 AM).
	mm:ss	Formats a date to minute in hour and second in minute (00:00).
	MMMMM dd yyyy G (EEEEEE) hh:mm:ss aa z	Formats a date to a full form date, which contains month in year, shows in the full form, day in month, year in full form, era designator, day in week, shows in the full form, hour in a day, 1~12, minute in hour, second in minute, am/pm marker, and time zone (December 25 2002 AD (Wednesday) 12:00:00 AM GMT-08:00).
	Notes: Any characters in the pattern that are not in the ranges of ['a'..'z'] and ['A'..'Z'] will be treated as quoted text. For instance, characters like ':', '.', ' ', '#' and '@' will appear in the resulting time text even they are not embraced within single quotes. A pattern containing any invalid pattern letter will not be able to add to the filter stack.
Text		Specifies the length for the value.
	Default Length	Uses the length of the string "Default Length", which is 14, as the length of the string. Letters exceed the length will be cut. You can modify this string, add or delete letters to increase or decrease the length limit. For example, type "Teddy", the label displayed may probably be "Wed D", which originally could be "Wed December 25 2002". If you want to show all, you can type "Teddy is a lovely bear!", where the length of it is larger than the length of string "Wed December 25 2002".
Mapping		Maps new value to one or more values.
	One-to-one Mapping	Maps a new value to one value. Type the argument number that you want to replace, and then specify the new value in the Map to box. For example, if you want to replace the second data label on the X axis, which is originally "Thu Jul 04 2002", with a new string "US National Day", just type 2 in the Argument# box, and then type "US National Day" in the Map to box. Click Add to add it to the Filter Stack. If you want to map more values, repeat this procedure.
	Range Mapping	Maps a new value to a range of values. Type the argument numbers to define the range you want to map together, and then specify the new value in the Map to box. For example, if you want to replace from the second data label to the fifth data label with a new name "My Holiday", just type 2 in the first Argument# box and 5 in the second Argument# box, and then type "My Holiday" in the Map to box. Click Add to add it to the Filter Stack. If you want to map ranges that are not consecutive, repeat this procedure.
	Text Mapping	Change the data in the axis data label to a customized string. For example, if you want to change "Chen" in the first data label of the X axis to "Jinfonet", please type "Chen" in the Original Text box and type "Jinfonet" in the Map to box. Click Add to add it to the Filter Stack. You can only change the data one by one. Make sure that your spelling in the Original Text box is exactly the same as the data shown on the axis label.
	Prefix	Add a string before the data in the data label of the axis. For example, if you want to add "NA" before the data in the data label of the X axis, please type "NA" in the Map to box, and click Add to add it to the Filter Stack.
	Suffix	Add a string behind the data in the data label of the axis. For example, if you want to add "NA" behind the data in the data label of the X axis, please type "NA" in the Map to box, and click Add to add it to the Filter Stack.
	Note: The data labels along each axis counts from 0, which means the number of the first data label you see on the axis is 0, the second is 1, the third is 2, and so on.

EndCaps Property

Specifies the ending style for the pen object. Applies to Chart Platforms, Chart Coordinate Paper, Chart Legends, Gridlines, Axes, Tick Marks, Labels, Fonts, and Icons.

Can be one of the following: Butt, Round, and Square.

FillPattern Property

Specifies a fill pattern for an object. Applies to Chart Platforms, Chart Coordinate Paper, Chart Legends, Walls, Floors, Axes, Tick Marks, Labels, Fonts, and Icons.

Can be one of the following: Color, Gradient, Image, None, and Texture.

Option Description Notes

Color Fills with specified color.

Gradient Fills with gradient colors.

Image Fills with specified image. (Not available for legend icons)

None No fill (Default).

Texture Fills with specified texture.

Option	Description	Notes
Color	Fills with specified color.
Gradient	Fills with gradient colors.
Image	Fills with specified image.	(Not available for legend icons)
None	No fill (Default).
Texture	Fills with specified texture.

FontSpecialEffect Property

Specifies special effect for the font. Applies to Fonts.

Can be one of the following:

Group Option Description

1st Set Embossed Makes the text appear as if it is raised off the page in relief.

Engraved Makes the text appear to be imprinted or pressed into the page.

None Don't apply any special effect to the text (Default).

Outlined Displays the inner and outer borders of each character.

Shadowed Adds a shadow behind the text, beneath and to the right of the text.

Shadowed & Outlined Makes the text outlined and shadowed.

2nd Set Subscript Makes the text below the baseline and changes it to a smaller size.

Superscript Makes the text above the baseline and changes it to a smaller size.

None Don't apply any special effect to the text (Default).

Group	Option	Description
1st Set	Embossed	Makes the text appear as if it is raised off the page in relief.
	Engraved	Makes the text appear to be imprinted or pressed into the page.
	None	Don't apply any special effect to the text (Default).
	Outlined	Displays the inner and outer borders of each character.
	Shadowed	Adds a shadow behind the text, beneath and to the right of the text.
	Shadowed & Outlined	Makes the text outlined and shadowed.
2nd Set	Subscript	Makes the text below the baseline and changes it to a smaller size.
	Superscript	Makes the text above the baseline and changes it to a smaller size.
	None	Don't apply any special effect to the text (Default).

FontStrikeThrough Property

Specifies the style of the horizontal line with which the font is struck through. Applies to Fonts.

Can be one of the following:

Option Description

Bold Line Draws a bold line through the text.

Double Lines Draws two lines through the text.

None Don't draw any line through the text (Default).

Thin Line Draws a normal line through the text.

Option	Description
Bold Line	Draws a bold line through the text.
Double Lines	Draws two lines through the text.
None	Don't draw any line through the text (Default).
Thin Line	Draws a normal line through the text.

FontStyle Property

Specifies a font style for an object. Applies to Fonts.

Can be one of the following: Bold, Bold Italic, Italic, and Plain.

FontUnderline Property

Specifies the style of the horizontal line under text. Applies to Fonts.

Can be one of the following:

Option Description

Bold Double Draws two bold lines under the text.

Bold Line Draws a bold line under the text.

Bold Lower Draws a bold line under the text at a lower position.

Bold Patterned Draws a bold line under the text, using the pattern of the text font.

Double Lines Draws two normal lines under the text.

None No underline (Default).

Patterned Line Draws a normal line under the text, using the pattern of the text font.

Single Draws a normal line under the text.

Single Lower Draws a normal line under the text at a lower position.

Option	Description
Bold Double	Draws two bold lines under the text.
Bold Line	Draws a bold line under the text.
Bold Lower	Draws a bold line under the text at a lower position.
Bold Patterned	Draws a bold line under the text, using the pattern of the text font.
Double Lines	Draws two normal lines under the text.
None	No underline (Default).
Patterned Line	Draws a normal line under the text, using the pattern of the text font.
Single	Draws a normal line under the text.
Single Lower	Draws a normal line under the text at a lower position.

GradientStyle Property

Specifies a gradient style for an object. Applies to Chart Platforms, Chart Coordinate Paper, Chart Legends, Walls, Floors, Gridlines, Axes, Tick Marks, Labels, Fonts, and Icons.

Can be one of the following: Cyclic Linear, Linear, Square Radial and Round Radial.

Hyperlink Property

Specifies a URL with a link to the chart. Applies to Chart Platforms.

The property is used to add a hyperlink to the chart that refers to another report or a web site. You can control the hyperlink property with a formula, which will be a good way for one report to get only useful data from another report.

For example, you have two reports A and B. In report A, data are grouped by customer country and one chart is used to illustrate the count of Customer_ID in every group. Report B shows the information of customer, such as ID, Name, Annual Sales, etc. Now we build a link between two reports. When running report A, the data in a specific country pops up by clicking the bars of relevant country in report A.

Copy ReportB.cls and Tutorial.cat to a new folder. Launch JReport Enterprise Server and deploy the folder to the server.

Load JReport Designer and open ReportA. Create a new formula named Link_b. It might be like the following,

string t="http://localhost:8888/jrserver/test/Tutorial.cat/ReportB.cls?jrs.cmd=jrs.web_vw&jrs.authorization=YWRtaW46YWRtaW4%3D&"; string t1="jrs.param$PCOUNTRY="; string url=t+t1+"@INNER+&jrs.result_type=1"; return urlNotes:

1). Please make sure that the paths of the catalog and the report in the URL are corresponding with their paths on the server.
2). For the XHyperlink and ZHyperlink properties, you can use @XDIM and @ZDIM respectively instead of @INNER and @OUTER.

In Report Inspector, select ChartPlatform, and set the Hyperlink property to Link_b.

Move the mouse cursor on a bar and double-click itt, the corresponding records will be displayed.

For example, click the Canada bar, ReportB will run and display only Canada data as below.

Use the Back button to get back to the ReportA. You can also view the information of the other countries by clicking the corresponding bars in ReportA.

If you want to run report A in the server/client mode with JReport Enterprise Server, select HTML format to view the report. You can also get the hyperlink pointing to report B.

IconAlignment Property

Specifies how icon is aligned in an object. Applies to Labels, Legend labels.

Can be one of the following: Bottom-Center, Bottom-Right, Left-Bottom, Left-Center, Left-Top, Right-Center, Right-Top, and Top-Center.

IconStyle Property

Specifies a style for the icon object. Applies to Icons.

Can be one of the following: Circle, Cross1, Cross2, Diamond, No Icon, Rectangle, TriangleDown, TriangleLeft, TriangleRight, TriangleUp.

IconStyleList Property

Specifies the style for the icon of each category name. The icon style for each category name can be different. Applies to Legend Icon.

Type the icon style codes side by side in the IconStyleList property entry to define the icon style for each icon. An icon style code is a two-digit number stands for an icon style. For instance, use string "00010203" will change the 1st icon to a rectangle, 2nd to a diamond, 3rd to a triangle pointing up, and 4th to a triangle pointing down.

The icon style codes are:

Code Description

00 Rectangle.

01 Diamond.

02 Triangle Up.

03 Triangle Down.

04 Triangle Left.

05 Triangle Right.

06 Circle.

07 Cross1. Cross in the form of "+".

08 Cross2. Cross in the form of "X".

Code	Description
00	Rectangle.
01	Diamond.
02	Triangle Up.
03	Triangle Down.
04	Triangle Left.
05	Triangle Right.
06	Circle.
07	Cross1. Cross in the form of "+".
08	Cross2. Cross in the form of "X".

ImageLayout Property

Specifies a layout style for the image. Applies to Images.

Can be one of the following:

Option Description

Center Display the image in the center of the area.

Scaled Stretch the image to cover the entire area.

Tile Repeat the image over the entire area (default).

Option	Description
Center	Display the image in the center of the area.
Scaled	Stretch the image to cover the entire area.
Tile	Repeat the image over the entire area (default).

LabelStartValueY1 (LabelStartValueY2) Property

Specifies from where the Y1 (Y2) axis label will start to be shown. Only for 2-D charts that have wall. Applies to Chart Coordinate Paper.

Can be any float number. The default value is 0.

The following picture (example) shows the result when you set the LabelStartValueY1 to 100, and LabelStartValueY2 to 15000.

LabelValue Property

Specifies a data label type for data labels. Applies to Pie Charts.

Can be one of the following:

Option Description

None No data labels.

Intact Shows the original value for the point (default).

Percent Shows the percentage of the total.

Option	Description
None	No data labels.
Intact	Shows the original value for the point (default).
Percent	Shows the percentage of the total.

LineJoint Property

Specifies the line joint style for the pen object. Applies to Chart Platforms, Chart Coordinate Paper, Chart Legends, Gridlines, Axes, Tick Marks, Labels, Fonts, and Icons.

Can be one of the following: Bevel, Miter, and Round.

LineNodeStyle Property

Specifies a line node style for the data series lines. Only for 2-D chart that contain lines. Applies to Chart Coordinate Paper.

Can be one of the following: Circle, Cross, None, Plus1, Plus2, Square1, Square2, Star, Triangle1, and Triangle2.

MeanLineNodeStyle Property

Specifies the node style for the mean line. Only for 2-D charts (except Stock Charts, Radar Charts, Scatter Charts, and Bubble Charts). Applies to Chart Walls.

Can be one of the following: Circle, Cross, None, Plus1, Plus2, Square1, Square2, Star, Triangle1, and Triangle2.

MeanLineType Property

Specifies the type for the mean line. Only for 2-D charts (except Stock Charts, Radar Charts, Scatter Charts, and Bubble Charts). Applies to Chart Walls.

Can be one of the following: Curve2, Curve3, Line, and None.

Mode Property

Specifies the mode for the chart coordinate paper. Only for 3-D charts. Applies to Chart Coordinate Paper.
Can be one of the following:

Option Description

Rotation The Coordinate Paper can be rotated using mouse dragging in design mode.

Resizing The Coordinate Paper can be resized using mouse dragging in design mode.

Option	Description
Rotation	The Coordinate Paper can be rotated using mouse dragging in design mode.
Resizing	The Coordinate Paper can be resized using mouse dragging in design mode.

PatternList Property

Specifies the pattern and color of the data markers.

Click the ... button to the right and click the small square in the color tray to pick the patterns for the data markers.

The patterns can be one or more of the following: None, Colors, Textures, and Gradients.

If None is selected for a data marker, this small square will be removed from the color tray, and the default color will be assigned to the data marker by JReport Designer.

PenStyle Property

Specifies the style for the pen object. Applies to Chart Platforms, Chart Coordinate Paper, Chart Legends, Gridlines, Axes, Tick Marks, Labels, Fonts, and Icons.

Can be one of the following: 2Dots,2Dashes, 2Dots,3Dashes, Dash-Dotted, Dashed, Dotted, Fine Dotted, Invisible, Line Dots, Long Dashed, and Solid Line.

PenThickness Property

Specifies the thickness for the pen object. Applies to Chart Platforms, Chart Coordinate Paper, Chart Legends, Gridlines, Axes, Tick Marks, Labels, Fonts, and Icons.

Note: The values of this property you set in the Report Inspector are in inches, while the values of this property you set using dialogs are all in pixels.

SizeOfPart1 Property

Specifies the number of data series groups represented on the Y1 axis. Applies to Chart Platforms. This property is used for combination charts, such as Bar-Line Chart and Line-Line Chart.

By setting this value, you can control how the chart data series will be assigned to the Y1 axis and the Y2 axis. For example, in a Bar-Line chart, there are five data series, if we set this property to 1, then the first data series will be represented by bars, using the Y1 axis; the other four data series will be represented by lines, using the Y2 axis.

Can be an integer between 0 and Number of Data Series.

If the value is out of this range, the following rules will be applied as the default value:

IF THEN

<= -1 -1 (Default). If the number of data series is an odd number, it will be divided by 2 and then plus 1, else it will be just divided by 2. For example, for the chart that has 3 data series, by default, there will be 2 (3 / 2 + 1 = 2) data series using the Y1 axis.

= 0 All the data serise will be using the Y2 axis.

> Number of Data Series All the data series will be using the Y1 axis.

Note: The data series that use the Y1 axis will use the first type of data marker, for example, for a Bar-Line chart, the data series that use the Y1 axis will use the bar marker, and the others that use the Y2 axis will use the line marker.

IF	THEN
<= -1	-1 (Default). If the number of data series is an odd number, it will be divided by 2 and then plus 1, else it will be just divided by 2. For example, for the chart that has 3 data series, by default, there will be 2 (3 / 2 + 1 = 2) data series using the Y1 axis.
= 0	All the data serise will be using the Y2 axis.
> Number of Data Series	All the data series will be using the Y1 axis.

StartOffset(1st.Data.Set), EndOffset(1st.Data.Set), StartOffset(2nd.Data.Set), and EndOffset(2nd.Data.Set) Properties

These four properties are used to control the data source range that appears on the chart. Applies to Chart Platforms.

For 2-level-group charts, record-level charts and all kinds of combination charts, StartOffset(1st.Data.Set) and EndOffset(1st.Data.Set) are used to control the starting offset and ending offset of the data series; StartOffset(2ndDataSet) and EndOffset(2nd Data.Set) are used to control the range of the categories.

For 1-level-group charts, StartOffset(2nd.Data.Set) and EndOffset(2nd.Data.Set) are used to control the starting offset and ending offset of the categories; StartOffset(1st.Data.Set) and EndOffset(1st.Data.Set) don’t work because there is no series data in chart that contains only one group.

For example, your chart may contain the output performance data of zone #1 and #2, divided and compared by work weeks, from work week 27 to work week 31. The chart is as below,

You can use these four properties to control the data range, for example, to show only the data of ZONE 1 for WW28, WW29, WW30. Set these four properties as shown in the following picture.

The chart shows the data as below.

The range of the property values can be -1 (Default, Not Set) or an integer between 0 and Number of Data Series – 1 (or, Number of Categories - 1).

If the value is out of this range, the following rules will be applied as the default value:

IF THEN

StartOffset(1st.Data.Set) < 0 StartOffset(1st.Data.Set) = 0

StartOffset(1st.Data.Set) > max data number StartOffset(1st.Data.Set) = max data number

EndOffset(1st.Data.Set) < 0 EndOffset(1st.Data.Set) = max data number

EndOffset(1st.Data.Set) > max data number EndOffset(1st.Data.Set) = max data number

StartOffset(1st.Data.Set) > EndOffset(1st.Data.Set) and EndOffset(1st.Data.Set) >=0 StartOffset(1st.Data.Set) = 0, EndOffset(1st.Data.Set) = max data number

Same rules apply to StartOffset(2nd.Data.Set) and EndOffset(2nd.Data.Set).

IF	THEN
StartOffset(1st.Data.Set) < 0	StartOffset(1st.Data.Set) = 0
StartOffset(1st.Data.Set) > max data number	StartOffset(1st.Data.Set) = max data number
EndOffset(1st.Data.Set) < 0	EndOffset(1st.Data.Set) = max data number
EndOffset(1st.Data.Set) > max data number	EndOffset(1st.Data.Set) = max data number
StartOffset(1st.Data.Set) > EndOffset(1st.Data.Set) and EndOffset(1st.Data.Set) >=0	StartOffset(1st.Data.Set) = 0, EndOffset(1st.Data.Set) = max data number

TextAlignment Property

Specifies how text is aligned in an object. Applies to Labels, and Legend Labels.

Can be one of the following: Bottom, Center, Left, Right, and Top.

TextureStyle Property

Specifies a texture style for an object. Applies to Chart Platforms, Chart Coordinate Paper, Chart Legends, Walls, Floors, Axes, Labels, Fonts, and Icons.

Can be one of the following: Big Dot, Blurred Diamond, Blurred Diamond, Diagonal Down, Diagonal Up, Diagonal Up, Diamond Grid, Grid, Horizontal Line, None, Raised Rectangle, Small Dot, Triangle, and Vertical Line.

ThresholdLineStyle Property

Specifies a style for the threshold lines. Applies to Chart Coordinate Paper. Please note that Stock Charts, Radar Charts, Scatter Charts, and Bubble Charts has no threshold lines.

A threshold line marks a specific data point that is specified by the user. It is usually used for the user to compare the data series with it to see whether the data is higher or lower than that point. For example, if you want to see whether the production zones successfully accomplished their production tasks, you can set a threshold line to represent the goal output, and the other to represent the lowest acceptable output quantity. By using the threshold lines, you can spot out the zones that are out of the range at a glance.

For a 3-D chart, the threshold line velue is represented by a plane.

Can be one of the following:

Option Description

Style1 Use two threshold areas (ThresholdLine and ThresholdLine2) to emphasize the data series that are higher or lower than points the threshold lines mark.

Style2 Use a single threshold area (ThresholdLine) to emphasize the data series that are between the higher and the lower threshold lines.

Option	Description
Style1	Use two threshold areas (ThresholdLine and ThresholdLine2) to emphasize the data series that are higher or lower than points the threshold lines mark.
Style2	Use a single threshold area (ThresholdLine) to emphasize the data series that are between the higher and the lower threshold lines.