Hi All,
i have to define a prompt in Framework Manager within a query subject so that whenever a user pulls a column from that query subject in QS, he will be prompted for a value.
now the problem is the prompt type that cognos gives is an Edit Box prompt. Instead of this I need a Select Value prompt. I have tried by changing the Prompt Info property of the query item to Select Value, but still it is giving as an Edit box.
Can anyone tell me is this the way Cognos works or i can achieve this somehow?
PS: I have tried both the syntax for the prompt
column in ?prompt?
column in #promptmany()#
Thanks.
Hi,
All that should be required is to define a filter in the definintion of the query subject with the syntax
[youritem] in (?a_parameter?)
then find the [youritem] query item and change its prompt type property to 'SelectValue'
The only difference I can see here is that I used parentheses around my parameter in the filter definition .
If you have tried this and it still gives you a textbox prompt, then you probably need to log it with Cognos telesupport.
Regards,
MF.