Cisco Cisco Unified Contact Center Enterprise 9.0(4) User Guide
19
Cisco ICM Software Custom Screen Builder Guide
Chapter 3 Creating a New Report Template
Step 4: Create the SQL Statement
Figure 3-3
The SQL Select Painter
3.
In each table, select the columns that you want to display in the report. The columns
you select display in the left side of the Sort tab in the SQL Toolbox.
you select display in the left side of the Sort tab in the SQL Toolbox.
–
For drill-down reports, make sure that your selected columns include
EnterpriseName from that category’s configuration table.
EnterpriseName from that category’s configuration table.
–
To deselect a column, click its name a second time.
4.
Optional: If the report’s presentation type is grid, you can specify the column order
and sort order by dragging column names from the left side of the Sort tab to the
right.
and sort order by dragging column names from the left side of the Sort tab to the
right.
–
Within the right-side of the Sort tab, you can drag columns up and down to
arrange into the position you want them to appear in the report.
arrange into the position you want them to appear in the report.
–
By default, column values are sorted in ascending order. To sort a column in
descending order, clear its Ascending checkbox. In an actual report, records
will be sorted initially using the first column’s sort order. For records whose
first column value is identical, the next column’s sort order will be used, and so
on.
descending order, clear its Ascending checkbox. In an actual report, records
will be sorted initially using the first column’s sort order. For records whose
first column value is identical, the next column’s sort order will be used, and so
on.
Table Select
Window
Window
SQL Toolbox
Window
Window