COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: anilkumar on 20 Apr 2010 03:14:17 AM

Title: days in a reports
Post by: anilkumar on 20 Apr 2010 03:14:17 AM
HI 

i want to display Mon,tue wed .....sun in the report.

now want to show in the report  like this  Thu 01-apr-2010
                                              Fri  02-apr-2010

iam  using cubes as a datasource

Thanks & Regards
ANIL K.MARRI


Title: Re: days in a reports
Post by: SynexusStuart on 20 Apr 2010 09:55:39 AM
Once you have built the report select the list column (or singletonwith the date in and go to

Properties>Data>Data Format

Select "Date" from the drop-down list and then choose to "Display Weekdays" as Short Name.

you can also change the Date Style to your preferred style.

Run Report

Stuart
Title: Re: days in a reports
Post by: anilkumar on 21 Apr 2010 01:15:13 AM
hi Stuart

i tried as u mentiond but its not working

Regards
ANIL K.MARRI
Title: Re: days in a reports
Post by: Sreeni P on 21 Apr 2010 02:18:58 AM
Dude,

you have to cinfirm with ur model first, if the date is set their property as identifier will not show the complete time stamp(string), change that property as 'Attribute' and data type as 'date'...hope this wil fix ur problem