Defining the Data for a Custom Report
CentreVu CMS Custom Reports
Defining Fields for the Report Input Window
4-3
You cannot
List all
or
Find one
in the Define Input window by
searching on multiple fields. For a
Find one
search,
CentreVu CMS uses
only the entry in the
Variable name
field.
CentreVu CMS ignores the
other fields.
For a
List all
search,
CentreVu CMS ignores all fields.
shows an example of how the report input fields are linked to a
report’s search conditions.
Figure 4-3: How a Variable Links the Report Input and Row Search
In the example, the user enters a split number of 1, a date of 07/01/93, and
intrahour intervals from 8:00 a.m. to 11:00 a.m.
CentreVu CMS identifies 1 as
the value for variable name
i_split
, 07/01/93 as the value for variable
name
i_date
, and 8:00 a.m. to 11:00 a.m. as the values for variable name
i_time
.
CentreVu CMS then searches the specified database items
(
SPLIT
,
ROW_DATE
, and
STARTTIME
) in the Intrahour Agent (
hagent
)
table for rows that have those values. Finally,
CentreVu CMS extracts data
from those rows and displays the data in the report’s fields.
Variable name: i_split
Prompt: Split
Variable name: i_date
Prompt: Date
Variable name: i_time
Prompt: Interval(s)
Define Input
Windows
Report Input
Windows
Row Search
Window
Row search ID: 1
From table(s): hagent___________________________
Select rows where: SPLIT = $i_split and ROW_DATE = $i_date
and STARTTIME = $i_time and ACD = $acd
1
07/01/93
8:00am-11:00am
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: ......