COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Yasser on 17 Jan 2017 09:17:43 AM

Title: Text limitation in report studio !
Post by: Yasser on 17 Jan 2017 09:17:43 AM
Hello,

This is the day of limitation in Cognos  >:(,

I've tow data items each one have a string of 30k characters, When I concatenate them in a new data item and include it in a Rich Text Item it crash telling me that I've exceeded the maximum of 32767 characters !!

Is there any workaround to resolve it in the report studio ?

Thanks,
Title: Re: Text limitation in report studio !
Post by: BigChris on 17 Jan 2017 10:17:27 AM
Just out of curiosity, what are you planning to do with a calculated field of 60,000 characters? I don't know how many screens that would fill, but it certainly isn't going to be small.
Title: Re: Text limitation in report studio !
Post by: Yasser on 17 Jan 2017 11:28:16 PM
Quote from: BigChris on 17 Jan 2017 10:17:27 AM
Just out of curiosity, what are you planning to do with a calculated field of 60,000 characters? I don't know how many screens that would fill, but it certainly isn't going to be small.

The two fields are HTML code stored in the DB as CLOB, I need to show it rendered in the exported PDF. So, I've string with 60k characters (and sometimes 120k+ by the way), I've divided in to two data items in the DB and FWM and I want to display it in single Rich Text Item to be exported as pdf. I know showing 120k characters is a very special case, But I need to do that  ;)