|
Re: MONTH IS NOT IN PROPER ORDER IN CROSS TAB [message #707396 is a reply to message #707161] |
Mon, 01 August 2011 15:32 |
|
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 #708210 is a reply to message #707885] |
Tue, 02 August 2011 15:17 |
|
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 #709163 is a reply to message #708795] |
Wed, 03 August 2011 15:15 |
|
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
|
|
|
Powered by
FUDForum. Page generated in 0.03513 seconds