Difference between revisions of "Specifying Multiple Criteria in Reports"

From SmartWiki
Jump to: navigation, search
Line 65: Line 65:
 
{{PrevNextStart}} [[Using Sounds Like Criteria in Reports]]
 
{{PrevNextStart}} [[Using Sounds Like Criteria in Reports]]
 
{{PrevNextMid}} [[Prompting for Criteria in Reports]] {{PrevNextEnd}}
 
{{PrevNextMid}} [[Prompting for Criteria in Reports]] {{PrevNextEnd}}
 +
 +
 +
 +
{{MultipleCriteriaVariableSyntax}}
  
  
 
[[Category:Reports]][[Category:Criteria]]
 
[[Category:Reports]][[Category:Criteria]]

Revision as of 13:18, 8 December 2014

caption 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.




Previous.png Using Sounds Like Criteria in Reports Prompting for Criteria in Reports Next.png


For reports containing multiple criteria, the variable syntax for the different criteria elements is argn where n is the order of the criteria defined in the Report Builder.

  • @argn.label@ returns the text label of the input
  • @argn@ returns the input field for the criteria
  • @argn.id@ returns the element ID of the input
Retrieved from ‘https://wiki.smartsimple.com/index.php?title=Specifying_Multiple_Criteria_in_Reports&oldid=23721’