Defining the Data for a Custom Report
CentreVu CMS Custom Reports
Defining Bars in a Report
4-30
Step 2: Define
the Bar’s Data
Expression
4
Enter a data expression in the
Select
field to tell
CentreVu CMS two
things:
●
What table column(s) should supply data to the bar
●
How to manipulate that data.
The rules for this
Select
field are identical to those of the
Select
field
for the Field window. However, the following types of database items do not
make sense for bars:
●
Identifiers (for example,
SPLIT
,
VDN
,
LOGID
, and so on)
●
Current state data (for example,
WORKMODE
, or
DURATION
)
●
Constants (unless they are part of a calculation).
Also, if a bar’s expression is a database item that stores a number of
seconds, the bar normally shows time as seconds. However, you can make
the bar represent minutes by dividing the database item by 60.
In addition, to complete your definition of bar data, you must, as for field data,
define row search conditions for the bar(s). This includes whether a bar you
define will be repeated to display multiple bars for multiple values. See the
“
Defining the Rows of Data for a Report
” section in this chapter.
Step 3: Define
the Table(s) for
Calculation
Names
4
Enter a table name in the
Table for calculations
field only if you
entered a calculation name in the
Select
field. The table name tells
CentreVu CMS in what table to look for the database items in the calculation.
Step 4: Define
the Bar
Direction
4
Enter an
x
in the
Bar direction
list to select either a horizontal or
vertical format for the bar.
Vertical
means the bar’s length is oriented up
and down.
Horizontal
means the bar’s length is oriented left and right.
Note
The
Table for calculations
field is necessary when using
calculation names because you cannot append a table name to a
calculation name in the
Select
field.
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: ......