Can we apply a filter on list of values in the Value Prompt

Can someone tell me whether can we apply filter on list of values in the 'Value Prompt' e.g. I have a value prompt (named city) and the prompt is holding around 2000 cities but I want to apply a filter on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enough to select any 15 cities from the list. Is it possible.
Please advice!

Questions by myshah789   answers by myshah789

Showing Answers 1 - 11 of 11 Answers

Geoff Nail

  • Jun 17th, 2011

Are you asking if you can filter the cities out of the value prompt or are you asking if you put a maximum selection on the box?

  Was this answer useful?  Yes

Prabin Das

  • Jul 13th, 2011

Try using Dynamic View for the will work.For eg: lets say there is country field.if you you choose US then it should show only US states not all the states from world.This can be achieved by Dynamic View.
Make City as Key after State as a key in Runcontrol record.based upon key structure it will work

  Was this answer useful?  Yes


  • Jul 17th, 2011

Dude, this can be accomplished with Java script only. Else, there is no way of doing this Cognos with available features. Check this site:


  • Aug 2nd, 2011

Yes. You can definitely apply filter on prompt to restrict the record. Value Prompt creates its own query. So, that filter will be applied to only prompt query.

  Was this answer useful?  Yes


  • Aug 2nd, 2011

Yes. You can definatley apply filter on value prompt because value prompt creates its own query and you'll apply the filter only to that prompt query.

  Was this answer useful?  Yes


  • Aug 12th, 2011

I think you should suggest Select and Search prompt to your users. I didnt exactly understand your requirement, but select and search sounds close to what you are tryin to achieve.

  Was this answer useful?  Yes


  • Oct 21st, 2011

yes,Its very simple to achieve.When we create a prompt it will create a query for it separately(Prompt query) other than the report main query.In that prompt query you can drag and drop a filter and develop the filter expression like " country in ('India','Australia','South Africa') " (what ever countries you want to see you can mention in the list).

  Was this answer useful?  Yes


  • Nov 3rd, 2011

In this case i prefers select & search prompt to select cities,because if we type alphabet 'a' then it will show cities start with a ,if user doesn't know the cities then we need to use value prompt ..

  Was this answer useful?  Yes


  • Mar 12th, 2013

I am sure your table has other high-level data item that you can group cities into like region, district or countries. You can cascade from them to limit your cities.

  Was this answer useful?  Yes

sreenivasulu pokuru

  • Apr 26th, 2013

1)Open the value prompt query
2)Drag a filter from tool box into detailed filter
3)Write the filter condition like country in (India,Japan,china,- - - - - - - )

that's it

  Was this answer useful?  Yes


  • Jul 31st, 2013

just add a value prompt and use query and put use value and codes or any unique values.
use display values.
Then put the filter in the query.
Assign this query to the prompt.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account

Send   Reset


Related Answered Questions


Related Open Questions