Skip to Content
Former Member
Jun 19, 2014 at 08:26 AM

Crystal Report Universe Connection



I have a Crystal report developed based on Universe as the data source. Say this report is in Dev environment. Suppose I need to promote this report to Test environment to UAT or production then how is it possible?

I have used import wizard using this I am able to move my report from one environment to another. report is successfully moved from source to destination but when I go to refresh the crystal report, an error is thrown (both in Crystal Report designer and Info view) :

"Failed to open the connection.

Update of the SQL command from the Universe failed. This report cannot be
refreshed unless the SQL command is updated from the Universe."

As such the Dev copy works fine. Please suggest me how to move a report from 1 environment to another.

If I changes connection manually in UAT Database --> Set Database location -->update then same report work fine,

But I have multiple reports I cannot manually edit connection of each report.

Useful details as below.

Crystal Reports 2008 (Service Pack 1)

Business Objects 3.1

View the connection details in report.

Set database location

Expand Universe connection

Properties - It will show server details of connection- user name - universe name- path of universe

Kindly advice.