Home » Developer & Programmer » Reports & Discoverer » Dynamic Values in Parameter form (11g,Developer 2000,Report 6i)
Dynamic Values in Parameter form [message #637841] Wed, 27 May 2015 03:16 Go to next message
vippysharma
Messages: 61
Registered: May 2013
Location: www
Member
I have a Report having two parameters (Dept_id and Emp).
During Execution of Report, if user select particular Dept_id then following parameter (emp) should show only that emp having that selected dept_id. (Kind of Dynamic behavior)

Any Solution ?
Re: Dynamic Values in Parameter form [message #637843 is a reply to message #637841] Wed, 27 May 2015 05:49 Go to previous messageGo to next message
Littlefoot
Messages: 21610
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You are looking for cascading list of values. As bind variables aren't allowed in report's LoV select statement, which means that you can't do something like
select empno, ename
from emp
where deptno = :par_deptno  --> PAR_DEPTNO is the first parameter, used to select a department
you'll have do that elsewhere, such as Oracle Forms or Apex. Shortly: create two LoV items where EMP information depends on previously selected DEPT as suggested in the above SELECT statement.
Re: Dynamic Values in Parameter form [message #637845 is a reply to message #637843] Wed, 27 May 2015 06:29 Go to previous message
vippysharma
Messages: 61
Registered: May 2013
Location: www
Member
I did that through form already. But just post here to know is that same possible in reports or not. But anyways, Thanks. Smile
Previous Topic: How to Set Report When Using Vertical Elasticity Variable and Horzintal Fixed
Next Topic: Rep-52266 and Rep-50139
Goto Forum:
  


Current Time: Thu Oct 22 01:57:04 CDT 2020