Problem with order data

[Former Member]

Hi, I have a problem with order data. A string column has these values:

A....

B....

PSTA-FRA

PSTA+FRA

Q....

R....

If i order data directly from db ( select column1 from table order by column1 ) , i obtain this result:

...

PSTA-FRA

PSTA+FRA

...

If i create a simple report on that table and order on that column the result is:

PSTA+FRA

PSTA-FRA

I can obtain correct output if I set parameter 'Perform group on server' but if i write a selection formula :

{table.column} >= 'PSTA+FRA'

record containing PSTA-FRA value not appear.

I've tried both with Crytal 8.5 and Crystal 11 R2 sp6, database is Sybase SQL Anywhere odbc connection.

Thanks in advance

[former_member11696]

Ordering is done according to the ASCII values of the characters.

In R2 create a new report and log onto your DB and select Command for your data source. Paste in the SQL you use to get the data in the order the server users. Then you don't have to use CR to do the sorting. DB Servers are much more efficient at collecting the data than CR is.

Thank you

Don