382
Calyx Software
Reports
ii
To add additional filter criteria, select
AND
or
OR
from the
And
dropdown list to
specify how this condition must meet the criteria that was specified in the
previous condition; in addition to (
AND
) or instead of (
OR
).
iii
When all the conditions are specified for a field, click
OK
to return to the report
template.
iv
To enable filtering for the corresponding field at the time the report is
generated, select the
Include in the Addition Filter List on the Report
Generation Screen
check box. Selecting this option adds the field to the
Additional Filters on the
Generate Report
screen where additional filter
criteria can be specified.
c
Select or deselect the check box in the
Show
column to specify whether the
corresponding field is to be shown in the report.
d
In the
Total
field, select one of the options to include a
Total
,
Average
, or
Count
of
the entries at the bottom of the corresponding column in the report.
e
Select the format of the data from the
Format
field. Auto is the default if no other
options are available.
f
Specify the width of the column in the
Width
field.
7
Repeat
Step 6
for all fields that are to be included in the report.
Greater than or Equal
to
The value in the corresponding field is greater than or equal to the
value that is specified in the
Text
Value
1
field.
Less than
The value in the corresponding field is less than the value that is
specified in the
Text
Value
1
field.
Less than or equal to
The value in the corresponding field is less than or equal to the value
that is specified in the
Text
Value
1
field.
Between
The value in the corresponding field is between the values that are
specified in the
Text
Value
1
and
Text
Value
2
fields.
Date conditions
The following date conditions are available when a date field is
selected:
•
Today
•
Last # days
•
Next # days
•
This month
•
Last month
•
Next month
•
This year
•
Last year
Select an option and enter the appropriate value in the
Text
Value
1
field.
Related information
•
For more information about methods to determine field IDs, refer to
Chapter 22,
Combined field IDs
, and
Identifying fields and field IDs
,
on page 65.
•
For more information about using the Condition Builder, see the
Knowledge Base article
#0453 Using the Condition Builder to
generate reports
.
Condition
Definition
