Lucent Technologies CentreVu Report Designer, User Manual

Page: 110 / 266

Edit | Queries CentreVu Report Designer Version 8 User Guide
Creating a Real-Time or Historical Query
7-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 Next button.
14. If you did not select more than one Historical database table for your
query, skip to Step 19.
If you selected the Historical Database for your query and are using
more than one table in the query, the “Specify all field joins for the
tables” window appears as shown below:
This window allows you to require that items between two or three
tables be equal in order to be used in the report. For instance, you
might want to select the “acd” item from each agent and make a join
clause to ensure that the report is for the same ACD information
across the tables.
15. Highlight an item in one of the table lists.
16. Highlight an item in one or both of the remaining table lists.
17. Select the Join button.
The join clause is shown in the Join Criteria box.
18. Repeat Steps 15 through 17 until all of the necessary join clauses
are listed.
19. The Query Assistant “Enter the SQL WHERE criteria” window
displays, as shown below.