Crystal Report Universe Connection

[Former Member]

Hello,

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. 

Details:
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.

[former_member183750 · Accepted solution]

This is the same as:

Please do not cross post as this is against the SCN Rules of Engagement.

If this is a critical issue, you should be able to create a phone case - I suspect for you this would be free as you have BI / BO(?). If you are not sure how to, see your admin.

I will be locking this post now. Please continue on the above link.

- Ludek

SCN Moderator