Defining the data for a custom report
88 Avaya CMS Custom Reports
Changing a bar definition
To change a bar definition:
1. On Screen Painter, place the cursor on the bar you want to change, and select
Bar
.
The cursor returns to the bar and rests on the lower right corner of the bar. The
following message is displayed on Screen Painter status line:
Move cursor to
define opposite corner of bar and press RETURN.
2. If needed, move the cursor using the arrow keys to either make the bar bigger or
smaller, and press
Return
.
The Bar window is displayed.
3. Overtype any data in fields you want to change, and select
Save.
The Bar window closes,
Successful
is displayed in Screen Painter status line, and
the cursor returns to the bar you just changed.
Defining the rows of data for a report
To complete the definition of a report’s fields/bars, you must define the rows of the tables
that supply data to the fields/bars. To do this:
●
Using the Row Search window (see the following figure), define the criteria needed
to find the appropriate rows of data. Each set of criteria is stored by row search ID.
●
Assign the row search IDs to the appropriate fields/bars.
Row search criteria are values for either database items or calculations. In most cases,
your criteria will specify variable names rather than specific values for the database items
or calculations. These variable names allow CMS to use the values entered in the Report
Input window in its row search criteria. From the rows CMS finds, report data is retrieved
for the report fields. See
How CMS stores and retrieves data
on page 19.
Note:
If you copy the design of an existing report, the row search criteria and input
fields (as defined in the Define Input window) are copied. If you then delete
or change a variable name in the Row Search window, you must delete or
change that variable name in the Define Input window.
To define the rows of data for a report, perform the following tasks in the order indicated:
1.
Access the Row Search window
on page 89
2.
List the Report Input Variables
on page 90
3.
Select a Row Search ID
on page 90
