COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: caa on 22 Nov 2011 01:05:30 AM

Title: text box prompt for blob
Post by: caa on 22 Nov 2011 01:05:30 AM
hello

I need to use a text box prompt for blob field.
I built the prompt and when I try to run the report I get this massege:

prompts involving blob query items are not supported .

what can I do to allow search on this field?
Title: Re: text box prompt for blob
Post by: HalfBloodPrince on 22 Nov 2011 02:29:57 AM
You can try Cast function to convert it into character. But i think you wil need to change the data type in Database.
Title: Re: text box prompt for blob
Post by: caa on 27 Nov 2011 12:40:31 AM
I used the cast function and now I don't get the error message,
but now the prompt doesn't do the search it is asked for.