Lucent Technologies CentreVu Call Management System Custom Reports Manual

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining the Rows of Data for a Report4-43
As an example of a basic “where” clause, if you are creating a real-time 
report using data from the Current Interval Split table and you have defined 
three report fields for the report:
Split: (the SPLIT database item)
ACD Calls: (the ACDCALLS database item)
Average Talk Time: (the calculation ACDTIME/ACDCALLS)
Your “where” clause might be:
Select rows where: SPLIT = 5
When you run the report,...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining the Rows of Data for a Report4-44
“Where” Clause 
with Variable
4
The previous examples create hardcoded row search conditions. That is, 
when you run the report, 
CentreVu CMS always searches for the values you 
entered in the “where” clause. However, instead of a hardcoded value, you 
can enter a variable name in a clause. A variable name tells 
CentreVu CMS 
to search for whatever value(s) you or another user choose when you...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining the Rows of Data for a Report4-45
“Where” Clause 
with a 
Range/List 
Var ia bl e
4
If a variable name, as defined in the Define Input window, has been assigned 
the Range/list option, your “where” clause must use the equals sign (=) with 
the variable name. 
“Where” Clause 
for Selecting 
Rows from an 
ACD
4
In your “where” statement, you must always include a clause to select the 
ACD. If you always want a report to find data...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining the Rows of Data for a Report4-46
Step 6: Select 
a Field/Bar 
Ty p e
4
Enter an x to select one of the following field/bar types.
Discrete
Select the Discrete type if 
CentreVu CMS will find only one value for each 
report field/bar to which you are assigning this Row Search ID. 
CentreVuCMS will find only one value if the field/bar is an aggregate 
function (SUM, AVG, MIN, or MAX), or if both of the following conditions are...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining the Rows of Data for a Report4-47
If you select Repeated horizontally, you must also enter a number in 
the Spacing field. This number tells 
CentreVu CMS how many characters 
to move horizontally from the beginning of one value to the beginning of the 
next. This means that the spacing you enter must include the blank spaces 
between fields/bars and the width of a field/bar. For example, if a field/bar is 
four characters wide...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining the Rows of Data for a Report4-48
Step 7: Select 
a Sort Type
4
Enter an x to select either ascending or descending order for values of the 
database item(s) in the Order by field. Ascending order means 
CentreVu 
CMS displays data from the lowest to the highest values. Descending order 
means 
CentreVu CMS displays data from the highest to the lowest values.
Continuing with the previous example, if the Order by database item is...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining the Rows of Data for a Report4-49
Step 8: Select 
a Sort Order 
for Data
4
Enter a database item (with its table name) in the Order by field to specify 
how multi-row data should be sequenced in the report. 
CentreVuCMS 
orders the rows of data by the values for the database item. For example, 
you might enter dsplit.ROW_DATE in the Order by field. 
CentreVu 
CMS would then display data by date, as in the following report....

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining the Rows of Data for a Report4-50
If you leave the Order by field blank, CentreVu CMS displays data in the 
report using the same sequence 
CentreVu CMS uses to store the data in the 
table.
For historical reports only, you can enter more than one database item in 
the Order by field. The database items must be separated by commas. 
The effect of more than one sorting database item is that data will be ordered 
first by values...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining the Rows of Data for a Report4-51
Step 9: Save 
Yo u r  R o w  
Search 
Conditions
4
After you have successfully saved your row search conditions, you can then 
assign the row search ID to report fields/bars.
Assign a Row 
Search ID to 
Report Field(s) 
and Bar(s)
4
To complete the definition of data for a field or bar, you must assign a row 
search ID to the field/bar. Use the following steps to do this.Select the Modify action...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining the Rows of Data for a Report4-52
If your row search conditions specify discrete fields/bars, assigned fields 
appear with lowercase xs and assigned bars appear with uppercase Xs 
(see Figure 4-17
).
Figure 4-17:  Sample Discrete Field and Bar Design
A report with the design in Figure 4-17
 might appear as shown in 
Figure 4-18
. 5.Move the cursor using the  , 
, or arrow keys. If the 
block you define contains one or 
more...