Report Parameters – Include All

 Problem:

Not able to include All employees while using parameters..

For eg:

List of parameters below:

1. Department
2. Business_Unit
3. Employee_Group

Selecting ‘All’ for all parameters doesn’t return all employees as some of them doesn’t have employee group in their assignment.

Solution:

In the parameters section, choose to return 'NULL' when selecting all parameters.

SQL Condition as below:

…
AND NVL(bu.name,paaf.assignment_id) in COALESCE(:Business_Unit,paaf.assignment_id)
AND NVL(dep.name paaf.assignment_id) in COALESCE(:Department,paaf.assignment_id)
AND NVL(paaf.attribute1,paaf.assignment_id) in COALESCE(:Employee_Group,paaf.assignment_id)