Lucent Technologies CentreVu, User Manual

Page: 105 / 198

Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining the Rows of Data for a Report
4-47
If you select
Repeated horizontally
, you must also enter a number in
the
Spacing
field. This number tells
CentreVu 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,
CentreVu CMS
displays each value with four blank characters in between.
Repeated values, whether repeated horizontally or vertically, apply only if
CentreVu CMS finds multiple values for the report field(s). CentreVu 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, CentreVu 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,
CentreVu CMS
finds multiple values, but you select
Discrete
, the report displays only the
first value CentreVu CMS finds for each report field.
Note
If you select
Repeated vertically
, you cannot define any fields
directly under a repeated field. If you select
Repeated
horizontally
, you cannot define any fields directly to the right of a
repeated field.