Home » Developer & Programmer » Reports & Discoverer » creating lov based on parameter in first feild
creating lov based on parameter in first feild [message #172596] Wed, 17 May 2006 05:19 Go to next message
amits76
Messages: 5
Registered: February 2006
Junior Member
hi,

i am new on disco working on latest version( not 10g) , .

i have two parameter .

1) country
2) state.

condt is that if i select India in country parameter , i should display all staes of india,or if i select US , it should display all states of US.

how can it be done in disco
pls help , its urg

thanks
Amit
Re: creating lov based on parameter in first feild [message #219110 is a reply to message #172596] Tue, 13 February 2007 00:04 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Asked for so many times(topics) here but nobody seems to have a solution for this. I just hope this time as I revive the topic someone can answer me.

I passed a parameter from forms to report as P_1, then I have field on report which is P_2. I want an LOV for P_2 that is based on P_1.
eg: Select name from mytable where id = P_1.
I tried a lexical type (&P_1) and :P_1 it's not allowed(error).

Thanks in advance!

Wency
Re: creating lov based on parameter in first feild [message #219130 is a reply to message #219110] Tue, 13 February 2007 02:27 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, it isn't possible - not in Reports Builder.

We have developed our own parameter form (using Forms Builder) which "acts" as a Reports parameter form. It means that you'd pass 'P_1' from your "original" form to a "parameter form" and use it in first List of Values item. The second List of Values item, in Forms, can "see" value written in the first one and restrict fetched data set to desired values.

Finally, pressing a "Run report" button on your "new" parameter form would, actually, pass "real" parameters to your report.
Re: creating lov based on parameter in first feild [message #219483 is a reply to message #219130] Wed, 14 February 2007 10:50 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
As far as I know, it's not possible in Discoverer neither.

However, in the newest Oracle BI tool (in full: Oracle Business Intelligence Enterprise Edition, in short: OBI EE, product previously know as Siebel Analytics), this is possible.

But okay, that won't help you now, sorry!
Re: creating lov based on parameter in first feild [message #219762 is a reply to message #172596] Thu, 15 February 2007 19:46 Go to previous message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Thanks for that guys!
Previous Topic: Invoice Problem
Next Topic: global variable
Goto Forum:
  


Current Time: Tue Dec 06 02:41:21 CST 2016

Total time taken to generate the page: 0.05485 seconds