Skip to Content
0
Former Member
Mar 04, 2011 at 10:51 AM

Problem with order data

21 Views

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