Skip to main content

DBField Properties

  • Updated

BackPrevious Topic  Next TopicNext

DBField Properties

This topic describes the properties of a DBField object.

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. Type a numeric value to change the height.

Data type: Float

WidthSpecifies the width of the object, in inches. Type a numeric value to change the width. When the DBField 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. Type a numeric value to change the position in inches. Not available when the DBField is in a crosstab.

Data type: Float

YSpecifies the vertical coordinate of the top left corner of the object, relative to its parent container. Type a numeric value to change the position in inches. Not available when the DBField 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 box. You can also type 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 box. You can also type 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, you should not set both Auto Fit and Word Wrap to true when the DBField is in a crosstab.

Data type: Boolean

Auto Scale in Number

Specifies whether to automatically scale the values that are of the Number data type when the values fall into the two ranges:

  • When 1000 <= value < 10^15, Logi Report uses the following quantity unit symbols of the International System of Units 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, Logi Report uses scientific notation to scale the values.

The property is available when the object is of the Number data type.

The value auto means that the setting follows that of the 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. Type 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. Not available when the DBField is in a crosstab.

Data type: String

Note icon

  • For the BigDecimal data type, to avoid precision loss, you should type 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 being scaled, but if the specified format conflicts with the Auto Scale in Number property, for example, the values display in percentage, then Server ignores the Auto Scale in Number property.
Horizontal AlignmentSpecifies the horizontal justification of the text in the object. Choose an option from the drop-down list.

Data type: Enumeration

Marks content and feature updates for Logi Report v17.1. New feature new content.Ignore HTML TagSpecifies whether or not to ignore the HTML tag elements that are included in the text of the object at runtime and in the HTML output of the report.
  • true - Logi Report Engine does not parse the HTML tag elements so they display exactly as what they are.
  • false - Logi Report Engine transfers the HTML tag elements to the web browser so they are translated into HTML by the web browser.

Note: The property Convert HTML Tag has higher priority than Ignore HTML Tag.

Data type: Boolean

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, you should not set both Auto Fit and Word Wrap to true when the DBField 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 box. 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 in inches. Type 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. Type 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. Type 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. Type 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. Type 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 CSV Specifies 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 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

BackPrevious Topic  Next TopicNext