Create Computed Column dialog

This dialog appears when you click Column > Create Computed Column on the menu bar of the Query Editor Window. It helps you to create functions quickly and easily instead of having to write formulas. See the dialog.

The following are details about options in the dialog:

Computed Column Name

Specifies the name of the computed column.

Functions

The functions here are not from JReport system. They are from the connected database you are using. Thus, if you change your data source, some of these functions may no longer exist. For each database, the different supported functions list will be returned.

Table/Column

Lists all the tables and fields which are available for creating the computed column.

OK

Applies all changes and closes the dialog.

Cancel

Does not retain any changes and closes the dialog.

Help

Displays the help document about this feature.

Related topics: