There was a Report Data Filtering function in our system which many people unaware of. Let's take a tour on this function;

Let use the Payroll Detail as an example;

Step 1, 2 & 3: Firstly, go to the Payroll -> Standard Report -> Payroll Detail Report

Step 4: Click on the "More Setting" button

Step 5: Then the Smart Filter bar appear, click on the "Data Highlight/Filter" button

Step 6: Click the drop down bar to choose the condition field desired

Step 7: click "Add" to apply the condition field.

Step 8: Select a type of field to filter the condition.

Step 9: At the selection bar, select "Filter" then select the employee list by all the employee number "Containing" the number "001"

Step 10: Click "Generate" to generate the report.

All the employee number "Containing" the number "001" will be listed

Now try on another Data Filtering method;

Step 11: Go back and select "Highlight" then select the "Color"

Step 12: Do the same as select all the employee number "Containing" the number "001"

Step 13: Lastly, click on the "Generate" button to generate the report again

All the employee will be listed but only those who contain the number "001" will be highlighted with the color chosen

The difference between Filter and Highlight is that;

The filter is to list down only the list who containing the argument

Highlight is to list down all the list but HIGHLIGHT the selected argument