Skip to main content

Formula Properties

  • Updated

BackPrevious Topic  Next TopicNext

Formula Properties

This topic lists the properties of a Formula object in a catalog.

Property NameDescription
General
DescriptionSpecifies the description of the formula.

Data type: String

Display WidthSpecifies the display width of the formula. Type a numeric value to change the width.

Data type: Float

Note icon

  • 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 Logi Report.
  • 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.
ExpressionDisplays the whole statement of the formula. This property is read only.
LengthSpecifies the length of the formula's return value, in byte.

Data type: Integer

NameSpecifies the name of the formula.

Data type: String

Number BaseSpecifies the number base of the formula.

Data type: Integer

PrecisionSpecifies the precision of the formula's return value. The default value comes from data source metadata and it specifies the value's largest number of digits.

Data type: Integer

ScaleSpecifies the number of digits to the right of the decimal point of the formula's return value.

Data type: Integer

SQL TypeSpecifies 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

Auto Scale in NumberThe property is available when the formula is of the Number data type. It specifies whether to automatically scale the formula values that fall into the two ranges:
  • When 1000 <= value < 10^15, the following quantity unit symbols of the International System of Units are used to scale the values: K (10^3), M (10^6), G (10^9), and T (10^12).
  • When 0 < value < 0.001 or value >= 10^15, scientific notation is used to scale values.

The option "auto" means that the property setting follows that of the parent data container when the formula is added in a report.

Data type: Boolean

BoldSpecifies whether to make the text bold.

Data type: Boolean

Font FaceSpecifies the font of the text. Choose an option from the drop-down list.

Data type: Enumeration

Font SizeSpecifies the font size of the text. Type an integer value to change the size.

Data type: Integer

FormatSpecifies the display format of the formula's return value. The format varies with the formula's data type and can be defined manually.

Data type: String

Horizontal AlignmentSpecifies the horizontal justification of the text in the formula. Choose an option from the drop-down list.

Data type: Enumeration

ItalicSpecifies whether to make the text italic.

Data type: Boolean

StrikethroughSpecifies whether to add a strikethrough line to the text.

Data type: Boolean

UnderlineSpecifies whether to underline the text.

Data type: Boolean

Vertical AlignmentSpecifies the vertical justification of the text in the formula. Choose an option from the drop-down list.

Data type: Enumeration

Word WrapSpecifies whether to wrap the text to the width.

Data type: Boolean

Padding
Bottom PaddingSpecifies the space between the text and the bottom border of the formula. Type a numeric value to change the padding.

Data type: Float

Left PaddingSpecifies the space between the text and the left border of the formula. Type a numeric value to change the padding.

Data type: Float

Right PaddingSpecifies the space between the text and the right border of the formula. Type a numeric value to change the padding.

Data type: Float

Top PaddingSpecifies the space between the text and the top border of the formula. Type a numeric value to change the padding.

Data type: Float

Geometry
HeightSpecifies the height of the formula, which takes effect when the formula is inserted into a report. Type a numeric value to change the height. The default is 0 which means a proper height will be specified to the formula by Logi Report automatically.

Data type: Float

WidthSpecifies the width of the formula, which takes effect when the formula is inserted into a report. Type a numeric value to change the width. The default is 0 which means a proper width will be specified to the formula by Logi Report automatically.

Data type: Float

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

Data type: String

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

Data type: String

Border
Border ColorSpecifies 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 type a hexadecimal RGB value (for example, 0xff0000) to specify a color.

Data type: String

Border ThicknessSpecifies the width of the border. Type a numeric value to change the thickness.

Data type: Float

Bottom LineSpecifies the line style of the bottom border of the formula. Choose a style from the drop-down list.

Data type: Enumeration

Left LineSpecifies the line style of the left border of the formula. Choose a style from the drop-down list.

Data type: Enumeration

Right LineSpecifies the line style of the right border of the formula. Choose a style from the drop-down list.

Data type: Enumeration

ShadowSpecifies whether or not to draw two shadowed borders, beneath and to the right of the formula.

Data type: Boolean

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

Data type: String

Top LineSpecifies the line style of the top border of the formula. Choose a style from the drop-down list.

Data type: Enumeration

Pattern
Pattern ColorSpecifies 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 type a hexadecimal RGB value (for example, 0xff0000) to specify a color.

Data type: String

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

Data type: Enumeration

Others
Data Mapping FileSpecifies 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

OptionTypeOptionType
-7BIT-6TINYINT
-5BIGINT-4LONGVARBINARY
-3VARBINARY-2BINARY
-1LONGVARCHAR1CHAR
2NUMERIC3DECIMAL
4INTEGER5SMALLINT
6FLOAT7REAL
8DOUBLE12VARCHAR
16BOOLEAN91DATE
92TIME93TIMESTAMP
2003ARRAY2004BLOB
2005CLOB  

BackPrevious Topic  Next TopicNext

Related articles