Metareport
Keyword Index
Home




© 2004-2012 Metamatica Software

_bm23Expression field

Top  Previous  Next

 

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 place text on top of an image for example, without hiding the image under a white box with text.