Calyx Point 7 - Page 400

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