Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » How to influence sorting rules in a group
How to influence sorting rules in a group [message #891504] Mon, 25 June 2012 02:14 Go to next message
Eclipse UserFriend
I have a table which has a group on Country. The country names are in German and contain umlauts. So Austria is Österreich and comes after Zimbabwe in the report result. Ideally, it should appear between N and P.

How can I influence this? The data originates from SQL Server which does order correctly (Ö interpreted as Oe). After grouping by BIRT this ordering is lost.

Thanks

Paul
Re: How to influence sorting rules in a group [message #891762 is a reply to message #891504] Mon, 25 June 2012 16:00 Go to previous messageGo to next message
Eclipse UserFriend
Paul

Did you set the locale for the sort?
http://www.eclipse.org/birt/phoenix/project/notable2.6.php#jump_15

See attached example.

Jason

On 6/25/2012 2:14 AM, Paul Ramsden wrote:
> I have a table which has a group on Country. The country names are in
> German and contain umlauts. So Austria is Österreich and comes after
> Zimbabwe in the report result. Ideally, it should appear between N and P.
>
> How can I influence this? The data originates from SQL Server which does
> order correctly (Ö interpreted as Oe). After grouping by BIRT this
> ordering is lost.
>
> Thanks
>
> Paul
Re: How to influence sorting rules in a group [message #891763 is a reply to message #891504] Mon, 25 June 2012 16:00 Go to previous messageGo to next message
Eclipse UserFriend
Paul

Did you set the locale for the sort?
http://www.eclipse.org/birt/phoenix/project/notable2.6.php#jump_15

See attached example.

Jason

On 6/25/2012 2:14 AM, Paul Ramsden wrote:
> I have a table which has a group on Country. The country names are in
> German and contain umlauts. So Austria is Österreich and comes after
> Zimbabwe in the report result. Ideally, it should appear between N and P.
>
> How can I influence this? The data originates from SQL Server which does
> order correctly (Ö interpreted as Oe). After grouping by BIRT this
> ordering is lost.
>
> Thanks
>
> Paul
Re: How to influence sorting rules in a group [message #891764 is a reply to message #891504] Mon, 25 June 2012 16:00 Go to previous messageGo to next message
Eclipse UserFriend
Paul

Did you set the locale for the sort?
http://www.eclipse.org/birt/phoenix/project/notable2.6.php#jump_15

See attached example.

Jason

On 6/25/2012 2:14 AM, Paul Ramsden wrote:
> I have a table which has a group on Country. The country names are in
> German and contain umlauts. So Austria is Österreich and comes after
> Zimbabwe in the report result. Ideally, it should appear between N and P.
>
> How can I influence this? The data originates from SQL Server which does
> order correctly (Ö interpreted as Oe). After grouping by BIRT this
> ordering is lost.
>
> Thanks
>
> Paul
Re: How to influence sorting rules in a group [message #891881 is a reply to message #891764] Tue, 26 June 2012 08:28 Go to previous messageGo to next message
Eclipse UserFriend
Jason

thanks for your help again!

No, I hadn't noticed the locale setting in sort. What I am actually doing is a group not a sort. The group seems to sort differently or do I apply a sort as well?

Paul
Re: How to influence sorting rules in a group [message #891940 is a reply to message #891881] Tue, 26 June 2012 11:56 Go to previous message
Eclipse UserFriend
Paul,

Can you try to select the table and add a locale based sort on it? Also
you may want to try and use the sort tab in the group editor as well.

Jason

On 6/26/2012 8:28 AM, Paul Ramsden wrote:
> Jason
>
> thanks for your help again!
>
> No, I hadn't noticed the locale setting in sort. What I am actually
> doing is a group not a sort. The group seems to sort differently or do I
> apply a sort as well?
>
> Paul
Previous Topic:Best SWT emitter?
Next Topic:Custom Parameter Page in Run Time
Goto Forum:
  


Current Time: Wed Jul 23 23:06:00 EDT 2025

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly