Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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 05:53 Go to next message
jeyinul  is currently offline jeyinul
Messages: 60
Registered: June 2011
Member
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 16:10 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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
Re: MONTH IS NOT IN PROPER ORDER IN CHART [message #702279 is a reply to message #699008] Tue, 26 July 2011 07:19 Go to previous messageGo to next message
jeyinul  is currently offline jeyinul
Messages: 60
Registered: June 2011
Member
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 09:02 Go to previous message
jeyinul  is currently offline jeyinul
Messages: 60
Registered: June 2011
Member
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:
  


Current Time: Fri Oct 31 16:43:33 GMT 2014

Powered by FUDForum. Page generated in 0.12891 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software