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

converting text box prompt values to uppercase

Started by karthik.cognos, 19 Aug 2008 02:03:31 PM

Previous topic - Next topic

karthik.cognos

I have a prompt page that includes a Text Prompt and need to ensure that the data entered is converted to uppercase to match the data in the database.
Any ideas how I can convert the text entered in the prompt to uppercase?
Users will be entering multiple values in the Text Box Prompt

rockytopmark


karthik.cognos

When I do this my prompt gets changed to single select instead of multi select. Any further thoughts would be appreciated...

bonniehsueh

instead of the equal sign use 'in'

UPPER([QueryItem]) in UPPER(?param?)

karthik.cognos

When I do that my prompt gets displayed in a different manner...The right part (box) & the insert & remove buttons disappear...Any thoughts??