Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

One Crystal Report portable to different databases (same database design)

Good day,

I apologize first off, as I am NOT a programmer, just a user.

In summary:

Crystal Report for data from Sql database.

Currently using ODBC connection and linking to database.

However, we have multiple databases, all with the same table structure etc, just different data.

Right now we change the datasource for each database.

The crystal report is run from an in house program

Is there a way we can have the report set so that it will pull the datasource at runtime, and not be hard coded into the crystal report.

Our goal is to take the one report and have our users of each database be able to access their own data without creating multiple copies of the report with each dataset.

Thanks,

RY

Former Member
Not what you were looking for? View more on this topic or Ask a question