Hi all,
I need to define a report based on two input parameters from the user. I defined these two parameters as enumerated lists, so both will show a drop down based on LOV. The issue is that I need the second parameter to show values, based on the first parameter selection.
For example, let's assume the first parameter is a department and the second parameter is employees - I need the the drop down for the employees will only show employee that are part of the department which the user choose (department_id field is part of the employees table). I've tried a lot of combinations but no one seems to work, and I'm getting in the second list all the values in DB, regardless of the department id. Can someone explain how should the SQL statement look like, as well as the enumerated lists (and whatever is needed) so I will be able to get the required list only? I've follows the samples but still couldn't find a solution.

Thanks in advance