Lucent Technologies Centrevu Report Designer Version 8 User Guide

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
Creating a Custom Data Table18-19
Step 3: Add Data 
to the Table
18
To help you add data to the table, you must first create a data entry form 
associated with your table. For more information about forms, see 
“Creating Your Own Forms” in the 
INFORMIX-SQL Relational Database 
Management System User Guide
. For more information about adding 
data, see “Entering Data,” in the same document.
2j.When you have added all...

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
Creating a Custom Data Table18-20
3d.
Enter the name of the table 
you want to enter data for, 
and press  .®The Table-selection-
complete 
menu appears.
3e.Select Table-
selection-complete
.®The screen form 
specification was 
successfully compiled 
appears when processing of 
the form is complete, then 
the FORM menu appears.
3f.Select Run
.®The RUN FORM 
window 
displays the table you 
selected.
3g.Press the   key....

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
Creating a Custom Data Table18-21
To design a report that uses data from the table, you must also enter the 
column names (database items) in the Dictionary: Database Item: 
Custom Items window.
CentreVu CMS does not automatically check the database for disk space 
used by data in custom tables. As a result, you can inadvertently fill up 
your disk with custom data. When this happens, you can lose or damage 
custom...

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
Modifying a Table18-22
Modifying a Table18
Use the following steps to add, change, or delete columns in an existing 
table.
Adding a Column 
to a Table
18
1.On the INFORMIX Main 
Menu, select Table
.®The Select Database 
screen appears.
2.Press the   key.®The TABLE 
menu appears.
3.Select Alter
.®The ALTER TABLE 
screen 
appears. A list of existing 
tables also appears.
4.Enter the name of the table 
you want to...

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
Modifying a Table18-23
Changing a 
Column
18
Deleting a 
Column
18
1.Select Modify 
to change 
a column.®The MODIFY NAME 
screen appears.
2.Use the arrow keys to select 
a field to change.
3.Press the   key when you 
have finished changing the 
column(s), and go to Step 3 
of “Deleting a Column
” in 
this section.®
The ALTER TABLE menu 
appears.Del
1.To delete a column, use the 
arrow keys to move the 
cursor to the...

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
Modifying a Table18-24
Changing Data in 
a Table
18
Use the following steps to add, change, or delete data in an existing 
table.
Adding Rows of 
Data to a Table
18
Changing Rows 
of Data in a Table
18
1.On the INFORMIX Main 
Menu, select Form
.®The FORM menu appears.
2.Select Run
.®The RUN FORM screen and 
a list of forms appear.
3.Enter the name of a form, 
and press  . ®The PERFORM menu 
appears.
Return
1.Select...

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
Modifying a Table18-25
Deleting Rows of 
Data From a 
Ta b l e
18
3.Select Update
, and press 
the   key.®The 
Update 
screen 
appears.
4.Use the arrow keys to move 
the cursor to the data you 
want to change. Overtype 
the data, and press  .®The 
PERFORM 
menu 
reappears. The message 
This row has been 
changed 
also appears.
Return
Esc
1.To delete a row of data, 
repeat Steps 1 and 2 of 
“Changing Rows of Data in 
a...

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
Modifying a Table18-26 

  Using the Report Designer - Examples CentreVu Report Designer Version 8 User Guide
General InformationA-1
A  Using the Report Designer - Examples
General Information0
This appendix provides step-by-step instructions on creating a commonly 
used report with Report Designer and step-by-step instructions on modifying 
an existing report. 
Creating a 
Integrated 
Report Using 
the 
Report 
Designer
0
This example shows how an integrated report that displays agent states is 
created using the Report...

  Using the Report Designer - Examples CentreVu Report Designer Version 8 User Guide
General InformationA-2
11. Select the Next button. The Query Assistant (Enter the start time for 
this integrated query.) window appears.
12. Select the Input Start Time radio button, and then select the Next 
button. The Query Assistant (Select the input used to indicate the 
split for this query.) window appears.
13. Select the Split/Skill input, and then select the Next button. The 
Query Assistant (Enter a name for...