OracleReports6i(Filtering User Defined Parameters)

[yphakatkar]

Hi Friends,
I have one query regarding Oracle Reports6i. I have created one report based on EMP table. I have created 2 user parameters named Deptno & Empno. Now I want to filter the list of Empno to the selected Deptno only.
For e.g. I select Deptno 30 from the report runtime parameter form, now I want to see only those employees in the list of Empno parameter, which belongs to department 30.
If possible please present one demonstration on the same.
Thanks.....

[admin]

Dear instead of using Reports runtime parameter form create a Form and apply your conditions there and call report by passing parameters to the report. thanks

[yphakatkar]

Hi !! Thanks for your reply. Actually I have already implemented this schenario but I thought there must be a way to implement this query in reports only without taking help of forms.