Point User Guide
389
Manipulating report output
To format a report:
1
With the report open in Point Report Viewer, select
Format
and select the item that
you want to change.
2
Modify the settings in the resulting dialog box and click
OK
.
Creating data filters
A data filter is used to “filter” out key items in a long report.
To filter data:
1
With the generated report open in Point Report Viewer format, select
Data > Filter
.
2
Select the column that contains the data to filter from the
Column Name
dropdown list.
The options are the columns in your report.
3
Skip the
And/Or
column for the first entry.
4
Define the operator (or “condition”) to use in the second column. Depending upon the
characteristic of the field (text, numeric, or date), the following operators are available:
5
Specify the value that the operator condition must meet in the
Value
field.
Enter
blank
to filter records with missing information.
6
To add additional filters, move the cursor to the first column of the second row and
select
And
or
Or
from the
And/Or
dropdown list to specify how the filter must meet the
criteria that was specified in the previous row; in addition to (And) or instead of (Or).
Operator
Definition
=
Equal to
Not =
or
<>
Not Equal to
>
Greater than
>=
Greater than or Equal to
<
Less than
<=
Less than or Equal to
Like
Begins with a letter or letter combination
Not like
Does not begin with a letter or letter combination
