We have migrated from Crystal reports to BOXI 3.1.
Basically I’m looking for a way to migrate the published .rpt files in Crystal management console to Business objects Infoview.
Do anyone know of a way to take backup of reports using CMC and then Import the same backup file in BOXI
Thanks for your reply.
I didnt mean abt CMS or Infoview in BOXI.
I’m talking about legacy crystal web application “crystal mangement console”
We do have a couple of reports published in this app.
So I’m looking for a way to take backup of this and publish to CMS of BOXI
Hope that makes sense
“CMC” means “Crystal Management Console” which is an interface into a number of different applications. So, is sounds like you either have an old version of Crystal Enterprise, which was the pre-cursor to BO in its current form, or you have some version of Crystal Server.
You have a couple of options.
If the Import Wizard from your 3.1 system will connect to the old system, you can use that to import your reports.
See whether the software will let you export to “Crystal Reports” format. If it will, do that, then open the report in your current version of Crystal, turn off “Save Data with Report”, and publish to your BO system.
See whether the software gives you a path to where the report template is located. If it does, go there, get the .rpt file (it will probably have a random name…), open the .rpt in Crystal and then publish it.
You are right .
we are using an old version of crystal enterprise.version 10.0
I have to check for option 1
I dont think the options 2 and 3 will work.The .rpt files are published to the enterprise.I know the locations for each of them but the problem here is I have around 500 reports published in to the enterprise portal.
So saving each of them and publishing again in new BO interface is gonna be time consuming
I’m looking for alternate ways.
If option 1 does not work for you, your only alternatives are to either do it manually or write a program using the SDK that will do it for you. However, the challenge with that is going to be getting the correct report title. If you haven’t set the Title in the report properties in Crystal, your code would probably have to open the report and find the title in the header of the report, and it could be tricky to find the correct object for that.
Option 1 really works for me.
Thanks for your guidance
However,I am having a strange issue regarding the format of report out put after migration.
Some of the reports in .xls format have misalignment of columns and headers.
I just checked the format in enterprise 10 and the selected format is excel(data only) with all options under it enabled.
Where as the same report when exported to BOXI,had the format as excel(data only) with only one option under it enabled.
I know that this only creating the alignement problem of headers
is there anyway i can export these options as well?
Unfortunately, there is no way to do this - the structure of underlying info in BusinessObjects is different from Crystal Enterprise, which is why the properties are not coming over correctly.