By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,165 Members | 853 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,165 IT Pros & Developers. It's quick & easy.

Paramter Form Builder in Oracle Report Builder 6i

P: 2
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
Mar 18 '09 #1
Share this Question
Share on Google+
3 Replies


amitpatel66
Expert 100+
P: 2,367
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?
Mar 19 '09 #2

P: 2
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
Mar 19 '09 #3

amitpatel66
Expert 100+
P: 2,367
If you are going to register a report in oracle applications then you can add such Filter between input parameters using a VALIDATION SET.
Mar 20 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.