DBField Properties

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
Height	Specifies the height of the object, in inches. Type a numeric value to change the height. Data type: Float
Width	Specifies 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
X	Specifies the horizontal coordinate of the upper-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
Y	Specifies the vertical coordinate of the upper-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
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 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 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	Select true if you want 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
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. Type an integer value to change the size. Data type: Integer
Format	Specifies 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 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 Alignment	Specifies the horizontal justification of the text in the object. Choose an option from the drop-down list. Data type: Enumeration
Ignore HTML Tag	Specifies 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
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. 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 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 box. You can also type a hexadecimal RGB value (for example, 0xff0000) to specify a color. Data type: String
Border Thickness	Specifies the width of the border in inches. Type 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. Type 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. Type 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. Type 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. Type a numeric value to change the padding. Data type: Float
Others
Display Null	Specifies 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 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 in Web Report Studio or when the report is opened in Web 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

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

Height

Specifies the height of the object, in inches. Type a numeric value to change the height.

Data type: Float

Width

Specifies 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

X

Specifies the horizontal coordinate of the upper-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

Y

Specifies the vertical coordinate of the upper-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

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

Select true if you want 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

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

Data type: Integer

Format

Specifies 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 Alignment

Specifies the horizontal justification of the text in the object. Choose an option from the drop-down list.

Data type: Enumeration

Ignore HTML Tag

Specifies 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

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

Data type: String

Border Thickness

Specifies the width of the border in inches. Type 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. Type 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. Type 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. Type 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. Type a numeric value to change the padding.

Data type: Float

Others

Display Null

Specifies 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 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 in Web Report Studio or when the report is opened in Web Report Result.