Page 1 of 1

OracleReports6i(Filtering User Defined Parameters)

Posted: Sun Feb 11, 2007 3:31 am
by 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.....

Posted: Sun Feb 11, 2007 9:14 am
by 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

Posted: Mon Feb 12, 2007 4:46 am
by 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.