Skip to Content
0

Connecting a 3rd party database to Crystal Reports

Apr 25, 2017 at 03:47 PM

47

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Luis Darui
Apr 25, 2017 at 03:50 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Thanks for your help. I was able to connect my database to Crystal!

1

Hi Adam! Great! Go ahead and mark as a correct answer then!

0