Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: karthik.cognos on 19 Aug 2008 02:03:31 PM

Title: converting text box prompt values to uppercase
Post by: karthik.cognos on 19 Aug 2008 02:03:31 PM
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
Title: Re: converting text box prompt values to uppercase
Post by: rockytopmark on 19 Aug 2008 03:54:38 PM
UPPER([QueryItem]) = UPPER(?param?)
Title: Re: converting text box prompt values to uppercase
Post by: karthik.cognos on 20 Aug 2008 08:03:39 AM
When I do this my prompt gets changed to single select instead of multi select. Any further thoughts would be appreciated...
Title: Re: converting text box prompt values to uppercase
Post by: bonniehsueh on 20 Aug 2008 12:55:51 PM
instead of the equal sign use 'in'

UPPER([QueryItem]) in UPPER(?param?)
Title: Re: converting text box prompt values to uppercase
Post by: karthik.cognos on 21 Aug 2008 09:36:37 AM
When I do that my prompt gets displayed in a different manner...The right part (box) & the insert & remove buttons disappear...Any thoughts??
Text only | Text with Images