OraFAQ Forum: Reports & Discoverer » Dynamic Values in Parameter form

Home » Developer & Programmer » Reports & Discoverer » Dynamic Values in Parameter form (11g,Developer 2000,Report 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Dynamic Values in Parameter form [message #637841]

Wed, 27 May 2015 03:16

vippysharma
Messages: 73
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 ?

Report message to a moderator

Re: Dynamic Values in Parameter form [message #637843 is a reply to message #637841]

Wed, 27 May 2015 05:49

Littlefoot
Messages: 21781
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.

Report message to a moderator

Re: Dynamic Values in Parameter form [message #637845 is a reply to message #637843]

Wed, 27 May 2015 06:29

vippysharma
Messages: 73
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

Report message to a moderator

Previous Topic:	How to Set Report When Using Vertical Elasticity Variable and Horzintal Fixed
Next Topic:	Rep-52266 and Rep-50139

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 22 01:00:09 CDT 2023