small question chart report/ urgent please

[johny.cbi]

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 ?

[Suraj]

go to properties, set data format as date/time.
then set 'No' to display hours, minutes, seconds etc...

[sandhya]

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])))