Difference between revisions of "Specifying Multiple Criteria in Reports"
From SmartWiki
(→Or Between Rows) |
|||
| (10 intermediate revisions by 2 users not shown) | |||
| Line 7: | Line 7: | ||
If the criteria is for a different field, then you enter the criteria under that field. The system will imply an '''AND''' between the columns. For example: | If the criteria is for a different field, then you enter the criteria under that field. The system will imply an '''AND''' between the columns. For example: | ||
| − | {| | + | {| class="wikitable" |
|+ | |+ | ||
!Field!!Title!!Last Name | !Field!!Title!!Last Name | ||
| Line 17: | Line 17: | ||
* Select the records where the title is equal to President '''AND''' the Last Name begins with '''A'''. | * Select the records where the title is equal to President '''AND''' the Last Name begins with '''A'''. | ||
| − | {| | + | {| class="wikitable" |
|+ | |+ | ||
!Field!!Title!!Last Name!!First Name | !Field!!Title!!Last Name!!First Name | ||
| Line 30: | Line 30: | ||
If you enter a second set of criteria for the same field in a second criteria row, the system will use an '''OR''' to select the records. For example: | If you enter a second set of criteria for the same field in a second criteria row, the system will use an '''OR''' to select the records. For example: | ||
| − | {| | + | {| class="wikitable" |
|+ | |+ | ||
!Field!!Title | !Field!!Title | ||
| Line 41: | Line 41: | ||
* Select all the records where the title is equal to President '''OR''' starting with the letters '''VP'''. | * Select all the records where the title is equal to President '''OR''' starting with the letters '''VP'''. | ||
| − | {| | + | {| class="wikitable" |
|+ | |+ | ||
!Field!!Title!!Last Name | !Field!!Title!!Last Name | ||
| Line 50: | Line 50: | ||
|} | |} | ||
| − | * Select all the records where the title is equal to President ''' | + | * Select all the records where the title is equal to President '''AND''' where the last name starts with '''A''', '''OR''' any last name, with a title starting with the letters 'VP'. |
| − | + | {| class="wikitable" | |
| + | |+ | ||
| + | !Field!!Title!!Last Name | ||
| + | |+ | ||
| + | |Criteria||='President'||Like 'A%' | ||
| + | |+ | ||
| + | |OR||Like 'VP%'||Like 'A%' | ||
| + | |} | ||
* Select all the records where the title is equal to President '''OR''' any title starting with the letters VP '''AND''' Last Name beginning with '''A'''. | * Select all the records where the title is equal to President '''OR''' any title starting with the letters VP '''AND''' Last Name beginning with '''A'''. | ||
| + | |||
{{PrevNextStart}} [[Using Sounds Like Criteria in Reports]] | {{PrevNextStart}} [[Using Sounds Like Criteria in Reports]] | ||
| − | {{PrevNextMid}} [[Prompting for Criteria in Reports]] | + | {{PrevNextMid}} [[Prompting for Criteria in Reports]] {{PrevNextEnd}} |
| − | {{PrevNextEnd}} | ||
| − | |||
| − | [[Category:Reports]] | + | [[Category:Reports]][[Category:Criteria]] |
Latest revision as of 09:38, 15 January 2016
Click here to watch a video on SmartSimple's integrated reporting subsystem.
Before you start to use multiple selection criteria it is vital that you understand how the Report Builder will interpret the criteria. Mistakes in the construction of criteria are one of the biggest sources of confusion on ALL reporting tools.
Implied AND between Columns
If the criteria is for a different field, then you enter the criteria under that field. The system will imply an AND between the columns. For example:
| Field | Title | Last Name | Criteria | ='President' | Like 'A%' |
|---|
- Select the records where the title is equal to President AND the Last Name begins with A.
| Field | Title | Last Name | First Name | Criteria | ='President' | Like 'A%' | Like 'A%' |
|---|
- Select the records where the title is equal to President AND the Last Name begins with A AND the First name begins with A.
Or Between Rows
If you enter a second set of criteria for the same field in a second criteria row, the system will use an OR to select the records. For example:
| Field | Title | Criteria | ='President' | OR | Like 'VP%' |
|---|
- Select all the records where the title is equal to President OR starting with the letters VP.
| Field | Title | Last Name | Criteria | ='President' | Like 'A%' | OR | Like 'VP%' |
|---|
- Select all the records where the title is equal to President AND where the last name starts with A, OR any last name, with a title starting with the letters 'VP'.
| Field | Title | Last Name | Criteria | ='President' | Like 'A%' | OR | Like 'VP%' | Like 'A%' |
|---|
- Select all the records where the title is equal to President OR any title starting with the letters VP AND Last Name beginning with A.
