Database selection for Crystal Report

Question

How To Choose Database for crystal reports in runtime with fields designed already in reports i.e I Have 2 Databases A1A2 with same design for different years.Is it possible to create a single crystal report. Thanks Jaffreena

PJ Martins · Answer

All you need to do is set your report's datasource to the desired dataset. ie. You'd fill your dataset with data from database A1 or A2 and set report.DataSource = to this dataset. As long as the column names are the same as the field names the report will know how to handle it.

Jaffreena Michaelthomas · Answer

Thank u Martin I have tried with that idea and it works. R