need to avoid column sort on Cross Tab [message #368610] |
Mon, 15 June 2009 13:26 |
tero Messages: 58 Registered: July 2009 |
Member |
|
|
Hello All,
I am having a Cross Tab with years as the "row part" and month as String
as the column names (Jan, Feb, Mar, ...)
Now Birt automatically sort the months alfabetically: Apr, Aug, Dec, ...
Cannot find a way to avoid that, any ideas?
Thanks,
Tero
|
|
|
Re: need to avoid column sort on Cross Tab [message #368622 is a reply to message #368610] |
Tue, 16 June 2009 14:26 |
Eclipse User |
|
|
|
Originally posted by: jasonweathersby.windstream.net
Tero,
Can you try to put a sort on the crosstab with an expression similar to:
if( dimension["DateGroup"]["month"] == "Jan" ){
1;
}else if( dimension["DateGroup"]["month"] == "Feb" ){
2;
}else if..
..
..
..
Jason
Tero wrote:
> Hello All,
>
> I am having a Cross Tab with years as the "row part" and month as String
> as the column names (Jan, Feb, Mar, ...)
>
> Now Birt automatically sort the months alfabetically: Apr, Aug, Dec, ...
>
> Cannot find a way to avoid that, any ideas?
>
> Thanks,
> Tero
>
|
|
|
|
Re: need to avoid column sort on Cross Tab [message #368647 is a reply to message #368645] |
Wed, 17 June 2009 13:51 |
Eclipse User |
|
|
|
Originally posted by: jasonweathersby.windstream.net
Tero,
Are the month names in a Date dimension?
Jason
tero wrote:
> Thanks Jason,
>
> looks a bit odd to have to write those 12 IF's...
> since the result of the query (in the Preview Results too) is already
> sorted as I would like to have it. Isn't there a way to avoid the
> cube/crosstab sorting that again?
>
> Regards,
> Tero
>
|
|
|
|
Re: need to avoid column sort on Cross Tab [message #368680 is a reply to message #368676] |
Thu, 18 June 2009 18:26 |
Eclipse User |
|
|
|
Originally posted by: jasonweathersby.windstream.net
Tero,
I am pretty sure the date dimension will order correctly.
Jason
tero wrote:
> Hello Jason,
>
> Nop, they are String.
> In the query I am ordering by another field to get the correct order.
>
> Is that crosstab ordering the results in any case?
>
> Thanks
> Tero
>
|
|
|
Powered by
FUDForum. Page generated in 0.03484 seconds