Skip to main content

How to link Crystal Report to the Live or Play Database

We would like to link Crystal Report to the Play Database in order to do some testing. How can we do that? I need to link the Crystal Reports software to the live database.

J
Written by Jes Foxall-Beckley
Updated over 2 weeks ago

In order to do this, please follow the instructions below:

  1. Open the relevant Crystal Report within the Crystal Report software

  2. Select Database

  3. Set datasource location

  4. Change the datasource to the play database instance

If you are using Crystal Reports software version XI, please complete the following steps:

  1. Launch Crystal Reports

  2. Select File

  3. Log on or Log off server

  4. Expand create new connection

  5. Double-click OLEDB(ADO)

  6. Select SQL Native Client and click Next

  7. Enter Data Source (server name)

  8. Enter login credentials (e.g. username FMREPORTS, password: FMLX)

  9. Select relevant database

  10. Click Next and Finish

  11. Expand DBO to see all the FactoryMaster database tables and views

Did this answer your question?