Defining the rows of data for a report
Issue 3.0 May 2002
97
Select a field/bar type
From the Row Search window, in the
Field/var type:
field enter
x
to select
Discrete
.
Select the
Discrete
type if CMS will find only one value for each report field/bar to
which you are assigning this Row Search ID. 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 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,
CMS will find a single row containing the date and split the user enters when ordering
the report.
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
on page 158.
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 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.
Note:
If you select
Repeated vertically
, you cannot define any fields directly
under a repeated field.
Repeated horizontally – Select
Repeated horizontally
to display multiple field
values in row format or a horizontal series of bars, one for each value.
If you select
Repeated horizontally
, you must also enter a number in the
Spacing
field. This number tells CMS how many characters to move horizontally from the beginning
of one value to the beginning of the next. This means that the spacing you enter must
include the blank spaces between fields/bars and the width of a field/bar. For example, if a
field/bar is four characters wide and you enter
8
in the Spacing field, CMS displays each
value with four blank characters in between.
