Previous Topic
Formula Field
The properties of a formula field in a crosstab are:
| Property Name | Description | |||
|---|---|---|---|---|
| General | ||||
| Display Name | Specifies the display name of the object.
Data type: String | |||
| Instance Name | Shows the instance name of the object. This property is read only. | |||
| Geometry (only for aggregate field) | ||||
| Height | Specifies the height of the object, in inches. Enter a numeric value to change the height.
Data type: Float | |||
| Width | Specifies the width of the object, in inches. Enter a numeric value to change the width.
Data type: Float | |||
| Color | ||||
| Background | Specifies the background color of the object. Choose a color from the drop-down list or select Custom to define a color in the Color Picker dialog. 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 object. Choose a color from the drop-down list or select Custom to define a color in the Color Picker dialog. You can also enter a hexadecimal RGB value (for example, 0xff0000) to specify a color.
Data type: String | |||
| Text Format | ||||
| Auto Fit | Specifies whether to adjust the width of the object 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 | |||
| 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 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 object. 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 | |||
| Border | ||||
| Border Color | Specifies the color of the border of the object. Choose a color from the drop-down list or select Custom to define a color in the Color Picker dialog. 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 in inches. Enter a numeric value to change the thickness.
Data type: Float | |||
| Bottom Line | Specifies the line style of the bottom border of the object. Choose a style from the drop-down list.
Data type: Enumeration | |||
| Left Line | Specifies the line style of the left border of the object. Choose a style from the drop-down list.
Data type: Enumeration | |||
| Right Line | Specifies the line style of the right border of the object. Choose a style from the drop-down list.
Data type: Enumeration | |||
| Top Line | Specifies the line style of the top border of the object. Choose a style from the drop-down list.
Data type: Enumeration | |||
| Padding | ||||
| Bottom Padding | Specifies the space between the text and the bottom border of the object, in inches. 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 object, in inches. 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 object, in inches. 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 object, in inches. Enter a numeric value to change the padding.
Data type: Float | |||
| Others | ||||
| Export to Applet | Specifies whether to include the object when exporting the report to Applet.
Data type: Boolean | |||
| Export to CSV | Specifies whether to include the object when exporting the report to CSV.
Data type: Boolean | |||
| Export to Excel | Specifies whether to include the object when exporting the report to Excel.
Data type: Boolean | |||
| Export to HTML | Specifies whether to include the object when exporting the report to HTML.
Data type: Boolean | |||
| Export to PDF | Specifies whether to include the object when exporting the report to PDF.
Data type: Boolean | |||
| Export to PostScript | Specifies whether to include the object when exporting the report to PostScript.
Data type: Boolean | |||
| Export to Report Result | Specifies whether to include the object when exporting the report to Report Result.
Data type: Boolean | |||
| Export to RTF | Specifies whether to include the object when exporting the report to RTF.
Data type: Boolean | |||
| Export to Text | Specifies whether to include the object when exporting the report to Text.
Data type: Boolean | |||
| Export to XML | Specifies whether to include the object when exporting the report to XML.
Data type: Boolean | |||
Back to top