400 Chapter 16 Flexible Reporting
Removing report header titles and values
All report header titles and values are shown on a report when it is first created. If you remove a report header
title, the corresponding value will also be removed from the header. For example, if you remove the Date
range title, the date range will not be shown on the report.
To remove a report header title and value
• On the Insert tab of the ribbon, click the Header button and deselect the check box of the report
header title you want to remove. You can optionally drag and drop the report header title from the
report to the Report header list.
Report header titles removed from the report are shown in the Report header list in the Toolbox
window.
Adding report header titles and values
To add a report header title and value to a report
• On the Insert tab of the ribbon, click the Header button and select the check box of the report header
title you want to add. You can optionally drag and drop the report header title from the Report header
list to the report.
Adding existing columns
To add an existing column
1. On the Insert tab of the ribbon, click Add=>Existing.
Optionally, right-click the report and select Insert column=>Existing from the drop-down list.
The Add columns window opens.
NOTE: You can also drag and drop items from the Column heading list in the Toolbox window to add
existing columns to your report.
2. Select the columns you want to add to the report.
3. Click OK.
Adding custom columns
You can add custom columns to create custom calculations using expressions or blank columns. The ability to
create custom calculations using expressions enables you to further customize report data to suit your
specific business needs. Blank columns can be used as spacers to make reports easier to read, or as
placeholders for importing third-party data after a Flexible Reporting report has been generated.
NOTE:
• Adding columns containing custom calculations requires a thorough understanding of Microsoft Excel
and regular expressions.
• We recommend you preview reports containing custom calculations in Flexible Reporting before
saving the changes and generating the report in the Contact Center Management website.
To add a column containing custom calculations
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. Right-click a cell in the blank column and select Expression.
The Edit expression window opens.
NOTE: You cannot create calculations using expressions in a header cell.
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.