Re: Reports 3.0 Feeding parameter to another parameter select
From: Paul Dorsey <pdorsey_at_dulcian.com>
Date: Mon, 07 Feb 2000 11:54:27 GMT
Message-ID: <Tnyn4.2577$pN1.37135_at_news1.rdc1.nj.home.com>
Date: Mon, 07 Feb 2000 11:54:27 GMT
Message-ID: <Tnyn4.2577$pN1.37135_at_news1.rdc1.nj.home.com>
Your only alternative is to build your front end in Forms. The Reports parameter form has only limited functionality.
-- Paul Dorsey Dulcian, Inc. (212) 595-7223 web address: http://www.dulcian.com email: pdorsey_at_dulcian.com Matt Foster <matt.foster_at_ed.ac.uk> wrote in message news:389B0FD2.C72A5146_at_ed.ac.uk...Received on Mon Feb 07 2000 - 12:54:27 CET
> Hi,
>
> In Reports 3 I want to use the result of one parameter to define which
> values can be selected for a second paramter. On my first parameter (A1)
> I say that the LOV values are
>
> SELECT system_key
> FROM table1
>
> and on my second parameter (A2) I would like to say LOV values are
>
> SELECT system_key
> FROM table2
> WHERE table1_key = :A1
>
> but I get a message saying REP-0781 Bind variables are not allowed in
> the select statement.
>
> Is there another way to get round this?
>
> Thanks in advance,
>
> Matt Foster