Lucent Technologies Centrevu Report Designer Version 8 User Guide

							  Edit | Queries CentreVu Report Designer Version 8 User Guide
Editing an Existing Real-Time or Historical Query7-19
The Query Assistant “Enter the SQL WHERE criteria” window 
appears, as shown below:
This window is where you will define the SQL “where” clauses that 
will be used to retrieve data for the report. The SQL where clause 
tells the CMS to retrieve the data defined in the S
ELECT box that 
matches the criteria defined in the W
HERE box.
For more information on SQL where clauses, see Chapter 18, “SQL 
Query and CMS Database Tables Basics” in this document.
This window includes the following elements:
Item Purpose
S
ELECT 
boxShows the Query Items that were defined on the previous 
windows, including the database items and calculations 
and any associated functions assigned to the items, and 
the database table from which the database items and 
calculations are to be retrieved.
Operand1
 
boxLists the database items and calculations that can be 
used in the W
HERE clause.
O
perator 
boxLists the standard mathematical operations that can be 
used in the W
HERE clause.
Operand2
 
boxLists the database items and calculations that can be 
used in the W
HERE clause.
W
HERE 
boxShows the current WHERE clause. 
						

							  Edit | Queries CentreVu Report Designer Version 8 User Guide
Editing an Existing Real-Time or Historical Query7-20
7. In the Operand1 box, highlight the first database item or calculation 
which you want considered in the W
HERE clause.
8. In the O
perator box, highlight the appropriate operation.
9. In the Operand2
 box, highlight the second database item or 
calculation which you want considered in the W
HERE clause.
For example, if you wanted the report to select the data from the 
table when the number of ACDCALLS is greater than the number of 
ACWINCALLS, then you would select acdcalls in the Operand1 box, 
the > sign in the Operator box, and ACWINCALLS in the Operand2 
box.
10. Select the A
ND or the OR button, as appropriate.
If you place “and” between clauses, then both of the clauses must 
be true in order for CMS to retrieve the SELECT data from the table.
If you place “or” between clauses, then either of the clauses can be 
true in order for CMS to retrieve the SELECT data from the table.
11. Repeat Steps 7 through 10 until you have completed the query.
You can add your own text in the W
HERE clause (such as 
parenthesis and numbers) by placing your cursor where you would 
like the text to appear and then typing in the text.
12. Select the T
est button.
CMS checks the syntax of the query and returns a message with 
any errors.
13. Correct any of the errors detected in the Test.
14. Select the S
ave button.
15. The changes to the query are saved and the Query Select window 
displays. AND 
buttonPlaces an AND before the currently selected Operand1, 
Operator, and Operand2.
OR buttonPlaces an OR before the currently selected Operand1, 
Operator, and Operand2.
New InputTakes you to the Edit Inputs window, where you can add 
new input fields for the Report Input window.
Te s t  
buttonAllows you to test the query for basic SQL syntax errors. Item Purpose 
						

							  Edit | Queries CentreVu Report Designer Version 8 User Guide
Editing an Existing Integrated Query7-21
Editing an Existing Integrated Query7
To edit an existing integrated query 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 window appears:
2. In the Q
ueries box, highlight the name of the integrated query you 
would like to edit.
3. Select the E
dit button.
The Query Assistant “Add the database items and calculations for 
the SELECT portion of the query” window appears. On this window, 
you will add and remove database items and calculations that will be 
included in the query. 
						

							  Edit | Queries CentreVu Report Designer Version 8 User Guide
Editing an Existing Integrated Query7-22
4. In either the Database Items or Calculations box, highlight the first 
database item or calculation that you will reference in the query.
5. Select the A
dd button or double click on the item.
The item is listed in the Q
uery Items box.
6. Repeat Steps 4 and 5 until all of the database items and calculations 
that you believe will be referenced in the query are listed in the 
Q
uery Items box.
7. Select the N
ext button. 
						

							  Edit | Queries CentreVu Report Designer Version 8 User Guide
