COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: mvdkam on 06 Aug 2013 06:27:24 AM

Title: Problem formatting Time Interval in Crosstab
Post by: mvdkam on 06 Aug 2013 06:27:24 AM
Hi everyone,

First post here, so hope that anyone can (and will) help me.

I have a problem formatting a Time Interval in a crosstab. I discovered that large values cause an error when running the report. When the value is less than or equal to 2147483647 (this is the equivalent of 2^31 - 1), formatting is done without any problem. However, when the value is larger than 2147483647, an error occurs.

Does anyone have come accross this an has a solution? Of course I can switch to a list instead of a crosstab, but I would not like to do that if not necessary (cause this makes the queries in the report unnecessary complex and you will have to define the exact amount of columns and rows that are necessary).

I appreciate any help. Many thanks in advance!

Regards,
Marco