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.