Report to work with multiple databases how?

[linuxjr]

I know about the set location but first read my post and if I'm using set location wrong then any help will be appreciated.

I am trying to make a simple report that pulls records on equipment based on the status like repair work done or not done.

I have a replicated server set up and made the report from one database but have 34 different databases. They are all the same format but different information obviously. Now I created a quick report and works fine with one database but I run the same report for the second database and nothing. If I change locations using set location it works fine. Now my question is Do I have to make 34 reports when I know they all are the same format, same data size, etc etc. Or do I have to add some code behind the report so that it will run on all 34 databases with one report. Any help or tips be greatly appreciated. Have a nice day.

 

[synapsevampire]

Your connection is different, and the connectivity is embedded in the report.

If the report is used at multiple sites, then each site can share a like named ODBC connection.

If the report is used against multiple data sources from one location, then the only way to do this that I know of within Crystal is to use a different report for each database, or use a DSN and change it each time you run the report.

Or you could write some external code to control the report.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[linuxjr]

Thanks for the reply as I am trying to teach myself here. How would I go using code to be able to select say the datasource I'm connected to when the report runs? Thanks for the reply as I work on these reports.

 

[synapsevampire]

You could wrap the report(s) in a VB app.

Check out the Crystal Reports Integrate forum here, and the following might be useful if you're a VB coder:

http://support.crystaldecisions.com/communityCS/TechnicalPapers/rdc_gettingstarted.zip.asp

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com