Defining the data for a custom report
98 Avaya CMS Custom Reports
Repeated values, whether repeated horizontally or vertically, apply only if CMS finds
multiple values for the report fields. CMS finds multiple values if one of the following
conditions exists:
●
Your “where” statement specifies one or more ranges of values.
●
On the Define Input window, you entered
y
for Range/list for at least one variable.
●
Your “where” statement is general enough to select multiple rows.
One example of a general “where” statement for the
dsplit
table would be:
Select rows where: ROW_DATE = $datevar and ACD = $acd
Since no split values are specified, CMS will display, for a user-specified date, a value
for every split in the ACD.
If, based on your “where” statement and Define Input entries, CMS finds multiple values,
but you select
Discrete
, the report displays only the first value CMS finds for each report
field.
Note:
If you select
Repeated horizontally
, you cannot define any fields
directly to the right of a repeated field.
Select a Sort type
From the Row Search window, in the
Sort type:
field, enter
x
to select either ascending
or descending order for values of the database items. Ascending order means CMS
displays data from the lowest to the highest values. Descending order means CMS
displays data from the highest to the lowest values.
Continuing with the previous example, if the
Order by
database item is
ROW_DATE
and
you choose a descending order, the data will be listed as shown in the table below. For
dates and times, lowest values are those dates/times farthest in the past.
Sample of data ordered by date in descending order
DATE
SPLIT
ACDCALLS
10/12/99
1
7
10/12/99
2
6
10/12/99
3
5
10/11/99
1
25
10/11/99
2
50
10/11/99
3
41
10/10/99
1
40
10/10/99
2
36
10/10/99
3
30