OraFAQ Forum: Reports & Discoverer » Dependent LOV for parameters on parameter form.

Home » Developer & Programmer » Reports & Discoverer » Dependent LOV for parameters on parameter form. (report 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Dependent LOV for parameters on parameter form. [message #326110]

Tue, 10 June 2008 04:15

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?

Report message to a moderator

Re: Dependent LOV for parameters on parameter form. [message #326222 is a reply to message #326110]

Tue, 10 June 2008 13:09

Littlefoot
Messages: 21813
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.

Report message to a moderator

Re: Dependent LOV for parameters on parameter form. [message #326519 is a reply to message #326110]

Wed, 11 June 2008 20:51

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

dillango
Messages: 145
Registered: January 2008

Senior Member

Can you put your code in this forum? everyone will be benefitted.

Ilango

Report message to a moderator

Re: Dependent LOV for parameters on parameter form. [message #326804 is a reply to message #326651]

Thu, 12 June 2008 11:34

Littlefoot
Messages: 21813
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.

Report message to a moderator

Re: Dependent LOV for parameters on parameter form. [message #329051 is a reply to message #326519]

Mon, 23 June 2008 23:20

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

Report message to a moderator

Re: Dependent LOV for parameters on parameter form. [message #329088 is a reply to message #326110]

Tue, 24 June 2008 00:58

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..

Report message to a moderator

Re: Dependent LOV for parameters on parameter form. [message #333318 is a reply to message #329051]

Fri, 11 July 2008 04:15

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 03:55:38 CDT 2024