OraFAQ Forum: Reports & Discoverer » Feeding parameter to another parameter select

Home » Developer & Programmer » Reports & Discoverer » Feeding parameter to another parameter select

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

Feeding parameter to another parameter select [message #90178]

Sun, 28 November 2004 23:38

Nidhi Jain
Messages: 1
Registered: November 2004

Junior Member

Hi..

In Reports�6 want to use the result of one parameter to define which<I class=quotelev1> values can be selected for a second paramter. On my first parameter (A1)[/i]
<I class=quotelev1>I say that the LOV values are:[/i]Select deptCode from dept
In my second parameter they should be :Select empcode from emp where deptcode = :A1.

When I do this I get an error Bad Bind Variable.

I want to do it without using my front end as forms.Is there a way to do it in reports?If yes please tell the steps in details as I am new to reports.

Thanks and Regards

Nidhi Jain

Report message to a moderator

Previous Topic:	srw.message
Next Topic:	Joins in Discoverer Desktop

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 01 23:39:52 CDT 2024