Home » Developer & Programmer » Reports & Discoverer » cascading prompt style LOV in report parameter form
cascading prompt style LOV in report parameter form [message #204930] Wed, 22 November 2006 11:54 Go to next message
srao
Messages: 9
Registered: March 2005
Junior Member
Hi

I am using report developer 10g on windows xp.

I need a cascading prompt style dynamic LOVs in my report parameter form.
The first LOV displays a set of values (say for eg. dept list). The second LOV will display another list, based on the value chosen by the user in the first LOV (Eg. List of employee names in that dept).

My first LOV select statement may look like below for the user parameter say P_DEPT

select deptno from dept;


My sencod LOV select stmnt may look like below for the user parameter P_EMP

select ename from emp where deptno = :P_DEPT

Each time I try to set the second LOV, report developer complains "Bind variables not allowed in select statement"

Same error msg comes if I reference the first user parameter(P_DEPT) as a lexical parmaeter.


How do I acheive the above in report parameter form? Any help is appreciated greatly...

Thanks
Suma

Re: cascading prompt style LOV in report parameter form [message #205373 is a reply to message #204930] Fri, 24 November 2006 06:48 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi

I am trying and as soon as I solve I will send you solution In the meantime you should also try ...

Bye
Ashu
Re: cascading prompt style LOV in report parameter form [message #205529 is a reply to message #205373] Sat, 25 November 2006 08:32 Go to previous message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi Suma,

It is better to create use forms as parameter form for report. since I think this flexibility is not with Reports.

You can use 'run product' utility for calling the report from form.

Hope this will help you.

Bye
Ashu
Previous Topic: How can I print the EAN 13 barcode with Oracle Report
Next Topic: problem in generating report to excel format
Goto Forum:
  


Current Time: Thu Dec 08 00:30:05 CST 2016

Total time taken to generate the page: 0.10864 seconds