Sorting of data in report

[mroos81]

Hello everybody,

I created a report in Crystal Reports 7. I connected the report to a CRM-system which is only compatible with CR7. A client-version of CR7 is included with the CRM-system.

I want the data in this report sorted in a special way. To achieve that, I manually adjusted the SQL-query.
When I view the report in Crystal Reports itself, everything works just fine. But when I view the report trough the CRM-system, it's sorted in a completely wrong way.

Can anybody tell me what the problem is here, and how I can fix it? Has it something to do with client-version of CR, or should I use a different way to sort the data?

Thanks for your help!

Michael

 

[Reebo99]

At a guess, I'd say that the CRM-system is probably passing SQL to the report at runtime.

Probably easier to open the report in CR and goto report>record sort and choose the sorting options. This will then be embedded within the report rather than the SQL.



Reebo
UK

Please Note - Due to current economic forcast and budget constraints, the light at the end of the tunnel has been switched off. Thank you for your cooperation.