Edit Calculation Column Dialog

This dialog enables you to create or edit calculation columns in your report smart table element. It is accessed from within the smart table by selecting the Insert smart tag above the table and selecting Insert calculation column, or double-clicking within an existing calculation column.

When you select the Insert smart tag you may see more than one Insert calculation column option in the list. Click on each option to view a vertical cursor showing you where in your report the column will be placed.

In addition to the on-screen advice, you should note the following:

Column Contents Tab

Name: Enter an appropriate name for your column.

The name will be referred to when totalling items in your report so it is important to replace the default name with a more meaningful one. The field will not accept spaces.

Condition: Click the ellipsis button to apply a true or false condition via the Edit Expression dialog. If the condition is 'true', the Display setting is checked to see if the column should be displayed. If the condition is 'false', the Display setting is not checked, and the column is hidden from the final output.

In Design mode, non-printing columns are greyed out.

Display: Select an option from the drop-down list:

Always: The current section shall always display in the table even when it has no value to display in any row.
Non-zero: The current section will only display if it has at least one value to display in any of the rows in the table.
Never: The current section shall never appear in the table, whether it has values to display or not.

Column heading: Click the ellipsis to enter a column heading or paragraph and add or configure data via the toolbar options on the Edit Text dialog.

Column values: Click the ellipsis to enter a column calculation via the Edit Expression dialog.

Column calculations can be created by deleting the default expression and selecting the Ctrl and space bar from your keyboard. This shortcut gives you a list of the data tree objects, which can be selected to form the basis of your calculation. An example would be to add two columns in the following way NewValueColumn1+ NewValueColumn2.

Column Options Tab

Column width: Click the ellipsis button to specify the column width in mm via the Edit Expression dialog.

Column style: Specify a style from the drop-down list.

Header style: Specify a style from the drop-down list.