How to dispaly the Date data in Oreder

HI ,

I am having data with date in following manner "2008,Jul 2008,Aug 2008,Sep 2008,Oct 2008,Nov 2008,Dec 2009,Jan".
here my data is coming fine through data base query but when i try to display this result in Birt it is displayin the result like this "2008,Aug 2008,Dec 2008,Jul 2008,Nov Oct 2008 Sep 2008 2009,Jan" what i understood from this is it is reading the values in aplha batical order. But i want them to display as it is.

Can Any one help me on this . thank you in advance.

Vijay kumar bolisetti

Find more posts tagged with

Comments

mwilliams

Hi Vijay,

Do you have the actual date field of dateTime type too? Or just this string date like "2008 Aug"?

vbolisetti

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="69745" data-time="1288102834" data-date="26 October 2010 - 07:20 AM">
Hi Vijay, 
 
Do you have the actual date field of dateTime type too? Or just this string date like "2008 Aug"? </blockquote>
 
Hi Williams, 
 
I am having month and year fileds like 2008 and 8 from the data base.so i am converting the month 8 to august.when i am writting this i got an idea. insted of converting value in query have separate data set and get that value to string and display it.I have to try now.but will it come in order that is my big question? i will try reply to you.if u have any thisng plz let me know. 
 
Thank you 
vijay kumar BOlisetti

mwilliams

Vijay,

You could create another column that is of "date" type and use the year and month values to create an actual date field. You can then add this date field as an attribute to your current string date dimension in your dataCube and use the attribute field to sort the crosstab on. Let me know if you have any questions on this.

EDIT: I guess you didn't say you were using a crosstab, but the same should work on a regular table. You just won't have to use the "attribute" step. You'd sort your table on the new computed field.

vbolisetti

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="69797" data-time="1288201443" data-date="27 October 2010 - 10:44 AM">
Vijay, 
 
You could create another column that is of "date" type and use the year and month values to create an actual date field. You can then add this date field as an attribute to your current string date dimension in your dataCube and use the attribute field to sort the crosstab on. Let me know if you have any questions on this. 
 
EDIT: I guess you didn't say you were using a crosstab, but the same should work on a regular table. You just won't have to use the "attribute" step. You'd sort your table on the new computed field. </blockquote>
 
Thank you. 
 
Yes you are right i was using this in crosstab only.since i want to display month in order and fortunatley i had date column in that so my life became easy.thank for your valuble suggestion as well as time.

mwilliams

Not a problem. Let us know whenever you have questions!