COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: otsizh on 06 Oct 2005 09:55:52 AM

Title: [Closed]date type in the crosstab
Post by: otsizh on 06 Oct 2005 09:55:52 AM
Is it posible to insert the item of the date type inthe measures part of the crosstab?

When I do that it displayed as 20,051,231 insted of 12/31/2005
I applied data formating but it still is not working.

Thanks, Olha
Title: Re: date type in the crosstab
Post by: CoginAustin on 06 Oct 2005 10:06:22 AM
A date isn't really a measure is it?

I think it need to be numerical. You need to be able to sum/count and whatever else. How can you sum a date?
Title: Re: date type in the crosstab
Post by: sir_jeroen on 06 Oct 2005 01:54:03 PM
cross tab can't handle text :S
Title: Re: [Closed]date type in the crosstab
Post by: sir_jeroen on 07 Oct 2005 02:08:11 AM
Little reminder: close the topic if it's been solved/closed (see board rules)