Skip to Content
avatar image
Former Member

Connecting a 3rd party database to Crystal Reports

Hello everyone. I am trying to connect a networked SQL database to Crystal Reports for a custom report. I just can't figure out how to go about it. I'm not sure which option under Database Expert I am supposed to use. Anyone know?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 25, 2017 at 03:50 PM

    Hello Adam,

    It depends on your release. In Database Expert, you have to select "Create new connection". Try to find OLE DB (ADO) and you should be able to find "Microsoft OLE DB Provider for SQL Server".

    Make sure SQL Server is accepting external connections. Check the following article in TechNet on how to enable it

    You also might want to check the Crystal Reports documentation:

    https://help.sap.com/doc/businessobject_product_guides_cr2011_en_xi4_cr_usergde_en_pdf/2011/en-US/xi4_cr_usergde_en.pdf

    Add comment
    10|10000 characters needed characters exceeded