Home » Developer & Programmer » Reports & Discoverer » Dependent LOV for parameters on parameter form. (report 10g)
Dependent LOV for parameters on parameter form. [message #326110] Tue, 10 June 2008 04:15 Go to next message
sandipshahare
Messages: 21
Registered: March 2008
Location: Pune
Junior Member
We have three fileds on parameter form.
A,B,C.
I want to create a LOV for B and C which will depend on the selected value of A.

Please ,how to create such dependent lov on reports parameter form?
Re: Dependent LOV for parameters on parameter form. [message #326222 is a reply to message #326110] Tue, 10 June 2008 13:09 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You can not; not in Reports Builder, that is. Or, if you can, I don't know how to do that.

However, you might create your own parameter form (using Forms Builder, for example) which will enable you to do what you are looking for. Finally, you'd run report from a form.
Re: Dependent LOV for parameters on parameter form. [message #326519 is a reply to message #326110] Wed, 11 June 2008 20:51 Go to previous messageGo to next message
sandipshahare
Messages: 21
Registered: March 2008
Location: Pune
Junior Member
I solved my problem by using Javascript and functions in before parameter form.
Now the LOV is displaying which is depend on previous LOV value.

[Updated on: Wed, 11 June 2008 20:52]

Report message to a moderator

Re: Dependent LOV for parameters on parameter form. [message #326651 is a reply to message #326519] Thu, 12 June 2008 02:59 Go to previous messageGo to next message
dillango
Messages: 145
Registered: January 2008
Senior Member
Can you put your code in this forum? everyone will be benefitted.

Ilango
Re: Dependent LOV for parameters on parameter form. [message #326804 is a reply to message #326651] Thu, 12 June 2008 11:34 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Absolutely! I don't know Java, but - if it enables you to solve such a problem, posting the solution would greatly help people who need it as there were quite a few similar questions here in the past.
Re: Dependent LOV for parameters on parameter form. [message #329051 is a reply to message #326519] Mon, 23 June 2008 23:20 Go to previous messageGo to next message
hasnainlakhani
Messages: 24
Registered: January 2007
Junior Member
Hello sandipshahare

Will u please share your code of using Java Script and functions used in Before Parameter form so that I can also display List of Values depending on Previous List of Values in Report Builder 6i.

I will be very thankful to you. Please email me on hasnain.raza@orixpakistan.com

Best Regards

Hasnain Raza
Re: Dependent LOV for parameters on parameter form. [message #329088 is a reply to message #326110] Tue, 24 June 2008 00:58 Go to previous messageGo to next message
norsab
Messages: 6
Registered: June 2008
Location: malaysia
Junior Member
hai..

can you show me the how solved your problem regarding the LOV is depending on the other parameter?can u email me the java code? u can email to me at norsab_is@yahoo.com..i really appreciate your help..its urgent..

thanks..
Re: Dependent LOV for parameters on parameter form. [message #333318 is a reply to message #329051] Fri, 11 July 2008 04:15 Go to previous message
hasnainlakhani
Messages: 24
Registered: January 2007
Junior Member
Hello sandipshahare

I am still waiting for your reply. Its very urgent for me. Please help me. Please share your code of using Java Script and functions used in Before Parameter form so that I can also display List of Values depending on Previous List of Values in Report Builder 6i.

I will be very thankful to you. Please email me on hasnain.raza@orixpakistan.com

Best Regards

Hasnain Raza
Previous Topic: global variables in reports builder 10g
Next Topic: How to connect SAP database from oracle report?
Goto Forum:
  


Current Time: Fri Dec 09 19:28:28 CST 2016

Total time taken to generate the page: 0.14782 seconds