Skip to main content

Crystal Reports is always connecting to the Live database even when the Play database is selected

This article can provide you with advice on how to resolve the issue around crystal reports constantly connecting to the Live database, even when the Play Database is selected.

J
Written by Jes Foxall-Beckley
Updated today

Overview

If you are trying to create test reports for the Play system, and when you open the report in Crystal and select the Play database, it always connects to the Live database, the advice below should help to resolve this issue.


How to resolve this

If you are experiencing this issue, you will manually need to update each table and view to the Play database in 'Set Datasource Location'.
​
An easier solution would be to run the Crystal file within the Play version of FactoryMaster and then open the Play Crystal File from the following location: C:\FactoryMaster\FMASTXX\Customer\Play\Crystal
​
This will automatically connect to the Play database.

Did this answer your question?