Lucent Technologies CentreVu Report Designer, User Manual

Page: 115 / 266

Edit | Queries CentreVu Report Designer Version 8 User Guide
Creating an Integrated Query
7-13
4. In the Table list, highlight the name of the table which includes the
database items or calculations that you want to include in the query.
For integrated reports, you can select one table per query.
For information on the database items and calculations available in
each table, see the
CentreVu
®
CMS R3V8 Database Items and
Calculations document (585-210-939).
5. Select the Next button.
The Query Assistant “Add the database items and calculations for
the SELECT portion of the query” window displays, as shown below.
On this window, you will add and remove database items and
calculations that will be included in the query.
6. In either the Database Items or Calculations box, highlight the first
database item or calculation that you will reference in the query.
7. Select the Add button.
The item is listed in the Query Items box.
8. Repeat Steps 6 and 7 until all of the database items and calculations
that you believe will be referenced in the query are listed in the
Query Items box.