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:

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:

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.

Line

Depending on your preferences, you can use lines anywhere on your report.

Rectangle

Depending on your preferences, you can use rectangles anywhere on your report.

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.

Page-n-of-N

Use this element when a Text-Field with a PAGE_NUMBER expression is not enough.