Re: Reports 3.0 question

Maybe you can use a lexical reference ("&<parameter>" to the Company parameter in the WHERE-clause of your SELECT stmt in the LOV of the Employee parameter. Provided that a default value is set for the Company, your LOV should be stripped to the company's employees.
If it does not work just after changing the company parameter, you could also let the change of the parameter's value take effect in an AFTER PARAMETER FORM Trigger, which will show the parameter form once again, if you return FALSE in the Trigger.
But the second possibility is more complicated and it's usability is quite low. I hope this will help you, best wishes,

Günther

Ken Halsted wrote:

> Does anyone know how I can use the value of a parameter on a Parameter form
> as the selection criteria for another parameter on the same form.
>
> For example, I have a Company selection parameter and an Employee Selection
> parameter. I want to pull the Employee Numbers of only the Employees within
> that Company. The user chooses the company first, and then the employee
> number.
>
> Is this possible using Reports or will I have to use a Form instead. I
> can't seem to get Bind variables to work in Select statements of other
> parameters.
>
> Thanks,
>
> Ken.
>
> --
> _________________
> Kenneth W. Halsted
> Mountaire Corporation
> ph: (501) 399-8812
> url: http://www.mountaire.com
> email: kenman_at_mail.snider.net
Received on Thu Apr 15 1999 - 12:18:07 CEST