Defining the Data for a Custom Report
CentreVu CMS Custom Reports
Defining the Rows of Data for a Report
4-49
Step 8: Select
a Sort Order
for Data
4
Enter a database item (with its table name) in the
Order by
field to specify
how multi-row data should be sequenced in the report.
CentreVu CMS
orders the rows of data by the values for the database item. For example,
you might enter
dsplit.ROW_DATE
in the
Order by
field.
CentreVu
CMS would then display data by date, as in the following report.
Figure 4-14: Sample of Data Ordered by Date in Ascending Order
If, on the other hand, you enter
dsplit.SPLIT
in the
Order by
field,
CentreVu CMS displays data by split, as shown in the following report.
Figure 4-15: Sample of Data Ordered by Split
DATE
SPLIT
ACDCALLS
10/10/92
1
40
10/10/92
2
36
10/10/92
3
30
10/11/92
1
25
10/11/92
2
50
10/11/92
3
41
10/12/92
1
7
10/12/92
2
6
10/12/92
3
5
DATE
SPLIT
ACDCALLS
10/10/92
1
40
10/11/92
1
25
10/12/92
1
7
10/10/92
2
36
10/11/92
2
50
10/12/92
2
6
10/10/92
3
30
10/11/92
3
41
10/12/92
3
5
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: ......