Adding a text/data or virtual field

 

If you want to add a formula (virtual field) in a report, look first for the Toolbox

 

image\toolbox.gif

 

If the Toolbox is hidden, use the command <View> <Toolbar> <Toolbox> to see it.

Once the Toolbox is visible, select the following object:

image\toolbox3.gif Allows adding a data or formula field in a report block.

Then place the mouse cursor on the required location in the block where you want to add a virtual field and give the correct size to the object thus defined.

Double-click on the object or on the right mouse button then <Properties> to display the Properties dialog box.

Select now the Data tab and in the Data Source edit box you can type directly the formula or use the Quick Expression formula generator to create or edit your formula.

The formula starts with the equal sign:

 

image\formula1.gif

 

The Quick Expression formula generator can help you to build the formula using field names and functions:

 

image\formula2.gif

 

Refer to the Text/Data Properties for more details about the properties.