Editing an Existing Integrated Query7-23
The Query Assistant “Enter the start time for this integrated query” 
window appears:
8. Select the Input Start Time or Select Start Time Now radio button. 
If you select the S
elect Start Time Now radio button, you need to 
define the time that the integrated data will always begin 
accumulating for this report.
If you select the I
nput Start Time, a “Start Time” field will be added 
to the report input window and users can individually define the time 
that data will begin accumulating for the report.
9. Select the N
ext button. 
						

							  Edit | Queries CentreVu Report Designer Version 8 User Guide
Editing an Existing Integrated Query7-24
The Query Assistant “Select the input used to indicate the xxx for 
this query” window appears:
On this window, you can choose the input item that will be used for 
the query.
10. Highlight the input(s) you would like to use as criteria for the query. 
You can create a new input by selecting the New Inp
ut button, 
which takes you to the Edit Inputs assistant.
Only the inputs that apply to the table you selected for this query will 
appear.
11. Select the Sav
e button. 
						

							  Edit | Queries CentreVu Report Designer Version 8 User Guide
Copying a Query7-25
Copying a Query7
To copy an existing query, complete the following steps from the Report 
Designer Design Mode:
1. Select Query from the Edit menu.
The Query Select window appears:
2. In the Q
ueries box, highlight the name of the query you would like to 
copy.
3. Select the Copy
 button.
The Copy Query window appears:
4. In the T
o text box, type the name you would like to assign to the 
copied query.
5. Select the OK button.
The query is copied to the new name and the Query Select window 
appears, including the new query in the Q
ueries list. 
						

							  Edit | Queries CentreVu Report Designer Version 8 User Guide
Deleting a Query7-26
Deleting a Query7
To delete an existing query, complete the following steps from the Report 
Designer Design Mode:
If you delete a query that is used in the report, the report will not run.
1. Select Query from the Edit menu.
The Query Select window appears:
2. In the Q
ueries box, highlight the name of the query you would like to 
delete.
3. Select the D
elete button.
A message confirming the delete displays.
4. Select OK to delete the query. 
						

							  Insert | Chart CentreVu Report Designer Version 8 User Guide
Introduction8-1
8  Insert | Chart
Introduction8
Once you have defined queries (see Chapter 7, “Edit | Queries”) to be used 
for a report, you can use those queries to add a chart to your report using the 
Chart Assistant, which is accessed by selecting Chart from the Insert menu.
This chapter includes the following sections:
lInserting a chart on the report
lUsing the Chart Assistant “Select the query and data items you wish to 
plot on the chart” window (Steps 2 through 4)
lUsing the Chart Assistant “Specify a chart type” window (Steps 5 
through 9)
lUsing the Chart Assistant “Make category and series selections” 
window (Steps 10 - 15).
There are two things to keep in mind when inserting charts onto the report:
lWhen you insert a chart on a report, the chart is shown with sample data 
to help you visualize how the chart will appear when you run the report.
lEach item is initially inserted in the upper left hand corner of the report. 
You will need to drag-and-drop the chart to the location where you 
would like it to display on the report.
If you would like to edit a chart, select the chart and then choose Chart from 
the Format menu. 
						

							  Insert | Chart CentreVu Report Designer Version 8 User Guide
Inserting a Chart on a Report8-2
Inserting a Chart on a Report8
If the report includes both a chart and a grid, you need to place the chart 
above the grid on the report. The reason for this is that, if the grid spans 
multiple pages when printed and the chart is below the grid on the report, 
then the grid will print on top of the chart.
Do not position any fields or text on top of the chart because the chart will 
display on top of the field or text and the field or text will not be visible.
To insert a chart in your report, complete the following steps:
1. Select Chart from the Insert menu.
The first window of the Chart Assistant displays:
2. From the Q
ueries drop-down list, select the query from which you 
want to take data for the chart. Note that any queries that have been 
created, but still include errors are grayed-out.
The Available Data box is populated with the data that was 
previously defined for the query.
3. Use the A
dd, Add All, Remove, and Remove All buttons to add 
and remove items from the Av
ailable Data box to the Data on 
C
hart box.
Use the Move U
p and Move Down buttons to arrange the items in 
the order in which you would like them displayed on the chart.
Items that are added to the Data on C
hart box will be shown in the 
chart you are creating.
The maximum number of columns that can be included on a chart is 
16.