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