Eclipse Community Forums: BIRT » MONTH IS NOT IN PROPER ORDER IN CHART

Home » Archived » BIRT » MONTH IS NOT IN PROPER ORDER IN CHART(MONTH IS NOT IN PROPER ORDER IN CHART)

MONTH IS NOT IN PROPER ORDER IN CHART [message #698731]

Wed, 20 July 2011 01:53

Eclipse User

I AM USING A CHART WHICH IS HAVING MONTH IN X AXIS.
MONTH IS NOT IN PROPER ORDER. IT COMES LIKE APR,AUG,FEB LIKE THAT.

PLEASE LET ME KNOW HOW TO ORDER.

THANKS,
ABDEEN

Re: MONTH IS NOT IN PROPER ORDER IN CHART [message #699008 is a reply to message #698731]

Wed, 20 July 2011 12:10

Eclipse User

If the x-axis defined as a date or a string? If it is a string add a
computed column to the chart binding tab with an expression similar to this:

if( dataSetRow["month"] == "Jan" ){
1;
}else if(dataSetRow["month"] == "Feb"){
2;
}else if(dataSetRow["month"] == "Mar"){
3;
}
..
..

Then use this in the sort field on the x-axis.
See attached example.

Jason

On 7/20/2011 1:53 AM, jeyinul wrote:
> I AM USING A CHART WHICH IS HAVING MONTH IN X AXIS.
> MONTH IS NOT IN PROPER ORDER. IT COMES LIKE APR,AUG,FEB LIKE THAT.
>
> PLEASE LET ME KNOW HOW TO ORDER.
>
> THANKS,
> ABDEEN

Attachment: sortmonthstring.rptdesign
(Size: 39.36KB, Downloaded 515 times)

Re: MONTH IS NOT IN PROPER ORDER IN CHART [message #702279 is a reply to message #699008]

Tue, 26 July 2011 03:19

Eclipse User

The file which you attached is not supported.

my version is version="3.2.20".

where is the computed column in chart

Please let me know.

Re: MONTH IS NOT IN PROPER ORDER IN CHART [message #702355 is a reply to message #699008]

Tue, 26 July 2011 05:02

Eclipse User

Its working fine jason.

Thanks.

Previous Topic:	Using parameter in Custom Parameter Page
Next Topic:	Multi-value cascading parameters in Custom Parameter Page

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 25 02:21:09 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter