How to dynamically connect to multiple database?

[dyan24]

Hello,

Currently we have 600+ existing reports that we would like to consolidate. Each of those 10 reports have the same report format but just connecting to a different database, i.e. different company name.

Now, we would like to create just one report with a parameters of company name and based on the company name selected, we would like to dynamically connect to the right database.

If you were able to this already, can please provide any help on how this can be done. I am going to install CR 10 today on my machine and we are using SQL Server 2K.

Thanks in advance!!

 

[synapsevampire]

How do these reports connect to the database now?

How are the reports ran? VB? Crystal Enterprise? Each party has Crystal on their machine?

There are means to change the database using the Add Command, but I doubt that these reports were created that way.

And by databases do you mean servers, schemas or databases (just making sure)?

-k

 

[dyan24]

Thanks synapsevampire for your questions!

The reports are being run right now directly from the Crystal Report. There is a shortcut being provided to user right now to run the report.

We are in the process of moving to Crystal Enterprise maybe by December. Hence, we would like to start consolidating the reports now before we migrate all the reports to Enterprise.

I meant schema for database.

Thanks again!