Index

Cross Tab Child-DBField

Property Name Description Editable Formula Control Data Type
General
FieldType Display the class type: DBField. N N _
DBFieldName The mapping name in the catalog. N N _
Query The query/UDS name. N N _
Table The table name in the raw DB. N N _
Column The column name in the raw DB. N N _
DataType The Data type. You can change it in the connection node in Catalog Browser. N N _
Color
Background The background color. Specify with a string like "0xff00ff" to control or select a color from the palette. Y Y String
Foreground The foreground color. Specify with a string like "0xff0000" to control or select a color from the palette. Y Y String
Border
BorderWidth The width of the border, and can be from 1 to 3. Y N Float
BorderColor The color of the border. Specify with a string like "0xff0000" to control or select from the palette. Y Y String
TopLine The top border line style, can be Solid, Double, Dotted, Dashed, DashDot or None. Y N Int
BottomLine The bottom border line style, can be Solid, Double, Dotted, Dashed, DashDot or None. Y N Int
RightLine The right border line style, can be Solid, Double or Dotted, Dashed, DashDot or None. Y N Int
LeftLine The left border line style, can be Solid, Double, Dotted, Dashed, DashDot or None. Y N Int
Shadow Draw the shadow if it is true. Y Y Boolean
ShadowColor The color used to draw the pattern. Specify with a string like "0xff0000" or select a color from the palette. Y Y String
Pattern
PatternStyle The style to draw the pattern. They are: Vertical, Slash, Percent50, Horizontal, Hatch and None. Y N Int
TextFormat
FontFace Font to be used. Y Y String
FontSize The size of the font. Y N Float
Bold Use bold fontface if true. Y Y Boolean
Italic Use italic fontface if true. Y Y Boolean
StrikeOut Mark strikeout if true. Y Y Boolean
Underline Underline the contents if true. Y Y Boolean
Alignment Justification of the contents. The first part is for horizontal justification (center, justify, left, right), the second part is for the vertical justification (top, center, bottom). Summarily they are CenterTop, CenterCenter, CenterBottom, JustifyTop, JustifyCenter, JustifyBottom, LeftTop, LeftCenter, LeftBottom, RightTop, RightCenter and RightBottom. Y N Int
Format The display format for the field. Vary for different types of data, and can be manually defined. Y Y String
Wordwrap Wrap the displayed contents if true. Y Y Boolean
TransWhileToHtml While exporting to html format, specify whether the contents with the html key word, should be escaped to normal string instead of the key word. Y Y Boolean
Others
Suppressed If true, not displayed in the View mode. Y Y (Before Pagebreak) Boolean
ExportToCSV* If set to false, the object will not be exported when exporting the report to a csv file. Y Y Boolean
ExportToXLS* If set to False, the section will not be exported when exporting the report to Excel file. (Make sure to check Excel2000 on the Export to XLS dialog.) Y Y Boolean
SuppressedIfNull If true and the field value is null, not displayed. Y N Boolean
DisplayNull If true and the field value is null, what to be displayed.s Y Y String

Index