Showing results for 
Search instead for 
Did you mean: 

Crystal Develop and Production Guidelines in SQL Server (Crystal 9)

Former Member
0 Kudos

We have development and production environment on 2 different machines.

It seems when we want to migrate a report from dev to prod, we need to reset the DSN or connection and crystal then forces us to respecify all field names in a report.

It is a big pain. Has anyone seen this?


Ken Light

DBA Interior Health

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos


When you migrate a report, you need to

- Create a DSN with same name on Production as it was on Test.

- Do a set Datasource location.

- Verify database to ensure all changes made in the database are reflected.

- If you have used stored procedure with parameter in your report, then uncheck the above option and then refresh the report.

Hope this helps!!!



Answers (0)