Reports 3.0 Feeding parameter to another parameter select

[Quoted] 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 Received on Fri Feb 04 2000 - 18:43:46 CET