Dynamic Data Sources

[DocFKNx]

Using Crystal 8.5/9.0. I have reports that are the same but need to have different ODBC data sources at runtime depending on where they are deployed. Without saving the data source in each copy of the report how can I have just ONE report that works with any number of ODBC data sources?! I'm using a proprietary front end (C++) that just calls the viewer to run reports. Thanks!

X

 

[DocFKNx]

Also note that the reports use stored procedures in SQL as the ultimate data source (navigated to via ODBC connections). Not sure if this is pertinent. The stored procedure name is the same from ODBC source to ODBC source.

Thanks!

 

[WindUp]

>I have reports that are the same but need to have
>different ODBC data sources at runtime

There is a FAQ for this Forum called "Data Access for the Developer using Crystal Reports". I think (hope) that will answer your question.

Good Luck!
WindUp.