OracleReports6i(Filtering User Defined Parameters)
Posted: Sun Feb 11, 2007 3:31 am
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.....
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.....