Lucent Technologies Centrevu Report Designer Version 8 User Guide

  Edit | Inputs CentreVu Report Designer Version 8 User Guide
Viewing the Input Window6-15
Viewing the Input Window6
You can view what the input window will look like at any point during the 
process of designing the report by selecting Run from the Report menu.
To return to the design mode from the report input menu, select the 
Cancel button. 

  Edit | Inputs CentreVu Report Designer Version 8 User Guide
Viewing the Input Window6-16 

  Edit | Queries CentreVu Report Designer Version 8 User Guide
Introduction7-1
7  Edit | Queries
Introduction7
A report consists of fields, charts, and grids which display data that is 
retrieved from the Call Management System (CMS) database tables. The 
definition of what data is retrieved for a specific report is done using queries. 
This chapter teaches you to create queries for reports using the Query 
Assistant, which is accessed by selecting Query from the Edit menu. The 
sections of this chapter...

  Edit | Queries CentreVu Report Designer Version 8 User Guide
Defining Queries for a Report7-2
Defining Queries for a Report7
To complete the definition of a reports grids, charts, or fields, you must 
define the queries that select the rows of the appropriate tables in the 
CMS database.
Queries are values for either database items or calculations. In most 
cases, the queries specify the input variables rather than specific values 
as criteria for retrieving information from the database. The input...

  Edit | Queries CentreVu Report Designer Version 8 User Guide
Creating a Real-Time or Historical Query7-3
Creating a Real-Time or Historical Query7
To create a new query to be used in a Designer Report, complete the 
following steps from the Report Designer Design Mode window:
1. Select Query from the Edit menu.
The Query Select “Select an existing query or add a new one” 
window appears as shown below:
2. Select the N
ew button.
The Query Assistant “Select a database and one or more tables for 
the...

  Edit | Queries CentreVu Report Designer Version 8 User Guide
Creating a Real-Time or Historical Query7-4
3. Depending on the type of report you are creating, select the 
Database radio button next to Real-Time or Historical.
The tables that are available for the type of database (Real-Time, 
Historical, or Integrated) selected display.
For instructions on creating an integrated query, see the “Creating 
an Integrated Query” section in this chapter.
4. In the T
able list, highlight the name(s) of the...

  Edit | Queries CentreVu Report Designer Version 8 User Guide
Creating a Real-Time or Historical Query7-5
6. In either the Database I
tems or Calculations box, highlight the first 
database item or calculation that you will reference in the query. To 
see a definition of the database item or calculation, click on the 
database item or calculation and then select the Data Item definition 
button.
In the O
ther box, you can type the names of Database Items or 
Calculations, strings, or constants that you...

  Edit | Queries CentreVu Report Designer Version 8 User Guide
Creating a Real-Time or Historical Query7-6
9. Select the Next button.
The Query Assistant “Choose functions for the SELECT items” 
window appears as shown below:
If you are creating a query that uses Integrated Data, the steps differ 
from this point on. See the “Creating an Integrated Query” section 
for the correct steps.
You will use this window to assign aggregate (AVG, MAX, MIN, and 
SUM) functions to the Q
uery Items. A function is a...

  Edit | Queries CentreVu Report Designer Version 8 User Guide
Creating a Real-Time or Historical Query7-7
ACDTIME and ACDCALLS database items and then defined a 
where clause of ACDTIME/ACDCALLS for a report field, CMS 
would display the value 101.53 (which is the highest average 
talk time in any single interval on 07/02/93).
lMIN — The MIN aggregate function retrieves the lowest value 
for a calculation or database item over the time frame of the 
report. For example, using the previous example, if...

  Edit | Queries CentreVu Report Designer Version 8 User Guide
Creating a Real-Time or Historical Query7-8
If you are creating a Real-Time query, you must assign Functions 
to all of the query items, or to none of the query items. Therefore, if 
any one of the query items does not have an applicable aggregate 
function, you cannot assign an aggregate function to any of the 
query items.
13. Select the N
ext button.
14. If you did not select more than one Historical database table for your 
query, skip to...