OraFAQ Forum: Reports & Discoverer » creating lov based on parameter in first feild

Home » Developer & Programmer » Reports & Discoverer » creating lov based on parameter in first feild

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

creating lov based on parameter in first feild [message #172596]

Wed, 17 May 2006 05:19

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

Report message to a moderator

Re: creating lov based on parameter in first feild [message #219110 is a reply to message #172596]

Tue, 13 February 2007 00:04

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

Report message to a moderator

Re: creating lov based on parameter in first feild [message #219130 is a reply to message #219110]

Tue, 13 February 2007 02:27

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

Report message to a moderator

Re: creating lov based on parameter in first feild [message #219483 is a reply to message #219130]

Wed, 14 February 2007 10:50

skooman
Messages: 913
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!

Report message to a moderator

Re: creating lov based on parameter in first feild [message #219762 is a reply to message #172596]

Thu, 15 February 2007 19:46

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Thanks for that guys!

Report message to a moderator

Previous Topic:	Invoice Problem
Next Topic:	global variable

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 05:00:11 CDT 2024