Formula

The properties of a formula are:

Property Name Description
General
Description Specifies the description of the formula.

Data type: String
Display Width Specifies the display width of the formula. Enter a numeric value to change the width.

Data type: Float

Expression Displays the whole statement of the formula. This property is read only.
Length Specifies the length of the formula's returned value, in byte.

Data type: Integer
Name Specifies the name of the formula.

Data type: String
Number Base Specifies the number base of the formula.

Data type: Integer
Precision Specifies the precision of the formula's returned value. The default value comes from data source meta data and it specifies the value's largest number of digits.

Data type: Integer
Scale Specifies the number of digits to the right of the decimal point of the formula's returned value.

Data type: Integer
SQL Type Specifies the SQL type of the formula defined in Java. Choose an option from the drop-down list.

Data type: Integer
Text Format
Auto Fit Specifies whether to adjust the width and height of the formula according to the contents.

Data type: Boolean
Bold Specifies whether to make the text bold.

Data type: Boolean
Font Face Specifies the font of the text. Choose an option from the drop-down list.

Data type: Enumeration
Font Size Specifies the font size of the text. Enter an integer value to change the size.

Data type: Integer
Format Specifies the display format of the formula's returned value. The format varies with the formula's data type and can be defined manually.

Data type: String
Horizontal Alignment Specifies the horizontal justification of the text in the formula. Choose an option from the drop-down list.

Data type: Enumeration
Italic Specifies whether to make the text italic.

Data type: Boolean
Strikethrough Specifies whether to add a strikethrough line to the text.

Data type: Boolean
Underline Specifies whether to underline the text.

Data type: Boolean
Vertical Alignment Specifies the vertical justification of the text in the formula. Choose an option from the drop-down list.

Data type: Enumeration
Word Wrap Specifies whether to wrap the text to the width.

Data type: Boolean
Padding
Bottom Padding Specifies the space in inches or centimeters between the text and the bottom border of the formula. Enter a numeric value to change the padding.

Data type: Float
Left Padding Specifies the space in inches or centimeters between the text and the left border of the formula. Enter a numeric value to change the padding.

Data type: Float
Right Padding Specifies the space in inches or centimeters between the text and the right border of the formula. Enter a numeric value to change the padding.

Data type: Float
Top Padding Specifies the space in inches or centimeters between the text and the top border of the formula. Enter a numeric value to change the padding.

Data type: Float
Geometry
Height Specifies the height of the formula, which takes effect when the formula is inserted into a report. Enter a numeric value to change the height. The default is 0 which means a proper height will be specified to the formula by JReport automatically.

Data type: Float
Width Specifies the width of the formula, which takes effect when the formula is inserted into a report. Enter a numeric value to change the width. The default is 0 which means a proper width will be specified to the formula by JReport automatically.

Data type: Float
Color
Background Specifies the background color of the formula. Choose a color from the drop-down list, enter a hexadecimal RGB value (0xCCAA00), or select Custom from the drop-down list to specify the color.

Data type: String
Foreground Specifies the foreground color of the formula. Choose a color from the drop-down list, enter a hexadecimal RGB value (0xCCAA00), or select Custom from the drop-down list to specify the color.

Data type: String
Border
Border Color Specifies the color of the border of the formula. Choose a color from the drop-down list, enter a hexadecimal RGB value (0xCCAA00), or select Custom from the drop-down list to specify the color.

Data type: String
Border Thickness Specifies the width of the border in inches or centimeters. Enter a numeric value to change the thickness.

Data type: Float
Bottom Line Specifies the line style of the bottom border of the formula. Choose a style from the drop-down list.

Data type: Enumeration
Left Line Specifies the line style of the left border of the formula. Choose a style from the drop-down list.

Data type: Enumeration
Right Line Specifies the line style of the right border of the formula. Choose a style from the drop-down list.

Data type: Enumeration
Shadow Specifies whether or not to draw two shadowed borders, beneath and to the right of the formula.

Data type: Boolean
Shadow Color Specifies the color of the border shadow. Choose a color from the drop-down list, enter a hexadecimal RGB value (0xCCAA00), or select Custom from the drop-down list to specify the color.

Data type: String
Top Line Specifies the line style of the top border of the formula. Choose a style from the drop-down list.

Data type: Enumeration
Pattern
Pattern Color Specifies the color with which to draw a pattern to fill the formula. Choose a color from the drop-down list, enter a hexadecimal RGB value (0xCCAA00), or select Custom from the drop-down list to specify the color.

Data type: String
Pattern Style Specifies the style of the pattern. Choose an option from the drop-down list.
  • none - No pattern will be applied to the formula.
  • 50% - The formula will be filled in the specified color of 50%-transparency.
  • horizontal - The pattern will be made of horizontal lines of the specified color.
  • vertical - The pattern will be made of vertical lines of the specified color.
  • grid - The pattern will be an overlapping of horizontal and vertical lines of the specified color.
  • diagonal - The pattern will be made of slash lines of the specified color.

Data type: Enumeration

SQL Type

Option Type Option Type
-7 BIT -6 TINYINT
-5 BIGINT -4 LONGVARBINARY
-3 VARBINARY -2 BINARY
-1 LONGVARCHAR 1 CHAR
2 NUMERIC 3 DECIMAL
4 INTEGER 5 SMALLINT
6 FLOAT 7 REAL
8 DOUBLE 12 VARCHAR
16 BOOLEAN 91 DATE
92 TIME 93 TIMESTAMP
2003 ARRAY 2004 BLOB
2005 CLOB