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

Problem formatting Time Interval in Crosstab

Started by mvdkam, 06 Aug 2013 06:27:24 AM

Previous topic - Next topic

mvdkam

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