Advanced Report Design
CentreVu CMS Custom Reports
Selecting Rows from More Than One Table
6-27
Figure 6-8: Report Design with Data from Two Tables Merged in a Field
04/19/95 00:30 AM
CentreVu(TM) CMS
Windows: 1 of 5 ^
Custom Reports: Hist: agent excepts
Split: $$$$$$$$$$$$$$$$$$$$
Split ACD
Date: $$$$$$$$
Calls
Field Window
Select: hagent.LOGID__________________________
______________________________________
Add highlights
Bar
Copy block
Define input
Erase block
Field
Get copy of design
Move block
Row search
Save design
Test design
Upper/left no-scroll
Variable/time/date
Time: $$$$$$$$$$
Percent
Agent ACD
of Split
Agent
Calls
Calls
0vvv
0vvvvv
2vvvvvvv
1xxxxx
Field Window
Select: 100*(hagent.ACDCALLS/hsplit.ACDCALLS)__
_______________________________________
Field Window
Select: hagent.ACDCALLS_______________________
______________________________________
Row Search Window
Row Search ID: 2
From table(s): hsplit, hagent
Select rows where: hsplit.SPLIT = $i_split and hsplit.ROW_DATE = $i_date
and hsplit.STARTTIME = $i_time and hsplit.ACD = $acd
and hsplit.SPLIT = hagent.SPLIT and hsplit.ROW_DATE =
hagent.ROW_DATE and hsplit.STARTTIME = hagent.STARTT
IME and hsplit.ACD = hagent.ACD
Field Window
Select: hagent.ACDCALLS_______________________
______________________________________
Summary of Contents for CentreVu
Page 16: ...Preface CentreVu CMS R3V5 Custom Reports Related Documents P 10 ...
Page 44: ...Getting Started CentreVu CMS Custom Reports Deleting a Custom Report 2 10 ...
Page 140: ...Completing Your Custom Report CentreVu CMS Custom Reports Running Custom Reports 5 22 ...
Page 178: ...Database Items and Calculations CentreVu CMS Custom Reports General Information A 2 ...
Page 188: ...Glossary CentreVu CMS Custom Reports GL 10 ...
Page 198: ......