A detailed chart property reference

Border Type

Specifies a border type for an object. The settings for Border Type are:

Option Description
None The object has no visible border lines (default value).
Raised The object has 3D borders that appears as if it is raised off the page.
Recess The object has 3D borders that appear as if it is pressed into the page.
Shadow The object has two shadowed borders, beneath and to the right of the object.
Solid The object has single-line borders.
Data Format

Specifies the data format for the labels of the axes or legend as required. Applies to chart platforms.

Click at the right and select the data format as required:

Format Type Option Description (Sample)
Scale Obtains a new value by a calculation on the value.
Logarithm Calculates ten to the power of the value.
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. A minus sign is used as the negative prefix (123,456/-123,456).
0.00 Formats a decimal number to a fixed-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. A 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 $. A minus sign is used as the negative prefix ($123,456/-$123,456).
$0.00 Formats a decimal number to a fixed-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 $. A 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: multiplied by 100 and shown as an integer percentage (12%).
0.00% Formats a decimal number to percentage: multiplied by 100 and shown as a fixed-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 the single quote itself, use two in a row: # o''clock.
Date/Time Re-formats the date/time value (For 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, shown in number format (12).
MMM Formats a date to month in year, shown in the abbreviated form (Dec).
MMMMMMMM Formats a date to month in year, shown 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, minutes in an 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, minutes in an hour, and second in minute (12:00:00).
hh:mm:ss a Formats a date to hour in am/pm 1~12, minutes in an 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 (shown in full form), days in a month, year, era designator, day in week (shown in the full form), hour in a day, 1~12, minutes in an 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 such as ':', '.', ' ', '#' and '@' will appear in the resulting time text even they are not embraced within single quotes.
  • A pattern containing any invalid pattern letter can not be added to the filter stack.
Text Specifies the length of the value.
Default Length Uses the length of the string Default Length, which is 14, as the length of the string. Any letters that exceed this length will be cut. You can modify this string, adding or deleting 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 is longer 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 Thu Jul 04 2002, with a new string US National Day, just type 2 in the Argument# box, type US National Day in the Map to box, and then 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 the data labels from the second one to the fifth with a new name My Holiday, just type 2 in the first Argument# box and 5 in the second Argument# box, then type My Holiday in the Map to box, and finally click Add to add it to the 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, type Chen in the Original Text box, type Jinfonet in the Map to box, and then click Add to add it to the 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 in the axis label.
Prefix Add a string before the text in the data label of the axis. For example, if you want to add NA before the text in the data label of the X axis, type NA in the Map to box, and click Add to add it to the Stack.
Suffix Add a string behind the text in the data label of the axis. For example, if you want to add NA behind the text in the data label of the X axis, type NA in the Map to box, and click Add to add it to the Stack.

Note: The data labels along each axis count from 0, which means the number of the first data label you see on the axis will be 0, the second will be 1, the third will be 2, etc.

End Caps

Specifies the ending style of the border line. The option may be:

Fill Type

Specifies a fill pattern for an object. Applies to chart platforms, chart paper, chart legends, walls, floors, axes, tick marks, labels, fonts and icons. Can be one of the following:

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

Specifies a special effect for the text. Applies to fonts. Can be one of the following:

Option Description
None Does not apply any special effect to the text (default).
Embossed Makes the text appearing as if it is raised off the page.
Engraved Makes the text appearing as if it is imprinted or pressed into the page.
Shadowed Adds a shadow behind, beneath and to the right of the text.
Outlined Displays the inner and outer borders of each character.
Shadowed & Outlined Makes the text to be outlined and shadowed.
Font Script

Specifies superscript/subscript form for the text. Applies to fonts. Can be one of the following:

Option Description
None Does not apply superscript or subscript form to the text (default).
Superscript Makes the text to be shown above the baseline and changes it to a smaller size.
Subscript Makes the text to be shown below the baseline and changes it to a smaller size.
Font Strikethrough

Specifies a style for the horizontal line with which the text is struck through. Applies to fonts. Can be one of the following:

Option Description
None Does not draw any line through the text (default).
Thin Line Draws a normal line through the text.
Bold Line Draws a bold line through the text.
Double Lines Draws two lines through the text.
Font Style

Specifies a font style for an object. Applies to fonts. Can be one of the following: Plain, Bold, Italic, and Bold Italic.

Font Underline

Specifies a style for the horizontal line under the text. Applies to fonts. Can be one of the following:

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

Specifies a gradient style for an object. Applies to chart platforms, chart paper, chart legends, walls, floors, gridlines, axes, tick marks, labels, fonts, and icons.

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

Hyperlink

This 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 to get required data from another report.

For example, you have two report sets A and B in the SampleReports.cat catalog. In report set A, the data in a banded object is grouped by customer country and a chart is used to illustrate the count of Customer_ID in every group. Report set B shows the information of customer, such as ID, Name, and Annual Sales. Now we build a link between the two reports. In JReport Web, run report set A, click the bar of a country, and report set B will appear, only showing the data of the specific country. The steps are:

  1. Copy ReportB.cls and SampleReports.cat to a new folder. Launch JReport Enterprise Server and deploy the folder to the server.
  2. Load JReport Designer and open ReportA.cls. Create a new formula named Link_b. It might be:
    string t="http://localhost:8888/jrserver/test/SampleReports.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 url
    

    Notes:

    • Make sure that the paths of the catalog and the report set in the URL are corresponding with their paths on the server.
    • The built-in parameter INNER is used for representing the category data. In addition, you can use OUTER for the series data.
    • For the X HyperLink and Z HyperLink properties, you can use @XDIM and @ZDIM respectively instead of @INNER and @OUTER.
  3. In the Report Inspector, set the Hyperlink property of the chart platform to Link_b.
  4. After publishing the report sets and catalog, run report set A, move the mouse cursor on a bar and click it, the corresponding records will be displayed. You can also view the information of the other countries by clicking the corresponding bars in report set A.
Icon Alignment

Specifies how to align icon in an object. Applies to labels and legend labels.

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

Icon Style

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

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

Style List

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 Style List property entry to define the icon style for each icon. An icon style code is a two-digit number standing for an icon style. For instance, use string 00010203, the 1st icon will change to a rectangle, 2nd to a diamond, 3rd to an upward triangle, and 4th to a downward triangle.

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".
Image Layout

Specifies a layout style for an image. Applies to images. Can be one of the following:

Option Description
Tile Repeats the image over the entire area (default).
Center Displays the image in the center of the area.
Scaled Stretches the image to cover the entire area.
Image X, Image Y, Image Width, Image Height

The four properties are used to define a portion of an image. Image X specifies the percentage equal to the distance between the left border of the portion and that of the image out of the image width. Image Y specifies the percentage equal to the distance between the top border of the portion and that of the image out of the image height. Image Width and Image Height specify the width and height of the portion relative to the image. JReport will use the portion to fill the background instead of the whole image.

Start Value

Specifies the position from where the axis label will start to be shown. Only for 2-D charts that have wall. Applies to chart paper.

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

Value Label Type

Specifies a value type for data labels around a pie in a pie chart.

Can be one of the following:

Option Description
Value Shows the value for the pie section.
CategoryName Shows the category name for the pie section.
Percent Shows the percentage of the section to the total.
Line Joint

Specifies the line joint style. The option may be:

Node Style

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

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

Pattern List

Specifies the pattern and color of the data markers.

Click 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, the small square will be removed from the color tray, and the default color will be assigned to the data marker by JReport Designer.

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

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

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) will not work because there is no series data in chart that contains only one group.

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 to 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).

Texture Style

Specifies a texture style for an object. Applies to Chart Platforms, Chart Paper, Chart Legends, Walls, Floors, Axes, Labels, Font s, 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.

Threshold Line Style

Specifies a style for the threshold lines. Applies to Chart Paper. Note that Stock Charts, Radar Charts, Scatter Charts, and Bubble Charts have no threshold lines.

A threshold line marks a specific data point that is specified by the user. It is usually used by the user for comparing with data series to see whether the data is higher or lower than this 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 an 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 3-D chart, the threshold line value is represented by a plane.

Can be one of the following:

Option Description
Style1 Use two threshold areas (Threshold Line1 and Threshold Line2) to emphasize the data series that are higher than the first threshold line or lower than the second threshold line.
Style2 Use a single threshold area (Threshold Line1) to emphasize the data series that are between the higher and the lower threshold lines.