Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: johny.cbi on 24 Jan 2008 09:10:32 AM

Title: small question chart report/ urgent please
Post by: johny.cbi on 24 Jan 2008 09:10:32 AM
small question in chart report
there is day column on X-AXIS  ([Business Layer].[Date Dimension].[Date])
If I run the report it is showing

eg:  2007-10-25  00:00:00:000

I want to delete those zeros

I couldn't find exact option in properties

any ideas ?
Title: Re: small question chart report/ urgent please
Post by: Suraj on 24 Jan 2008 10:15:27 AM
go to properties, set data format as date/time.
then set 'No' to display hours, minutes, seconds etc...
Title: Re: small question chart report/ urgent please
Post by: sandhya on 13 Feb 2008 06:32:09 AM
Create a calculated column in ur query with following expression and use this calculated column on X-axis.

trim(cast_char(extract(year,[Business Layer].[Date Dimension].[Date])))+'-'+trim(cast_char(extract(month,[Business Layer].[Date Dimension].[Date])))+'-'+trim(cast_char(extract(day,[Business Layer].[Date Dimension].[Date])))
Text only | Text with Images