Selection Criteria for Reports
When entering values for selection criteria, a single or combination of values may be entered. Enter a single item, a list of individual items (separated by commas), or a range of items (joined by a dash " - ").
The Universal Match Symbol "@" may be used in two manners:
- If the "@" precedes an actual value, the "@" implies any character in that position (e.g., @2).
- If the "@" appears at the end of an entered value, the "@" implies any character in that and succeeding positions (e.g., 2@).
The following examples illustrate the various combinations.
Selection Criteria | Results |
|---|---|
TEMP001 | Character-for-character match (TEMP001 only) |
TEMP001@ | Every entry that starts with the partial value entered (TEMP001, TEMP0011, TEMP0012, etc.) |
T@,W-Z@ | Entries that begin with the partial value entered, plus entries within the specified range of partial values (all entries that begin with T, W, X, Y, or Z) |
T-Z | Entries that fall within the specified range (all entries that begin with a T, U, V, W, X, Y, and if Z, by itself, exists as an entry) |
T-Z@ | Entries that fall within the specified range (all entries that begin with a T, U, V, W, X, Y, or Z) |
W-Z | Entries that fall within the specified range, except for the criteria after the exclude statement (all entries that begin with a W, X, or Z) |
@ | Entries with a "2" in the third position (102345, AB2, AB2CD, etc.) |
exA-B | All entries except those beginning with A, B, or W. |
When selecting a value that contains a comma or dash, that value must be enclosed in quotation marks ("). E.g., "Smith, Ann" or "A-B Enterprises, Inc."