Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IP Contact Center Release 4.6.2
  5. User Guide

Cisco Cisco IP Contact Center Release 4.6.2 User Guide

Download
Page of 62
17
Cisco ICM Software Custom Screen Builder Guide
Chapter 3      Creating a New Report Template
Step 4: Create the SQL Statement
Other presentation styles available in InfoMaker (e.g., Free Form, Composite) are not 
supported.
The data source determines how data is extracted from the database. WebView supports 
only SQL Select. Other data source methods available in InfoMaker (e.g., Quick Select, 
Query) are not supported.
How to Select the Presentation Style and Data Source
To select a presentation style and data source:
1.
On the InfoMaker toolbar, click New. The New dialog box opens.
2.
On the Object tab, select either Graph or Grid as your presentation style. These 
are the only presentation styles supported by WebView.
3.
Click OK. The Report Generator wizard opens.
4.
Select SQL Select as your data source. SQL Select is the only data source 
supported by WebView.
5.
Click Next. An untitled Report window appears along with the Select Tables dialog 
box.
Step 4: Create the SQL Statement
The fourth step in creating a report template is to create the SQL statement
About SQL Statements
The SQL statement selects the data to be included in the report. 
Note
This guide assumes that you already have a good knowledge of SQL and the 
ICM database. ICM tables are described in-depth in the Cisco ICM Software 
Database Schema Handbook. Prior to creating your SQL statement (and, indeed, 
a new template), it might also be a good idea to examine a similar standard ICM 
report template.
Creating the SQL statement consists of:
•
Selecting the tables and columns to use in the template.
•
Optionally, creating computed columns.
•
Creating a retrieval argument.
•
Constructing a Where clause.