How to Create Dynamic Cross-DBMS Crystal Reports

[gkinu]

I have a VS.NET 2005 C# Windows Application. The same cab use one of a number of different DBMSs including SQL Server, MySQL, Access.

Is there a way of creating dynamic crystal reports that can use any of the DBMSs as datasources without having to design a report for each of the databases?

[dip_developer]

I have a VS.NET 2005 C# Windows Application. The same cab use one of a number of different DBMSs including SQL Server, MySQL, Access.

Is there a way of creating dynamic crystal reports that can use any of the DBMSs as datasources without having to design a report for each of the databases?

i dont know about mysql.......... ..but for sql-server/access you know that they are different database.....th eir DataProvider/connectionstrin g/commmand object/dataadapter/datasets are different...... ..so you have to know the basics of these databases...... ....if you can make a dataset(or datatable or xml) from sql-server or access then crystal report can be created........no need of designing different reports for different databases....yo u have to dynamically produce the dataset which will be the datasource of the report......... ...