You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

This grid panel is used to specify the filter criteria that records retrieved from the database must meet to be included in the Report Viewer.

 

How to use the Report Filter panel:

  1. Field Name - This is a combo box type field that allows you to select the field name from the list. The database will be filtered using this Field Name, the Condition, and From and To value.
  2. Condition - This is used to set the range of values for inclusion in the report. The conditions displayed on the combo box list will depend on the Field List Manager setup.
    1. Equal To - The From field is enabled while the To field is disabled. As the condition denote, the report will include value that match and is equal to the entered From value.
    2. Not Equal To - The From field is enabled while the To field is disabled. As the condition denote, the report will include value that does not match and is not equal to the entered From value.
    3. Greater Than - The From field is enabled while the To field is disabled. As the condition denote, the report will include value that is greater than the entered From value.
    4. Greater Than or Equal - The From field is enabled while the To field is disabled. As the condition denote, the report will include value that is equal to as well as those greater than the entered From value.
    5. Less Than - The From field is enabled while the To field is disabled. As the condition denote, the report will include value that is less than the entered From value.
    6. Less Than or Equal - The From field is enabled while the To field is disabled. As the condition denote, the report will include value that is equal to as well as those less than the entered From value.
    7. Between - The From and To fields are enabled. As the condition denote, the report will include the data entered From and To value, inclusing
  3. From - Enter the beginning value of the range for inclusion in the report.
  4. To - Enter the ending value of the range for inclusion in the report. This field will be disabled depending on the Condition used.
  5. Join - Used to combine two filters.
    1. And - Used this if you want the report to include values that satisfy all the given conditions/filters.

    2. Or - Use this if you want the report to include values that satisfy any of the given conditions/filters.

 

  • No labels