One Crystal Report portable to different databases (same database design)
I apologize first off, as I am NOT a programmer, just a user.
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.