Make same report run for multiple MS SQL sources

[JordanCN]

I have a bunch of Crystal 8 reports that I had used for years with a Pervasive Database. Since the reports refereced the data by drive letter (H:\Data\File.ddf) to get the tables it was easy to use the same report on test databases or at other locations as long as I mapped my drive letter to the data.

I upgraded the data source to MS SQL and I want to convert the reports to use the new data source, but I am running into a little issue. I thought I could just make an ODBC source called MY_ERP_DATA and just point the ODBC to the right database on the server that I needed at the time but it does not work that way.

If I create the MY_ERP_DATA odbc connection it wants to know what SQL database. If I have 3 databases on the SQL Server (DB1 DB2 DB3) and I map the data, Crystal shows my tables mapped to DB1.dbo.My_Table. So if I want to change the ODBC connection to DB2 or DB3 the report will still look for DB1.

How do I set up a CRW 8 report so that it will automatically connect to the database in the current setup of the ODBC connection?

 

[chelseatech]

Our report schedulers have a table mapping feature where you can design a report against one database, but at run time switch to another.

Originally designed for Pervasive databases designed the way you were using them they now work with ODBC connections.

It needs an ODBC connection to each data source and then each report can be mapped to another connection.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[IdoMillet]

You have several options:
1. Set the qualified name option of each table in your reports (using Database, Set Datasource Location) to just the name of the table.

2. Use a 3rd-party viewer or scheduler to take care of that logic on the fly. chelseatech indicated his software does this. My "DataLink Viewer" and "Visual CUT" software take care of this challenge as well. You can see a list of other 3rd-party tools at

http://www.kenhamady.com/bookmarks.html

Cheers,
- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com