Lucent Technologies CentreVu, User Manual

Page: 104 / 198

Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining the Rows of Data for a Report
4-46
Step 6: Select
a Field/Bar
Type
4
Enter an
x
to select one of the following field/bar types.
Discrete
Select the
Discrete
type if CentreVu CMS will find only one value for each
report field/bar to which you are assigning this Row Search ID.
CentreVu CMS will find only one value if the field/bar is an aggregate
function (SUM, AVG, MIN, or MAX), or if both of the following conditions are
true:
●
You enter a “where” statement that is so specific that CentreVu CMS
finds only one row.
●
On the Define Input window, you select
n
for Range/list for all variables
used in the “where” statement. For example, if you select the Daily Split
(
dsplit
) table and enter the following “where” statement:
Select rows where: ROW_DATE = $datevar and SPLIT =
$splitvar and ACD = $acd
and you select
n
for Range/list for both the
splitvar
and
datevar
variables, CentreVu CMS will find a single row containing the date and
split the user enters when ordering the report.
Repeated vertically
Select
Repeated vertically
to display a column of multiple field values
or a vertical series of bars, one for each value.
If you select
Repeated vertically
, you must also enter a number in the
Spacing
field. This number tells CentreVu CMS how many lines to go down
to display each value.
1
means to display a value on every line.
2
means
to display a value on every other line.
Repeated horizontally
Select
Repeated horizontally
to display multiple field values in row
format or a horizontal series of bars, one for each value.
Note
If you are assigning the row search ID only to fields and bars that
contain aggregate functions (sum, max, min, or avg), you will normally
select the
Discrete
type. See “ Repeating Aggregate Function
Values ” in Chapter 6 of this manual.