Hi
Sure this is simple, I would like to have a value prompt use a query item as its prompt selection. So the item lives in a reprt studio query and not in the database tables.
could anyone point out the solution please
thanks
Malcolm
Where do the values for the item in question originate? If not in a database somewhere, are they manually entered by the report author? If so, just select your prompt and go to the 'Static choices' property - you can manually enter them there.
Or am I misunderstanding? (quite normal for me! :) )
MF.
As far I know there are four ways to populate a prompt:
1) From a query that lives in your databases
2) From static choices that the report developer defines them in the propertes of the prompt
3) From an excel that the developer upload it ( in Cognos 10)
4) On the fly the user can populate a prompt with values that are in a csv ( you need to use javascript to achieve this)
:) Thanks for the help, perfect