Crosstab Formula Editor window

This window appears when you select a crosstab component, on the Resource View panel click <Add Crosstab Formula...> under the Crosstab Formulas node, input a name for the new crosstab formula and then click OK, or right-click a crosstab formula and click Edit Formula on its shortcut menu. It helps you to add crosstab formulas, summaries and parameters and then make certain operations on them. See the window.

The following are details about options in this window:

File menu

Edit menu

View menu

Formula menu

Help menu

Toolbar

The following are commands on the toolbar:

Fields panel

Displays a list of those fields that are available for crosstab formulas. Those fields contain table columns, formulas, parameters, special fields and other crosstab formulas. Select one field and double-click it to insert it into the editing panel at the insertion point.

Functions panel

Displays a list of JReport functions and imported user defined formula functions that are available for crosstab formulas. When you select one function and double-click it, JReport will insert the selected function into the editing panel at the insertion point completely with its required syntax items (parentheses, commas, etc). For the usage of these functions, refer to section Built-in functions and User-defined formula functions.

Operators panel

Displays a list of operators that are available for crosstab formulas. Select one operator and double-click it to insert the selected operator into the editing panel at the insertion point. For the usage of these operators, refer to section Operators.

Formula text panel

In this panel, you can build and edit your crosstab formula. There are several ways to work with crosstab formula:

The line numbers of the crosstab formula are marked in the left of the panel to help you check it easily.

Related topics: