Drag/Drop Report Elements
Report elements represent the different objects that make up a report. To add a report element to your report, simply drag and drop the element to the report section which is most appropriate.
See report sections for hints on where to drop which element. Most elements have similar properties. All properties that begin with a c_ are dependent on the c_expression property and are active only when c_expression evaluates to true.
In the default case when c_expression evaluates to false or is not defined, the properties without c_ become active.
This allows you to do conditional formatting of the form if profit = total_sales - cost > 0, make profit black, else make profit red. The following report elements and their properties are available to drag and drop to report sections on the designer window :
Static Text
Use this element to enter add text elements like column headings, footers and page titles to your report. It contains the following properties:
- staticText: Text content
- textFont: Font
- textAlignment: Text alignment
- lineSpacing: Line Spacing
- opaqueMode: Opacity
- foreColor: Foreground color
- backColor: Background color
- underLineFont: Underline Font
- strikeThroughFont: Strikethrough Font
- c_staticText: Conditional text content
- c_expression: Conditional Expression
- c_foreColor: Conditional foreground
- c_backColor: Conditional background
- c_textFont: Conditional font
- c_underLineFont: Conditional underline
- c_strikeThroughFont: Conditional strikethrough
Query-Field
This element represents the fields you defined in your data source, and is usually dropped on the
detail section of the report. See
Visual Query Builder on how to configure the data source of your report. It contains the following properties:
- textFont: Font
- textAlignment: Text alignment
- lineSpacing: Line Spacing
- opaqueMode: Opacity
- foreColor: Foreground color
- backColor: Background color
- underLineFont: Underline Font
- strikeThroughFont: Strikethrough Font
- c_expression: Conditional Expression
- c_foreColor: Conditional foreground
- c_backColor: Conditional background
- c_textFont: Conditional font
- c_underLineFont: Conditional underline
- c_strikeThroughFont: Conditional strikethrough
Text-Field
Drag and drop a Text-Field element only when you want a text field whose value depends on a function (addition, subtraction, multiplication, etc.), summary calculation (MIN, MAX, AVG, COUNT, SUM, VARIANCE, STANDARD DEVIATION), date, time, and page number that evaluates at runtime.
Otherwise, use a
Static Text or
Query Field element. Click on
expression to open the expression builder dialog and configure the expression that evaluates to the value of this text field.
- textFont: Font
- textAlignment: Text alignment
- lineSpacing: Line Spacing
- opaqueMode: Opacity
- foreColor: Foreground color
- backColor: Background color
- expression: Text Expression
- underLineFont: Underline Font
- strikeThroughFont: Strikethrough Font
- c_expression: Conditional Expression
- c_foreColor: Conditional foreground
- c_backColor: Conditional background
- c_textFont: Conditional font
- c_underLineFont: Conditional underline
- c_strikeThroughFont: Conditional strikethrough
Line
Depending on your preferences, you can use lines anywhere on your report.
- penSize: Line thickness
- opaqueMode: Opacity
- foreColor: Foreground color
- orient: Orientation (horizontal or vertical line)
- c_expression: Conditional Expression
- c_foreColor: Conditional foreground
Rectangle
Depending on your preferences, you can use rectangles anywhere on your report.
- penSize: Rectangle frame thickness
- opaqueMode: Opacity
- foreColor: Foreground color
- backColor: Background color
- c_expression: Conditional Expression
- c_foreColor: Conditional foreground
- c_backColor: Conditional background
Image
Use this element to add your company logo and other images to your report. Depending on your preferences, logos are
usually added to the
report header section.
- penSize: Image frame thickness
- opaqueMode: Opacity
- foreColor: Foreground color
- backColor: Background color
- c_expression: Conditional Expression
- c_foreColor: Conditional foreground
- c_backColor: Conditional background
- file: Image file in jpg, png, jpeg, gif formats
Page-n-of-N
Use this element when a
Text-Field with a PAGE_NUMBER expression is not enough.
- pageText: "Page" part of "Page-n-of-N"
- ofText: "Of" part of "Page-n-of-N"
- textAlignment: Text alignment
- textFont: Font
- textAlignment: Text alignment
- opaqueMode: Opacity
- foreColor: Foreground color
- backColor: Background color
- underLineFont: Underline Font
- strikeThroughFont: Strikethrough Font