Formula

A formula object in a catalog contains the following properties:

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 Notes: If the Display Width value of a formula is not set in the Catalog Manager, the formula will be inserted in a report with the default width defined by JReport. Assume that you have set the Display Width of a formula, and used the formula while creating a new component with the report wizard, its width may be adjusted according to the paper size.
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 metadata 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 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 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 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 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 or select Custom to customize a color. You can also enter a hexadecimal RGB value (for example, 0xff0000) to specify a color. Data type: String
Foreground	Specifies the foreground color of the formula. Choose a color from the drop-down list or select Custom to customize a color. You can also enter a hexadecimal RGB value (for example, 0xff0000) to specify a color. Data type: String
Border
Border Color	Specifies the color of the border of the formula. Choose a color from the drop-down list or select Custom to customize a color. You can also enter a hexadecimal RGB value (for example, 0xff0000) to specify a color. Data type: String
Border Thickness	Specifies the width of the border. 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 or select Custom to customize a color. You can also enter a hexadecimal RGB value (for example, 0xff0000) to specify a 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 or select Custom to customize a color. You can also enter a hexadecimal RGB value (for example, 0xff0000) to specify a color. Data type: String
Pattern Style	Specifies the style of the pattern. Choose an option from the drop-down list. Data type: Enumeration
Others
Data Mapping File	Specifies the data mapping file to the object for NLS use. For example, if the data mapping file name is Category_de_DE.properties, set the value as Category (without the language and locale part). Data type: String

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

Notes:

If the Display Width value of a formula is not set in the Catalog Manager, the formula will be inserted in a report with the default width defined by JReport.
Assume that you have set the Display Width of a formula, and used the formula while creating a new component with the report wizard, its width may be adjusted according to the paper size.

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 metadata 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 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 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 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 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 or select Custom to customize a color. You can also enter a hexadecimal RGB value (for example, 0xff0000) to specify a color.

Data type: String

Foreground

Specifies the foreground color of the formula. Choose a color from the drop-down list or select Custom to customize a color. You can also enter a hexadecimal RGB value (for example, 0xff0000) to specify a color.

Data type: String

Border

Border Color

Specifies the color of the border of the formula. Choose a color from the drop-down list or select Custom to customize a color. You can also enter a hexadecimal RGB value (for example, 0xff0000) to specify a color.

Data type: String

Border Thickness

Specifies the width of the border. 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 or select Custom to customize a color. You can also enter a hexadecimal RGB value (for example, 0xff0000) to specify a 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 or select Custom to customize a color. You can also enter a hexadecimal RGB value (for example, 0xff0000) to specify a color.

Data type: String

Pattern Style

Specifies the style of the pattern. Choose an option from the drop-down list.

Data type: Enumeration

Others

Data Mapping File

Specifies the data mapping file to the object for NLS use.

For example, if the data mapping file name is Category_de_DE.properties, set the value as Category (without the language and locale part).

Data type: String

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

Option

Type

Option

Type

-7

BIT

-6

TINYINT

-5

BIGINT

-4

LONGVARBINARY

-3

VARBINARY

-2

BINARY

-1

LONGVARCHAR

CHAR

NUMERIC

DECIMAL

INTEGER

SMALLINT

FLOAT

REAL

DOUBLE

VARCHAR

BOOLEAN

DATE

TIME

TIMESTAMP

2003

ARRAY

2004

BLOB

2005

CLOB