Difference between revisions of "Setting Text Criteria – Logical Operators in a Report"
Julia Decker (talk | contribs) |
(→See Also) |
||
| (8 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | {{SeqReportPageHeader}} | ||
| + | |||
The first criteria you set will be logical criteria using exact matching. | The first criteria you set will be logical criteria using exact matching. | ||
| Line 13: | Line 15: | ||
3. Click in the '''Criteria''' column for the '''Last name''' field. | 3. Click in the '''Criteria''' column for the '''Last name''' field. | ||
| − | 4. Type '''= | + | 4. Type '''='Anderson''''. |
[[Image:Resp25.png]] | [[Image:Resp25.png]] | ||
| Line 33: | Line 35: | ||
9. '''Close''' the report. | 9. '''Close''' the report. | ||
| − | [[ | + | ==See Also== |
| + | * [[Report Builder Column Settings]] | ||
| + | * [[Using_Variables_in_the_Report_Builder#System_Variables|Using System Variables as Report Criteria]] | ||
| + | |||
| + | {{PrevNextStart}} [[Copying a Report]] | ||
| + | {{PrevNextMid}} [[Using Wildcard Criteria in Reports]] {{PrevNextEnd}} | ||
| + | |||
| + | |||
| + | [[Category:Reports]][[Category:Criteria]] | ||
Latest revision as of 13:17, 30 September 2013
Click here to watch a video on SmartSimple's integrated reporting subsystem.
The first criteria you set will be logical criteria using exact matching.
Before you attempt to use this type of criteria, you should review the logical operators tab in the Help panel of the Query builder window.
1. Click the Logical Operators tab.
The operators, descriptions, and examples are displayed.
2. Review the operators and examples.
3. Click in the Criteria column for the Last name field.
4. Type ='Anderson'.
Text values are enclosed in single quotes and in this example – an = sign is used to indicate the values, which must be equal to Anderson.
5. Click the Build Query button.
6. Click the Save button.
7. Click the Preview button.
8. Click the View Report button.
The one record matching the current criteria is displayed.
9. Close the report.
See Also
