Need Help in building DrillDown Reports.The datasource for my report is view which contains
sno FiledName Description
1. EmpBadge employe name,
2. EmpName employeename,
3. level employee level,
4. SupBadge supervisor badge,
5. SupName supervisor name,
6. Supervisor if'Y' this employee is Supervisor ,if 'N' there are no subordinates below him,
7. Director if 'Y' determines he is a Director,if 'N' then not a Director,
8. AttendancePercentage his attendance

Requirement:

The user enters a SupervisorBadge and we need to display all the employees who report to him,
and further if any of the employees reporting him is also a Supervisor then once he is clicked all the employees who report to him needs to be displayed ...this should be drilled down till the lowest level of employee(i.e to the employee who has no sub-ordinates to him)

eg: 26 level- 1
    1314 level- 2
        478 level- 3
        98 level- 3
               3879 level- 4
            4762 level- 4
    5678 level- 2
        932 level- 3
            6563 level- 4
                899 level- 5
    234 level- 2
    67 level- 2
        255 level- 3

Please help me , thanks in advance