Skip to Content
avatar image
Randy Davis

Trying to connect Crystal Reports

Nov 04, 2016 at 04:00 PM | 54 Views

I have a client where I have installed SAP Crystal Reports 2013 SP5 to her local machine and am attempting to connect it to their SAP database. However, the Database Expert is not listing SAP Business One as a connection option. The other SAP connection options do not list an available SAP system:

I've successfully installed and configured CR remote to the SAP database in the past, but it has always been with SQL Tools and SSMS installed. Is that necessary here with CR? Installing SQL Tools is not an option here. Are there other options?

I do have CR installed on the server and have no issues there. Does anyone have any insight into this?

2016-11-04-9-21-34.jpg (88.7 kB)
SAP Business One
SAP Crystal Reports
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Don Williams
    Nov 07, 2016 at 05:33 PM

    Hi Randy,

    There is an OEM version of CR Designer for Business One. You need to use that version to get the B1 database drivers.

    She can go to the B1 SAP site and download it. Uninstall the one you installed, if it's not the B1 version.

    Don

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Gonzalo Gomez
    Nov 08, 2016 at 12:01 PM

    Make the conexion using OLE DB (ADO)

    Microsoft OLE DB Provider fro SQL Server

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Dell Stinnett-Christy
    Nov 08, 2016 at 05:28 PM

    If it's not B1, you would need to have the SAP client installed to her machine in order to get the connection info for reporting.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded