Previous Topic
Stored Procedure Column Properties
The properties of a stored procedure column are as follows:
| 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.
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 Notes:
|
| Length | Specifies the length of the column's value, in bytes.
Data type: Integer |
| Name | Specifies the mapped name of the column in the Logi 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 |
| Number Base | Specifies the number base of the column.
Data type: Integer |
| 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 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 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 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 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 Logi 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 Logi 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 or select Custom to customize a color. You can also enter 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 enter 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 enter a hexadecimal RGB value (for example, 0xff0000) to specify a color.
Data type: String |
| Border Thickness | Specifies the width of the border. 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 or select Custom to customize a color. You can also enter 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 enter 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 |