Index

Cross Tab Child-AggField

A Cross Tab is an object that summarizes data and presents the summaries in a compact row and column format.  This allows comparisons and identification of trends to be displayed.  Here are the properties for the Aggregate field inside a cross tab.

Property Name Description Editable Formula Control Data Type
Geometry
X The horizontal coordinate of the left top corner in a section. N N _
Y The vertical coordinate of the left top corner in a section. N N _
Width The width of the field, can be changed by resizing. Y N Float
Height The height of the field, can be changed by resizing. Y N Float
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. Y N Float
BorderColor The color of the border.  Specify with a string like "0xff0000" to control or select a color 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, None. Y N Int
LeftLine The left border line style, can be Solid, Double or Dotted, Dashed, DashDot, None. Y N Int
Shadow Draw the shadow if it is true. Y Y Boolean
ShadowColor The color for the shadow. Specify with the string like "0xff0000" or select a color from the palette. Y Y String
Pattern
PatternColor The color to be used to draw the pattern. Specify with the string like "0xff0000". Y Y String
PatternStyle The style to draw the pattern. There 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).  So there are CenterTop, CenterCenter, CenterBottom, JustifyTop, JustifyCenter, JustifyBottom, LeftTop, LeftCenter, LeftBottom, RightTop, RightCenter and RightBottom. Y N Int
Format The display format for the field. Varies for different types of  data, and can be manually defined. Y Y String
Wordwrap Wrap the displayed contents if true. Y Y Boolean
Others
Suppressed Do not display the field in the View mode if true. 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

Index