Crystal Reports 8.5 error: ODBC Error: 'ORDER BY contains too many columns' followed by 'Error dectected by database DLL' when refreshing Payroll export for ADP. Primary file is PR1 Employee Masterfile with two sub-reports to PR3 Tax Summary file (linked using @FedCode /@StateCode + PR1_EE_Dept & PR1_EE_Nbr. The only similiar error (ORDER BY contains too many columns) was related to paper size, but I'm using Legal/Landscape so that is not the issue. Any suggestions for where to look? Thank you!