I am having 2 parameters, first one is Employee group and second one is employee. If I select the employee group value I want the second parameter drop down to have Employees within the selected employee group. I set up the first parameter as EGroup@select GroupID from EmpGroup which works fine. Second parameter as Emp@Select EmployeeName from emp where GroupID = {?EGroup},   this is not working and the drop down does not populate any values. I am writing this report for SAP Business One application. Any guidance will be helpful.

Thank you Sastry. I don't know how to create dynamic cascading prompts etc. (new to the process). Would you be able to send me instructions on that? What I am doing is, I have a table valued function accepting 2 parameters. I created a Command in crystal reports and want to create 2 parameters and the second parameter should be based on the first parameter (my first post). I am developing these reports in Crystal reports 2008.