Sage 100

I am having an issue with using a subreport that references an ODBC other than SOTAMAS90 in a crystal form (A/R Invoice). I am trying to access an Oracle database. The client is on Sage 100 ERP Standard at version 4.5. Is it possible to any other source? Are there work arounds? The actual error is ""Unable to view Invoice Printing. Failed to retrieve data from the database. Details: [Database Vendor Code: 1017].

The last time I checked (and it's been a while) the Crystal that comes with MAS had an ODBC limitation where SOTAMAS90 was the only allowable DSN. I would work around that by using another connection method such as OLE DB or Access/Excel.

What Dan said. In Crystal if you choose OLE DB instead of ODBC then choose OLE DB Provider for Oracle.

OLE helped a lot. Thank you very much. Now the only question is, in the preview inside Sage100ERP I have to drill down to get the subreport. Is there a way to make this a continual report.

Is the sub report defined as ""On-demand"" in the sub report properties under the tab ""Subreport""?

It is not. It is behaving very similarly though other than not showing the title in hypertext.