If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Limit a prompt to display 3 choices out of a possible 50

Started by rhythmz, 13 Aug 2010 01:47:24 PM

Previous topic - Next topic

rhythmz

How do I limit the values a prompt will display to only a handful of those that exist within a column of a table? For instance, I have a table called LOCATIONS with a column called NAME (I have 50 different stores and 3 warehouses). I only want to display a prompt showing the warehouse locations and not the stores (I do not have the ability to create a column with 'W' or 'S' before anyone asks, lol  ;D).

I cannot seem to get a second query with a filter limiting a column to return 3 values to work.

blom0344

How would you define that filter in the first place if stores and warehouses are stored in the same way? Would it not be simpler to just fetch the warehouse entries from the table?