Skip to main content

Formula Field

  • Updated

BackPrevious Topic  Next TopicNext

Formula Field

The properties of a formula field object are:

Property NameDescription
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
Height Specifies the height of the object, in inches. Enter a numeric value to change the height. When the formula is in a crosstab, it is available only when the DBField is used as aggregate field.

Data type: Float

WidthSpecifies the width of the object, in inches. Enter a numeric value to change the width. When the formula is in a crosstab, it is available only when the DBField is used as aggregate field.

Data type: Float

XSpecifies the horizontal coordinate of the top left corner of the object, relative to its parent container. Enter a numeric value to change the position in inches. Not available when the formula is in a crosstab.

Data type: Float

YSpecifies the vertical coordinate of the top left corner of the object, relative to its parent container. Enter a numeric value to change the position in inches. Not available when the formula is in a crosstab.

Data type: Float

Color
BackgroundSpecifies 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

ForegroundSpecifies 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 and height of the object according to the contents. For performance concern, it is recommended that you do not set both Auto Fit and Word Wrap to true when the formula is in a crosstab.

Data type: Boolean

Auto Scale in NumberThe property is available when the object is of the Number data type. It specifies whether to automatically scale the object 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 the values.

The option "auto" means that the property setting follows that of the object's parent data container.

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. Enter an integer value to change the size.

Data type: Integer

FormatSpecifies the display format of the text in the report result. It varies with data type and can be manually defined.

Data type: String

Notes:

  • For the BigDecimal data type, to avoid precision loss, you should enter a prefix JRD when setting the Format property value.
  • For the Number data type and when the Auto Scale in Number property is true, the Format property applies to the integer part of the values after scaled, but if the specified format conflicts with the Auto Scale in Number property, for example, the values are displayed in percentage, then the Auto Scale in Number property is ignored.
Horizontal AlignmentSpecifies the horizontal justification of the text in the object. 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 object. Choose an option from the drop-down list.

Data type: Enumeration

Word WrapSpecifies whether to wrap the text to the width. For performance concern, it is recommended that you do not set both Auto Fit and Word Wrap to true when the formula is in a crosstab.

Data type: Boolean

Border
Border ColorSpecifies 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 ThicknessSpecifies the width of the border in inches. Enter a numeric value to change the thickness.

Data type: Float

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

Data type: Enumeration

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

Data type: Enumeration

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

Data type: Enumeration

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

Data type: Enumeration

Padding
Bottom PaddingSpecifies 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 PaddingSpecifies 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 PaddingSpecifies 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 PaddingSpecifies 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
Display NullSpecifies the string to be displayed if the field value is null.

Data type: String

Export to CSVSpecifies whether to include the object when exporting the report to CSV.

Data type: Boolean

Export to ExcelSpecifies whether to include the object when exporting the report to Excel.

Data type: Boolean

Export to HTMLSpecifies whether to include the object when exporting the report to HTML.

Data type: Boolean

Export to PDFSpecifies whether to include the object when exporting the report to PDF.

Data type: Boolean

Export to PostScriptSpecifies whether to include the object when exporting the report to PostScript.

Data type: Boolean

Export to Report ResultSpecifies whether to include the object in Web Report Studio or when the report is opened in Web Report Result.

Data type: Boolean

Export to RTFSpecifies whether to include the object when exporting the report to RTF.

Data type: Boolean

Export to TextSpecifies whether to include the object when exporting the report to Text.

Data type: Boolean

Export to XMLSpecifies whether to include the object when exporting the report to XML.

Data type: Boolean

BackPrevious Topic  Next TopicNext