Sage MAS 90 and 200 Extended Enterprise Suite

[mstebbing]

Am getting the following error from Crystal version 10 when trying to print landscaped invoices.  Just connected to the So.nvoicewrk table.

Failed to open a rowset.  Details: S0000:[ProvideX][ODBC Driver]ORDER BY contains too many columns

I have checked, and no user has the "Enable C/S ODBC Driver" checked.  Also, the template had worked previously when printing to portrait and using only a couple of less records in the invoice template.  This is the error I get when attempting to refresh the report within Crystal, and is exactly the same as when I attempt to print the invoices using the template.

I checked on the SAP website, and there seems to be nothing there, Providex is very much a Sage thing, but Sage won't really support Crystal....

[Cblack]

The first thing I try in this situation is to create a new, unformatted invoice and try the same thing you did to get this error.  If it works on the new form, it tells you that you have a crystal form error.

[evigil]

Did you get a resolution?