Previous Topic
Formula Properties
This topic describes the properties of a Formula object in a catalog.
| Property Name | Description |
|---|---|
| General | |
| Description | Specifies the description of the object. Data type: String |
| Display Width | Specifies the display width of the object, which takes effect when you insert the object into reports. Type a numeric value to change the width.
If you do not set the display width, Designer applies a default width to it automatically. Data type: Float
|
| Expression | Shows the whole statement of the formula. Read only. |
| Length | Specifies the length for the return value of the formula, in byte.
Data type: Integer |
| Name | Specifies the mapped name of the object in the catalog.
Data type: String |
| Number Base | Specifies the number base of the formula.
Data type: Integer |
| Precision | Specifies the precision for the values of the object. The default precision comes from data source metadata and defines the object's largest number of digits. The larger the precision is, the more memory it might take; however, the more accurate values you can get.
Data type: Integer |
| Scale | Specifies the number of digits to the right of the decimal point for the values of the object. Data type: Integer |
| SQL Type | Specifies the SQL type of the object defined in Java. Choose an option from the drop-down list.
Data type: Integer |
| Text Format | |
| Auto Fit | Specifies whether to automatically adjust the width and height of the object according to its content.
Data type: Boolean |
| Auto Scale in Number | Designer displays this property when the object is Number data type. You can use it to specify whether to
automatically scale values of the object that fall into the two ranges:
The option "auto" means that the property setting follows that of the parent data component when you use the object in a report. Data type: Boolean |
| Bold | Specifies whether to apply bold formatting to the text in the object. Data type: Boolean |
| Font Face | Specifies the font face of the text in the object. Choose an option from the drop-down list.
Data type: Enumeration |
| Font Size | Specifies the font size of the text in the object. Type an integer value to change the size. Data type: Integer |
| Format | Specifies the format in which you want to display values of the object in reports. Choose an option from the drop-down list or type the format by yourself.
Data type: String
|
| Horizontal Alignment | Specifies the horizontal justification of the text in the object. Choose an option from the drop-down list.
Data type: Enumeration |
| Italic | Specifies whether to italicize the text in the object. Data type: Boolean |
| Strikethrough | Specifies whether to draw a line through the text in the object.
Data type: Boolean |
| Underline | Specifies whether to add a horizontal line under the text in the object. Data type: Boolean |
| Vertical Alignment | Specifies the vertical justification of the text in the object. Choose an option from the drop-down list.
Data type: Enumeration |
| Word Wrap | Specifies whether to wrap the text according to the width of the object.
Data type: Boolean |
| Padding | |
| Bottom Padding | Specifies the space between the content in the object and the bottom border of the object. Type a numeric value to change the padding. Data type: Float |
| Left Padding | Specifies the space between the content in the object and the left border of the object. Type a numeric value to change the padding. Data type: Float |
| Right Padding | Specifies the space between the content in the object and the right border of the object. Type a numeric value to change the padding. Data type: Float |
| Top Padding | Specifies the space between the content in the object and the top border of the object. Type a numeric value to change the padding. Data type: Float |
| Geometry | |
| Height | Specifies the height of the object, which takes effect when you insert the object into reports. If you do not set the height, Designer assigns a proper height to the object automatically.
Data type: Float |
| Width | Specifies the width of the object, which takes effect when you insert the object into reports. If you do not set the width, Designer assigns a proper width to the object automatically. Data type: Float |
| Color | |
| Background | Specifies the background color of the object. Choose a color from the drop-down list, or select Custom to customize a color in the Pick a Color dialog box. You can also type a hexadecimal RGB value (for example, 0xff0000) to specify a color. Data type: String |
| Foreground | Specifies the foreground color of the object. Choose a color from the drop-down list, or select Custom to customize a color in the Pick a Color dialog box. You can also type a hexadecimal RGB value (for example, 0xff0000) to specify a color. Data type: String |
| Border | |
| Border Color | Specifies the color for the border of the object. Choose a color from the drop-down list, or select Custom to customize a color in the Pick a Color dialog box. You can also type a hexadecimal RGB value (for example, 0xff0000) to specify a color. Data type: String |
| Border Thickness | Specifies the width for the border of the object. Type a numeric value to change the thickness.
Data type: Float |
| Bottom Line | Specifies the line style for the bottom border of the object. Choose an option from the drop-down list.
Data type: Enumeration |
| Left Line | Specifies the line style for the left border of the object. Choose an option from the drop-down list.
Data type: Enumeration |
| Right Line | Specifies the line style for the right border of the object. Choose an option from the drop-down list.
Data type: Enumeration |
| Shadow | Specifies whether to add a drop shadow effect to the border.
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 in the Pick a Color dialog box. You can also type a hexadecimal RGB value (for example, 0xff0000) to specify a color. Data type: String |
| Top Line | Specifies the line style for the top border of the object. Choose an option from the drop-down list.
Data type: Enumeration |
| Pattern | |
| Pattern Color | Specifies the color in which to draw a pattern to fill the object. Choose a color from the drop-down list, or select Custom to customize a color in the Pick a Color dialog box. You can also type 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: String |
| Others | |
| Data Mapping File | Specifies the data mapping file (without the locale part) you want to apply to the object for NLS use.
For example, if the data mapping file is Product_de_DE.properties, type Product in the value cell. Data type: String |
After you set the Display Width property of an object and use the object while creating a data component with wizard, Designer may adjust its width according to the paper size.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 |