create user parameter [message #357743] |
Thu, 06 November 2008 07:40 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
nanees
Messages: 4 Registered: October 2008
|
Junior Member |
|
|
Dear All;
I wanted create user parameter that the values depend on chose value of another user parameter in oracle 10g report please
take for example, you have two user parameters, COUNTRY and CITY, the CITY parameter displays the list of CITIES available everytime the COUNTRY parameter is changed by the user in the parameter form... how do you execute this
anyone help me
[Updated on: Thu, 06 November 2008 07:45] Report message to a moderator
|
|
|
Re: create user parameter [message #357819 is a reply to message #357743] |
Thu, 06 November 2008 15:14 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Although there've been rumours that someone managed to do that in Reports Developer using certain Java code, I have never seen it (and the person who said he did it never replied back).
Therefore, all I can suggest is that Reports can't do that. You'll have to create your own parameter form (using Forms Developer, for example). There you'll be able to make one list of values dependent on another.
Of course, you'll then have to call report from form, pass parameter values and ... well, that should be all.
|
|
|