Skip to Content
avatar image
Former Member

Migration of BO Crystal reports into SAP BO Crystal Reports 4.0

Hi Experts,

I have a new requirement with one of our client... it goes like this.

Client has 150 BO crystal reports this are the reports(.rpt files) which are way back before SAP acquire , so it means that this are original and independent BO software reports.

The requirement is now we have to migrate those reports to SAP BO Crystal Reports 4.0 and they are using Oracle as Database.

I am new to crystal reports can anyone please share me the steps to do the same?

Thanks & Regards in Advance

Pradeep Kumar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 29, 2015 at 04:48 PM

    If the reports are in and older version of BusinessObjects already, is it BO XI, XI r2 or XI 3.1?  Or is it Crystal Reports Server XI, XI r2, or XI 3.1?

    The answer to this question will determine how you're going to get the reports into the new version of BusinessObjects.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

    • You can have both the 32-bit and the 64-bit Oracle Clients installed side-by-side on the server, so it won't affect any of the existing Webi reports.

      The one thing you'll want to do is edit the "PATH" environment variable to make sure that the path to the 32-bit client is to the left of the one to the 64-bit client.

      -Dell

  • Nov 06, 2015 at 06:34 AM

    Hi Deepu,

    I have Migrated 200 Crystal Reports from XI R2 to 2013 and Oracle as the backend DB.

    Steps I followed:

    1. Created a backup .BIAR file in BO XI R2 using import Wizard.

    2. Had copied the file to the new BO environment (BO 4.1) using Promotion Management.

    3. Then you'll find the reports added to the New environment repository. Open the reports from CR 2013 and test the reports and save it back to the repository.

    FYI:

    Once the Oracle Client is installed, you should create and test your TNS names within the Oracle client. Then you should be able to connect to Oracle from Crystal Reports using the Oracle Native Client using Service Name(basically TNSNAME or your OID(Oracle Internet Directory)). And User name and Password.

    Issues I faced:

    1. The Dynamic prompts where not copied. Had to create it manually again in reports from Business View Manager. Need to be very careful while pointing the Dynamic prompts to the new reports as it may change the report structure and will face issues in running the report.

    2. All the schedules will be gone. Need to recreate the same.

    3. Need to check the connection in the reports.

    Apart from above issues everything went well. Let me know if you have any questions.

    Thanks,

    Samrat Muddasani

    Add comment
    10|10000 characters needed characters exceeded