Crystal Reports Sort different on server vs Visual Studio

1
votes

We are coding many reports in Crystal using the Visual Studio 2010 plug in. We're hosting the web application on Win Server 2008 Enterprise 64bit. We use SQL to sort the data being sent to the report.

The issue: On some reports the order is different on the server than when developing using VS. We're hitting the same DB in both cases and have confirmed that the data table being passed to the report is the same in both cases. We've confirmed that the DLLs are the same between the environments. We have a workaround which is to dictate the sort in the report. That seems like overkill.

Any ideas?

Thanks ST

1
crystal-reports

1 Answers

0
votes

This is most likely either record sort criteria in the reports or groups.

Both of these would override any ordering handled at db level.