Expression Line

Use the Expression Line to apply and display aggregate functions and computing fields. For each item in a report, you can display its JavaScript syntax and modify it to fit your own needs.

Image shows the Expression line.

The Expression line includes the following components:

Data Function—Shows available data functions that can be applied to table columns.

X —Cancels and removes a formula. This icon is displayed only when you enter syntax.

÷—Accepts and applies the formula. This icon is displayed only when you enter syntax.

Edit bar—Used to display, enter, and edit a JavaScript expression.

Expression Line ComponentDescription

Images shows Data Function drop down on the Expression Line.

Shows available data functions that can be applied to table columns.

Image shows the Cancel icon on the Expression Line.

Cancels and removes a formula. This icon is displayed only when you enter syntax.

Image shows the Accept icon on the Expression Line.

Accepts and applies the formula. This icon is displayed only when you enter syntax.

Edit Bar

Used to display, enter, and edit a JavaScript expression.

  To toggle the Expression line, select Expression Line icon.

  To add a expression:

  1. Select Expression Line icon.

    The Expression Line is displayed.

  2. Select the item to which to apply the expression.

  3. Select a data function from the drop-down, or write your own formula in the Expression Line.

  4. Click Image shows Accept icon.