We are migrating all our crystal reports from Crystal Enterpise 9 to BO X1.

I used the BOXI Import wisard to import all the reports from CE 9 to the new BOX1 Server Successfully.

But currently the reports are pointing to a old database, whereas we need them to be set located to a new database. Is there a way to change the dsn settings during Import process ?

Or can anyone suggest a way to change the custom database logon of all the reports in CE 9 , so that I can migrate after changing it to new database ?

with regards,
Anand

There a two ways of doing this.

1) Edit the current datasource to point to new server. (You will only need to do this once and all reports may need verifying but will be looking in the right place)

2) Create a new datasource, then go to database and set datasource location.

Hope this helps you.

Kempes

Hello Kempes,

Thanks a lot for your reply.

Actually I was trying to change the datasource in bulk instead of doing for every individual reports.

I have found a alternate solution for this. In the crystal enterprise - > admin launch pad, there is a link by name "Schedule Manager", in which I shall use the 'change database logon' - to change the database information for all the reports in the current folder or subfolder.

Anyway, thanks again for your reply.