Lexicographic ordering

szanyi

Hi all!
I am from Hungary. I am newbie in BIRT. I use version 2.2.1.
I have table element and a dataset with customer's data. After inserting a group (by serial_number and not by customer_name) inside the table, in Group Details I set the sorting key to customer_name.
Of course, the report result is not in my language's lexicographic order. But I would like to know how I can correct this problem. Could anybody help me, please?
change charset? BIRT engine locale? JVM locale? I don't know.
What about language packs? Does nl2 package resolve my problem?
How can I integrate it with my report engine?

Thank you in anticipation!

szanyi

I solved my problem in Oracle:

select name, rownum as order_by_col from(
select * from customer order by name)

and sort_key in BIRT: order_by_col. Ready.