Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » How to influence sorting rules in a group
How to influence sorting rules in a group [message #891504] Mon, 25 June 2012 06:14 Go to next message
Paul Ramsden is currently offline Paul RamsdenFriend
Messages: 79
Registered: February 2011
Location: BW, Germany
Member
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 20:00 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

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 20:00 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

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 20:00 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

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 12:28 Go to previous messageGo to next message
Paul Ramsden is currently offline Paul RamsdenFriend
Messages: 79
Registered: February 2011
Location: BW, Germany
Member
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 15:56 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

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: Thu Dec 18 12:37:03 GMT 2014

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

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