5 Filtering GroupsEnglishالعربيةfrançaisTagalogहिन्दी

Filtering Groups

Can you apply filters to the groups you have created?

Filtering and Sorting within a list or report is a valuable tool for finding a specific entry into the report. Filtering relates to the ability to streamline what is shown in a report and only show on the screen the information that is required. Sorting refers to the ability to have the information in the columns appear in the ascending or descending order as required.

• To Filter and Sort within a list or report
• Open any list and Position the Curser over the field and data that you want to search on. Eg. To filter Sales History by an Employee Position the curser over that Employees Name in the Name Column Right Click with the mouse

You will now have the following options

• Custom Filter List - This is a list of filters that you have previously saved
• AND Filter - Select this to add the field (name) that you have selected into a filter
• Right Click again and selectPreview -  You will now see that your list has been reduced to only those entries that match the filter.
• For the above example that will be Sales History for the Employee selected.
• You can Add Multiple selections to a filter by repeating the same process.
• In the above example you may now want to filter by Department name.
• Right Click the Department name you want included and select AND Filter again, then Right Click and preview.
• The Filter you have created will show at the bottom of the screen and will look something like [[Lastname]= 'Smith'] AND [[ClassName] = 'Burleigh']
• Alternatively you may want all departments Except One. In this case use the same process but select AND EXCLUDE Filter
• OR Filter
• To select Two Departments you could also use OR Filter for each department selection

If you are happy with the filter you have created and want to reuse the exact same filter in the future you can Save the filter in your Custom Filters List.

• Right Click the report again and select ADD Custom Filter
• The Custom Filter window will pop up so that you can give it a name. You can also edit the SQL String directly in this window
• You can recall a Custom Filter by opening the list to which it relates and selecting the desired filter by name from the drop down list in the Custom Filters field