Cisco Cisco IP Contact Center Release 4.6.2 User Guide

  ( Service_Half_Hour.DateTime < :end_date ) )   

ORDER BY Service.EnterpriseName ASC,   
  Service_Half_Hour.DateTime DESC,   
  Service_Half_Hour.CallsOfferedToHalf ASC

If desired, InfoMaker allows you to save a SQL statement so that it can be retrieved and 
used in other report templates. 

To save a SQL statement:

With the statement displayed in the SQL Select Painter, on the InfoMaker toolbar, 
click Save. A dialog box opens promting 

Enter name for the statement.

Select the library file in which to save it.

Click OK.

Once you have completed the SQL Select statement, you are ready to design the 
template’s layout. Different options are available depending on whether your 
template’s presentation style is graph or grid.

To specify the layout for a graph template:

After completing the template’s SQL statement, on the InfoMaker toolbar, click 
Return. The Define Graph Data dialog box opens. 

From the Category drop-down list, select the template column you want to assign 
to the Category axis. This represents the column whose values will serve as the 
grouping criteria for the report.

From the Values drop-down list, select the template column that you want to assign 
to the Values axis. This represents the column whose values will be measured for 
each category.

Optionally, if you want to graph more than one series, select the Series checkbox 
and specify the column that will provide the series values.

Click Next. The Define Graph Style dialog box appears.

In the Title field, enter a title for the report. This is the text that will appear at the 
top of the report when it is viewed online or printed. It also appears alongside the 
template file name when the template is listed in WebView.