2 Replies Latest reply: Aug 13, 2013 9:50 AM by pawan kumaar RSS

    How to Perform a Dynamic Action on Item

    pawan kumaar

      Hi,

       

      In Parametrized Report i want to filter my item value based on previous item

      Actually i am having 3 parameters based on that report output will be generated

       

      1 ..Employee name ...text item

      2 ..Department name ....select list type(LOV)

      3 ..Manager name .....select list type(LOV)

       

      Based on employee name the department name should  be displayed... what approach is suitable for this

      ie by creating process in page rendering

      or by creating dynamic action in page rendering

       

      I used the Below Queries

       

      1....report query:

      select oe.employee_id,

      oe.first_name||' '||oe.last_name as "EMPLOYEE NAME",

      oe.email,

      oe.phone_number,

      oe.hire_date,

      oj.job_title,

      oe.salary,

      od.department_name,

      (select oee.first_name||' '||oee.last_name from OEHR_EMPLOYEES oee where oee.employee_id(+)=oe.manager_id) as "MANAGER NAME"

      from OEHR_EMPLOYEES oe,

      OEHR_JOBS oj,

      OEHR_DEPARTMENTS od

      where oe.job_id=oj.job_id

      and oe.department_id(+)=od.department_id

      and oe.first_name||' '||oe.last_name=nvl(:P1_EMPNAME,oe.first_name||' '||oe.last_name)

      and oe.department_id=nvl(:P1_DEPTID,oe.department_id)

      and oe.manager_id=nvl(:P1_MGRID,oe.manager_id)

      order by 1

       

      2...Department name ....select list type(LOV)  query

      select distinct od.department_name d,od.department_id r 

      from OEHR_departments od,oehr_employees oe

      where oe.department_id(+)=od.department_id

      and oe.first_name||' '||oe.last_name = nvl(:P1_EMPNAME,oe.first_name||' '||oe.last_name)

      order by 1

       

      3....Manager name .....select list type(LOV) query

      SELECT distinct oe.first_name||' '||oe.last_name d,oee.manager_id r

      FROM oehr_employees oe ,oehr_employees oee

      WHERE oe.employee_id = oee.manager_id

      and  oee.department_id = nvl(:P1_DEPTID,oee.department_id)

      and oee.first_name||' '||oee.last_name = nvl(:P1_EMPNAME,oee.first_name||' '||oee.last_name)

      order by 1

       

       

       

      Regards,

      Pavan