Skip to Content
author's profile photo Former Member
Former Member

Transferring Crystal Reports

Dear Alll ,

Good Day , I am using BI 4.1 with Crystal 2011 SP7 And connecting direct to SAP ERP .

Issue is : All CR reports are uploaded on Quality CMC Retrieving from QAS ERP I need to transfer all CR reports to Production CMC and Moreover need to change all data source to retrieve from Production . so how can i change data source and Transfer to production at same time ???

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jan 02, 2014 at 12:12 PM

    Hi Said,

    Use the 'Promotion Management' tool in BI 4.1 to promote reports to QA to Prod.

    I'm not too sure if this tool can change the datasource of the reports. So, I'm assuming you'll need to open each report once they're in Prod and change the datasource manually.

    There used to be a tool in BO XI 3.1 called the 'Schedule Manager', however that is no longer available in BI 4.1.


    Add a comment
    10|10000 characters needed characters exceeded

    • Promotion Management cannot change the Datasource of Crystal reports unless they're based on a universe that has a connection that points to different data depending on the environment.

      One other option would be to open each of the reports in Crystal, use Set Location to change the Datasource and then publish the report to Production.

      A final option is to write code using either the .NET or the Java SDK to migrate the reports and change the connection at the same time. Let me know if you're interested in this - I may have some sample code.


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.