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...

  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...

  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...

  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....

  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...

  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...

  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...

  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...

  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...

  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...