#### Imported SQL column

The properties of an imported SQL column are:

Property Name | Description
--- | ---
General
Array | Specifies whether the column is an array type or not. Data type: Boolean
Column Index | Specifies the column index in the result set. Data type: Integer
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
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
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