Difference between revisions of "Setting Text Criteria – Logical Operators in a Report"
(→See Also) |
|||
(2 intermediate revisions by the same user not shown) | |||
Line 15: | 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 37: | Line 37: | ||
==See Also== | ==See Also== | ||
* [[Report Builder Column Settings]] | * [[Report Builder Column Settings]] | ||
+ | * [[Using_Variables_in_the_Report_Builder#System_Variables|Using System Variables as Report Criteria]] | ||
{{PrevNextStart}} [[Copying a Report]] | {{PrevNextStart}} [[Copying a Report]] | ||
− | {{PrevNextMid}} [[Using Wildcard Criteria in Reports]] | + | {{PrevNextMid}} [[Using Wildcard Criteria in Reports]] {{PrevNextEnd}} |
− | {{PrevNextEnd}} | ||
[[Category:Reports]][[Category:Criteria]] | [[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