Stored procedure column

The properties of a stored procedure column are:

Property Name Description Editable Data Type
General
Name The mapped column name in JReport catalog. Y String
Description Explanatory comments on the stored procedure column. Y String
GUI Field The GUI Field that will be used when the resource entity is inserted into report. Y String
Display Width The display width of a DBField, formula and summary. Y Integer
Column Name The column/parameter name. Y String
Column Index The column index in the result set. Y Integer
SQL Type The SQL type from java.sql.Types as Array, Char, Date etc. Y Integer
Precision The number of decimal digits. Y Integer
Scale The number of digits to the right of the decimal point of the stored procedure column. Y Integer
Nullable The nullability of values in the designated stored procedure column. 0 indicates the column is not null; 1 indicates it is null. Y Integer
Array Indicates whether the stored procedure column is array or not. Y Boolean
Number Base The number base of the stored procedure column. Y Integer
Length The length in bytes of data. Y Integer
Text Format
Font Face The text font of the stored procedure column. Y Enumeration
Font Size The text size of the stored procedure column. Y Integer
Bold Specifies whether or not to make the text bold. Y Boolean
Italic Specifies whether or not to make the text italic. Y Boolean
Strikethrough Specifies whether or not to add a strikethrough to the text. Y Boolean
Underline Specifies whether or not to underline the text. Y Boolean
Format The display format for the stored procedure column. It varies with data type, and can be manually defined. Y String
Autofit Specifies whether or not to adjust the size of the DB Field automatically. Y Boolean
Word Wrap Wrap the stored procedure column text to the width. Y Boolean
Vertical Alignment Vertical justification of the text in the field box. Y Enumeration
Horizontal Alignment Horizontal justification of the text in the field box. Y Enumeration
Geometry
Width The width of the stored procedure column. Y Float
Height The height of the stored procedure column. Y Float
Color
Background The background color. Y String
Foreground The foreground color. Y String
Border
Border Thickness The width of the borders. Y Float
Top Line The line style of the top border. Y Enumeration
Bottom Line The line style of the bottom border. Y Enumeration
Left Line The line style of the left border. Y Enumeration
Right Line The line style of the right border. Y Enumeration
Shadow Draws a shadow if true. Y Boolean
Border Color The color of the borders. Y String
Shadow Color The color of the shadow. Y String
Pattern
Pattern Color The color with which to draw the pattern. Y String
Pattern Style The style of the pattern. Y Enumeration