Using Flexible Reporting 401
5. Double-click the item in the Item list to insert its expression into the Expression box.
6. Repeat steps 3 to 5 until the complete calculation is entered in the Expression box and click OK.
The expression displays in row two of the blank column in the report.
7. If you want to edit the expression you created, right-click the cell and select Expression to return to
the Edit expression window.
After adding a column containing custom calculations you can choose to view or modify the expression.
To view or modify an expression
1. Select the cell in the report, for which you want to view or modify the expression.
2. On the Insert tab of the ribbon, click Expression.
Optionally, right-click the column and select Expression from the drop-down list.
The Edit expression window opens.
3. Select an option in the Options list to view the associated Item list.
4. Select an item in the Item list to view the associated item Description and Expression example.
5. Double-click the item in the Item list to insert its expression into the Expression box.
6. Repeat steps 3 to 5 until the complete calculation is entered in the Expression box and click OK.
The expression displays in row two of the blank column in the report.
You can restrict the number of decimal places that will display for results. As an example, setting the number
of decimal places that will display for the Average Manned Agent statistic is described below.
To set the number of decimal places that display for results
1. In the Design view, right-click the Average Manned Agent column in the report and select
Expression from the drop-down list.
2. Change the current value of =Fields!AgentGroupEventAvgMannedAgents.Value to
=FormatNumber(Fields!AgentGroupEventAvgMannedAgents.Value,1).
3. Click OK.
4. Click Save.
The column is formatted to display one decimal place. To alter the number of decimal places
displayed, enter the appropriate number in place of 1.
To add a blank column
1. On the Insert tab of the ribbon, click Add=>Custom.
Optionally, right-click the report and select Insert column=>Custom from the drop-down list.
A blank column displays in the report.
2. Optionally, click the header cell of the blank column and type a name for the column.
Moving columns
To move a column
• On the report grid, drag and drop the column to where you want it on the grid.
Deleting columns
To delete a column
1. Click a column on the report grid.
2. On the Insert tab of the ribbon, click the Remove button.
Optionally, right-click the column and select Delete column from the drop-down list.
NOTE: Some statistics require specific columns to ensure a report is meaningful. These statistics are
associated with the required columns and cannot be deleted on their own. For example, in by period reports,
you cannot delete the interval; in by device reports, the reporting number cannot be deleted.