Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Make same report run for multiple MS SQL sources

Make same report run for multiple MS SQL sources

Make same report run for multiple MS SQL sources

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?

RE: Make same report run for multiple MS SQL sources

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

RE: Make same report run for multiple MS SQL sources

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

- Ido

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close