Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » (no subject)
(no subject) [message #707161] Mon, 01 August 2011 09:55 Go to next message
jeyinul  is currently offline jeyinul Friend
Messages: 60
Registered: June 2011
Member
Hi All,

I am trying to generate a report in month wise,
But MONTH IS NOT IN PROPER ORDER IN CROSS TAB,

Its coming Alphabetical order by default,
How to order.

Plz help me on this,

Regards,
Jeyinul.
Re: MONTH IS NOT IN PROPER ORDER IN CROSS TAB [message #707396 is a reply to message #707161] Mon, 01 August 2011 15:32 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

I assume your month is not a date field. If it is a string, add a sort
expression to the crosstab with an expression similar to:

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

Jason

On 8/1/2011 5:55 AM, jeyinul wrote:
> Hi All,
>
> I am trying to generate a report in month wise,
> But MONTH IS NOT IN PROPER ORDER IN CROSS TAB,
>
> Its coming Alphabetical order by default,
> How to order.
>
> Plz help me on this,
>
> Regards,
> Jeyinul.
Re: MONTH IS NOT IN PROPER ORDER IN CROSS TAB [message #707885 is a reply to message #707396] Tue, 02 August 2011 07:22 Go to previous messageGo to next message
jeyinul  is currently offline jeyinul Friend
Messages: 60
Registered: June 2011
Member
Hi Jason,

Its not working.

I added in Binding.

Field name is lookupcode. It has month names

I added

if(dimension["Group3"]["LOOKUP_2_Data Set4::LOOKUPCODE"] == "Jan" ){
1;
}

But its not working.

Please help me on this,

Thanks,
Jeyinul.
Re: MONTH IS NOT IN PROPER ORDER IN CROSS TAB [message #708017 is a reply to message #707396] Tue, 02 August 2011 10:40 Go to previous messageGo to next message
jeyinul  is currently offline jeyinul Friend
Messages: 60
Registered: June 2011
Member
Hi Jason,

Its a cross tab. Where i have to add the expression in cross tab.

Please give details and what time will come to online,.

Plz let me know.

Regards,
Jeyinul.
Re: MONTH IS NOT IN PROPER ORDER IN CROSS TAB [message #708210 is a reply to message #707885] Tue, 02 August 2011 15:17 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

You do not add a binding. Select the crosstab and in the properties
view click on the sorting tab and add it there. Take a look at the
attached example.

Jason

On 8/2/2011 3:22 AM, jeyinul wrote:
> Hi Jason,
>
> Its not working.
>
> I added in Binding.
>
> Field name is lookupcode. It has month names
>
> I added
>
> if(dimension["Group3"]["LOOKUP_2_Data Set4::LOOKUPCODE"] == "Jan" ){
> 1;
> }
>
> But its not working.
>
> Please help me on this,
>
> Thanks,
> Jeyinul.
Re: MONTH IS NOT IN PROPER ORDER IN CROSS TAB [message #708705 is a reply to message #707396] Wed, 03 August 2011 05:20 Go to previous messageGo to next message
jeyinul  is currently offline jeyinul Friend
Messages: 60
Registered: June 2011
Member
This also not working.

Re: MONTH IS NOT IN PROPER ORDER IN CROSS TAB [message #708795 is a reply to message #708210] Wed, 03 August 2011 07:20 Go to previous messageGo to next message
jeyinul  is currently offline jeyinul Friend
Messages: 60
Registered: June 2011
Member
I checked your attached file. Its not in proper order.


Output is,

Feb 42
Jan 32
Mar 52

Plz help
Re: MONTH IS NOT IN PROPER ORDER IN CROSS TAB [message #709163 is a reply to message #708795] Wed, 03 August 2011 15:15 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

I am running this in 2.6.1 and it displays in the proper order.
I have added the running sum you asked for in the other thread and my
output looks like:

Jan 32
Feb 74
Mar 126

I have attached the report.
What version of BIRT are you using? I do not believe the sort will work
in 2.5.0 if that is what you are using. You will need to sort it on the
dataset instead of the crosstab.

Jason


On 8/3/2011 3:20 AM, jeyinul wrote:
> I checked your attached file. Its not in proper order.
>
>
> Output is,
>
> Feb 42
> Jan 32
> Mar 52
>
> Plz help
Previous Topic:Parameter that decides wich table show
Next Topic:Calculate Cumulative value in cross tab
Goto Forum:
  


Current Time: Mon Dec 22 02:18:07 GMT 2014

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

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