Paramter Form Builder in Oracle Report Builder 6i

Hi All,

In Parameter form of Oracle Report Builder 6i, suppose there are two input fields (each showing drop down list) input1 & input2. Can we write a query or rather link these two inputs fields using a query such that the input2 drop down list value changes according to the input1 value given by the user at runtime?

Kindly let me know if this is possible..if yes then what is the procedure to do the same.

I guess its not possible but then too can anybody please confirm this?

Thank you.

Regards,

Divya

re: Paramter Form Builder in Oracle Report Builder 6i

YES it is possible. You should have written SELECT query for the List of Values for both the parameters right? For the second parameter, did you try using the previous parameter P_1 in the WHERE Condition?

re: Paramter Form Builder in Oracle Report Builder 6i

Hi Amit,

Thanks for replying..

Yes i tried using input1 parameter in the where condition of input2 parameter's select query...but since input1 is a bind variable which acquires value only during runtime it dint allow me to do so.

Reg

Divya

re: Paramter Form Builder in Oracle Report Builder 6i

If you are going to register a report in oracle applications then you can add such Filter between input parameters using a VALIDATION SET.