Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

enabled disabled report entered From value enabled disabled report entered From value equals 'Petty Cash' report equal to the entered From Equal To does not equal 'Petty Cash' report equal to the entered From value
ConditionExampleFrom/ To fieldDescription
LikeContainsAccount Description Like Contains 'Cash on Hand'From field is enableddisplayed. To field is disabledhidden.The report system will search and show the data containing the entered From valuekeyword.
EqualsAccount Description equals 'Petty Cash'From field is displayed. To field is hidden.The system will search and show the data equal to the keyword.
Not LikeEqual ToAccount Description Not Like does not equal 'Petty Cash on Hand'From field is enableddisplayed. To field is disabledhidden.The report system will search and show the data not containing the entered From valuethat is not equal to keyword.
Starts WithAccount Description Starts With 'Cash on Hand'From field is displayed. To field is hidden.The system will search and show the data that starts with the keyword.
Ends WithAccount Description Ends With 'Greenfield Admin'From field is displayed. To field is hidden.The system will search and show the data that ends with the keyword.Equal To
BlankAccount Description is blankFrom field is enableddisplayed but disabled. To field is disabledhidden.The system will search and show the data with empty string or null value.
Not BlankAccount Description is not blankFrom field is enableddisplayed but disabled. To field is disabledhidden.The system will search and show the data that is not empty string or null.
Greater ThanEnding Balance Greater Than '100'From field is enableddisplayed. To field is disabledhidden.The report system will search and show the data that is greater than the entered From value keyword.
Greater Less Than or EqualEnding Balance Greater Less Than or Equal to '100'From field is enableddisplayed. To field is disabledhidden.The report system will search and show the data that is greater less than or equal to the entered From valuethe keyword.Less Than
BeforeDate Posted Before '01/01/2014Ending Balance Less Than '100'From field is enableddisplayed. To field is disabledhidden.The report Used for a Date field. The system will search and show the data that is less than the entered From value.Less Than or Equalbefore the keyword (in this sample, date from 12/31/2013 and below)
AfterDate Posted After '01/01/2014Ending Balance Less Than or Equal to '100'From field is enableddisplayed. To field is disabledhidden.The report Used for a Date field. The system will search and show the data that is less than or equal to the entered From value.is after the keyword (in this sample, date from 01/02/2014 and above)
TodayDate Posted Today (where today is the current system date)From field is displayed. To field is hidden.Used for a Date field. The system will search and show the data with the date equal to the current system date.
YesterdayDate Posted YesterdayFrom field is displayed. To field is hidden.Used for a Date field. The system will search and show the data with the date yesterday taking the current system date as the point of comparison, e.g. if today is 09/15/2014 so yesterday is 09/14/2014
Last WeekDate Posted Last WeekFrom and To fields are displayedUsed for a Date field. The system will search and show the data with the date yesterday taking the current system date as the point of comparison, e.g. if today is 09/15/2014 so yesterday is 09/14/2014
Last 30 Days   
Last Month   
Last Quarter   
Last Year   
This Week   
This Month   
This Quarter   
This Year   
BetweenEnding Balance Between '1' to '100'From and To fields are enabled.The report system will search and show the data starting with From value the first keyword up to the To valuelast keyword.