Expression
Expression
Expression
A calculated field (expression field) is used for displaying text or data that
is calculated by an expression or formula. You can do numerical calculations,
string manipulations, concatenate data fields and much more.
|
Expression
|
This expression is evaluated each time the calculated field is going to be
printed (see the chapter on expression syntax). |
| Format
|
Numerical fields can be formatted by setting a format definition. |
| Font
|
Selects the font for the report element |
| Color
|
Defines the background color for the report element (the font color can be set
with the "Font" button). |
| Master
|
If your expression uses any aggregated functions, you must link the "Master" property to the dataset that will be used to
update the expression. Each time a new data record from this dataset is selected
the expression will be recalculated. |
| Alignment
|
The report element's text can be aligned left, right or centered. |
| Rotation
|
Use this to rotate your text. Rotation can be set to anything between 0 and
360 degrees. 90 degree means displaying the text vertically for example. |
| Autosize width
|
This option resizes the report element to make room for its complete text. If
"Autosize" is not set and the text is larger than the element size, text will
be clipped off. |
| Autostretch height
|
This option is for report elements with multiple lines, e.g. memo fields. The
height of the elements will be stretched to make room for all lines. If needed,
the report band will be stretched too. |
| Reset after print
|
If you are using calculations like sums or counting of data record etc., you
can use this option to reset the value of the calculation to zero after the
report element has been printed. |
| Automatic word-wrap
|
Set this option if you want the text to wrap to the next line if it does not
fit into the given width (similar to a word processor software). |
| Transparent
|
The report element's background will not be printed if this option is
activated. This way you can placije text on top of an image for example, without hiding
the image under a white box with text. |