Defining the Data for a Custom Report
CentreVu CMS Custom Reports
Defining the Rows of Data for a Report
4-50
If you leave the
Order by
field blank,
CentreVu CMS displays data in the
report using the same sequence
CentreVu CMS uses to store the data in the
table.
For historical reports only, you can enter more than one database item in
the
Order by
field. The database items must be separated by commas.
The effect of more than one sorting database item is that data will be ordered
first by values found for the first sorting database item, then sorted by values
for the second sorting database item, and so on.
For example,
Order by: dsplit.SPLIT,dsplit.ACDCALLS
would
cause the data shown in the previous illustration to be ordered as follows:
Figure 4-16: Sample of Data Ordered by Split and ACD Calls
Notice that the data is first sorted by split number, then by the number of
ACD calls. As a result, the dates appear totally out of sequence.
DATE
SPLIT
ACDCALLS
10/12/92
1
7
10/11/92
1
25
10/10/92
1
40
10/12/92
2
6
10/11/92
2
36
10/10/92
2
50
10/12/92
3
5
10/11/92
3
30
10/10/92
3
41
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: ......