Home » Developer & Programmer » Reports & Discoverer » Feeding parameter to another parameter select
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
Previous Topic: srw.message
Next Topic: Joins in Discoverer Desktop
Goto Forum:
  


Current Time: Wed Feb 21 19:40:03 CST 2024