HDS Column Properties
This topic lists the properties of a Column object in a hierarchical data source table.
Property Name | Description |
---|---|
General | |
Array | Specifies whether the column is an array type or not.
Data type: Boolean |
Column Name | Specifies the name of the column in the raw data source.
Data type: String |
Currency | Specifies whether to control the SQL type of formulas or summaries in which the BigDecimal type fields are imported.
Data type: Boolean |
Description | Specifies the description of the column.
Data type: String |
Display Width | Specifies the display width of the column. Type a numeric value to change the width.
Data type: Float
|
Full Name | Displays the full path name of the column automatically generated by Logi Report. This property is read only. |
HDS Format | Specifies the data format of the column.
Data type: String |
Name | Specifies the mapped name of the column in the catalog.
Data type: String |
Nullable | Specifies the nullability of the column's value. Choose an option from the drop-down list.
Data type: Enumeration |
Precision | Specifies the precision of the column's value. The default value comes from data source metadata and it specifies the column's largest number of digits. The larger the precision is, the more memory it might take, however, the more accurate values you will get.
Data type: Integer |
Scale | Specifies the number of digits to the right of the decimal point for the column's value.
Data type: Integer |
SQL Type | Specifies the SQL type of the column defined in Java. Choose an option from the drop-down list.
Data type: Integer |
Text Format | |
Auto Fit | Specifies whether to adjust the width and height of the column according to the contents.
Data type: Boolean |
Auto Scale in Number | The property is available when the column is of the Number data type. It specifies whether to
automatically scale the column values that fall into the two ranges:
The option "auto" means that the property setting follows that of the parent data container when the column is added in a report. 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 column's value. The format varies with the column's data type and can be defined manually.
Data type: String |
Horizontal Alignment | Specifies the horizontal justification of the text in the column. 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 column. 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 |
Padding | |
Bottom Padding | Specifies the space between the text and the bottom border of the column. 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 column. 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 column. 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 column. Type a numeric value to change the padding.
Data type: Float |
Geometry | |
Height | Specifies the height of the column, which takes effect when the column is inserted into a report. By default, no value is specified to the property, which means a height will be assigned to the column by Logi Report automatically. Type a numeric value to change the height.
Data type: Float |
Width | Specifies the width of the column, which takes effect when the column is inserted into a report. By default, no value is specified to the property, which means a height will be assigned to the column by Logi Report automatically. Type a numeric value to change the width.
Data type: Float |
Color | |
Background | Specifies the background color of the column. Choose a color from the drop-down list or select Custom to customize a color. 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 column. Choose a color from the drop-down list or select Custom to customize a color. You can also type a hexadecimal RGB value (for example, 0xff0000) to specify a color.
Data type: String |
Border | |
Border Color | Specifies the color of the border of the column. Choose a color from the drop-down list or select Custom to customize a color. 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. Type a numeric value to change the thickness.
Data type: Float |
Bottom Line | Specifies the line style of the bottom border of the column. Choose a style from the drop-down list.
Data type: Enumeration |
Left Line | Specifies the line style of the left border of the column. Choose a style from the drop-down list.
Data type: Enumeration |
Right Line | Specifies the line style of the right border of the column. Choose a style from the drop-down list.
Data type: Enumeration |
Shadow | Specifies whether or not to draw two shadowed borders, beneath and to the right of the column.
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. You can also type a hexadecimal RGB value (for example, 0xff0000) to specify a color.
Data type: String |
Top Line | Specifies the line style of the top border of the column. Choose a style from the drop-down list.
Data type: Enumeration |
Pattern | |
Pattern Color | Specifies the color with which to draw a pattern to fill the column. Choose a color from the drop-down list or select Custom to customize a color. 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: Enumeration |
Others | |
Data Mapping File | Specifies the data mapping file to the object for NLS use.
For example, if the data mapping file name is Category_de_DE.properties, set the value as Category (without the language and locale part). Data type: String |
Nullable
The Nullable property decides the nullability of a column's value, and its value can be one of the following:
- true - Indicates the column supports null value.
- false - Indicates the column's value cannot be null.
- unknown - Indicates whether the column's value can be null or not is unknown.
In versions prior to Designer v8, when the return value of a column is null, of which the nullability is false, there will be a default value replacing that null value. When you upgrade Designer from a previous version to Version 8, there is a change considering better use and control of null value, that is, if null value is returned whereas you specify null value is not allowed on the column, the null value would display as it is. If you want to change the null value to any other desired values, formulas can be applied. For example, with the following formula, the null value is changed to 0:
if (isnull (@theColumn))
return 0
else
return @theColumn;