HDS column

The properties of an HDS column are:

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.
  • true - The formula or summary which is built with the BigDecimal type field will be BigDecimal type, and its SQL Type value will be set to 3.
  • false - The normal data type will be used for the formula or summary.

Data type: Boolean
Description Specifies the description of the column.

Data type: String
Display Width Specifies the display width of the column. Enter a numeric value to change the width.

Data type: Float

Full Name Displays the full path name of the column automatically generated by JReport. 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 JReport 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 meta data and it specifies the column's largest number of digits.

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
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
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 in inches or centimeters between the text and the bottom border of the column. Enter a numeric value to change the padding.

Data type: Float
Left Padding Specifies the space in inches or centimeters between the text and the left border of the column. Enter a numeric value to change the padding.

Data type: Float
Right Padding Specifies the space in inches or centimeters between the text and the right border of the column. Enter a numeric value to change the padding.

Data type: Float
Top Padding Specifies the space in inches or centimeters between the text and the top border of the column. Enter 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 JReport automatically. Enter 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 JReport automatically. Enter 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, enter a hexadecimal RGB value (0xCCAA00), or select Custom from the drop-down list to specify the color.

Data type: String
Foreground Specifies the foreground color of the column. Choose a color from the drop-down list, enter a hexadecimal RGB value (0xCCAA00), or select Custom from the drop-down list to specify the color.

Data type: String
Border
Border Color Specifies the color of the border of the column. Choose a color from the drop-down list, enter a hexadecimal RGB value (0xCCAA00), or select Custom from the drop-down list to specify the color.

Data type: String
Border Thickness Specifies the width of the border in inches or centimeters. Enter 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, enter a hexadecimal RGB value (0xCCAA00), or select Custom from the drop-down list to specify the 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, enter a hexadecimal RGB value (0xCCAA00), or select Custom from the drop-down list to specify the color.

Data type: String
Pattern Style Specifies the style of the pattern. Choose an option from the drop-down list.
  • none - No pattern will be applied to the column.
  • 50% - The column will be filled in the specified color of 50%-transparency.
  • horizontal - The pattern will be made of horizontal lines of the specified color.
  • vertical - The pattern will be made of vertical lines of the specified color.
  • grid - The pattern will be an overlapping of horizontal and vertical lines of the specified color.
  • diagonal - The pattern will be made of slash lines of the specified color.

Data type: Enumeration
Nullable

The Nullable property decides the nullability of a column's value, and its value can be one of the following:

In versions prior to JReport Designer Version 8, when the returned 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 JReport 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;