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 02:14 Go to next message
Paul Ramsden is currently offline Paul Ramsden
Messages: 75
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

Report message to a moderator

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
Jason Weathersby is currently offline Jason Weathersby
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

Jason Weathersby

BIRT Exchange

Report message to a moderator

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
Jason Weathersby is currently offline Jason Weathersby
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

Jason Weathersby

BIRT Exchange

Report message to a moderator

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
Jason Weathersby is currently offline Jason Weathersby
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

Jason Weathersby

BIRT Exchange

Report message to a moderator

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
Paul Ramsden is currently offline Paul Ramsden
Messages: 75
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

Report message to a moderator

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
Jason Weathersby is currently offline Jason Weathersby
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

Jason Weathersby

BIRT Exchange

Report message to a moderator

Previous Topic:Best SWT emitter?
Next Topic:Custom Parameter Page in Run Time
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 17:31:01 EDT 2013

Powered by FUDForum. Page generated in 0.01632 seconds