Skip to main content

Previous Topic  Next Topic

Table/View/Synonym Column Properties

The properties of a table/view/synonym column are as follows:

Property NameDescription
General
ArraySpecifies whether the column is an array type or not.

Data type: Boolean

Column NameSpecifies the name of the column in the raw database. Not available for table columns in MongoDB connection and JSON connection.

Data type: String

Column TypeDisplays the type of the column. This property is read only and available only for table columns in MongoDB connection and JSON connection.
CurrencySpecifies 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

DescriptionSpecifies the description of the column.

Data type: String

Display WidthSpecifies the display width of the column. Enter a numeric value to change the width.

Data type: Float

Notes:

  • If the Display Width value of a column is not set in the Catalog Manager, the column will be inserted in a report with the default width defined by Logi JReport.
  • Assume that you have set the Display Width of a column, and used the column while creating a new component with the report wizard, its width may be adjusted according to the paper size.
Element Name
  • For table columns in MongoDB connection:

    Specifies the mapped element name in a document.

    If the column is mapped from an element of an embedded document element, the name will be a path from the embedded document element. For 'PrimaryKey' and 'ForeignKey' columns, it is blank. '\' is used as an escaped char. If the '.' and '\' are used in the element name, it will be recorded as '\.' and '\\'.

  • For table columns in JSON connection:

    Displays the mapped element name in JSON metadata. For the columns Primary Key and Foreign Key, it is blank. This property is read only.

Data type: String

NameSpecifies the mapped name of the column in the Logi JReport catalog.

Data type: String

NullableDisplays the nullability of the column's value. This property is read only.
PrecisionSpecifies 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

ScaleSpecifies the number of digits to the right of the decimal point for the column's value.

Data type: Integer

SQL TypeSpecifies 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

BoldSpecifies whether to make the text bold.

Data type: Boolean

Font FaceSpecifies the font of the text. Choose an option from the drop-down list.

Data type: Enumeration

Font SizeSpecifies the font size of the text. Enter an integer value to change the size.

Data type: Integer

FormatSpecifies 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 AlignmentSpecifies the horizontal justification of the text in the column. Choose an option from the drop-down list.

Data type: Enumeration

ItalicSpecifies whether to make the text italic.

Data type: Boolean

StrikethroughSpecifies whether to add a strikethrough line to the text.

Data type: Boolean

UnderlineSpecifies whether to underline the text.

Data type: Boolean

Vertical AlignmentSpecifies the vertical justification of the text in the column. Choose an option from the drop-down list.

Data type: Enumeration

Word WrapSpecifies whether to wrap the text to the width.

Data type: Boolean

Padding
Bottom PaddingSpecifies the space between the text and the bottom border of the column. Enter a numeric value to change the padding.

Data type: Float

Left PaddingSpecifies the space between the text and the left border of the column. Enter a numeric value to change the padding.

Data type: Float

Right PaddingSpecifies the space between the text and the right border of the column. Enter a numeric value to change the padding.

Data type: Float

Top PaddingSpecifies the space between the text and the top border of the column. Enter a numeric value to change the padding.

Data type: Float

Geometry
HeightSpecifies 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

WidthSpecifies 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
BackgroundSpecifies 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

ForegroundSpecifies 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 ColorSpecifies 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 ThicknessSpecifies the width of the border. Enter a numeric value to change the thickness.

Data type: Float

Bottom LineSpecifies the line style of the bottom border of the column. Choose a style from the drop-down list.

Data type: Enumeration

Left LineSpecifies the line style of the left border of the column. Choose a style from the drop-down list.

Data type: Enumeration

Right LineSpecifies the line style of the right border of the column. Choose a style from the drop-down list.

Data type: Enumeration

ShadowSpecifies whether or not to draw two shadowed borders, beneath and to the right of the column.

Data type: Boolean

Shadow ColorSpecifies 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 LineSpecifies the line style of the top border of the column. Choose a style from the drop-down list.

Data type: Enumeration

Pattern
Pattern ColorSpecifies 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 StyleSpecifies 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 FileSpecifies 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

Previous Topic  Next Topic

Was this article helpful?