I have designed an application that can use either local tables or SQL Server. I am using Crystal Reports for the reporting. I have 2 ODBC DSNs, one pointing to the local tables in the DBC and one pointing to the SQL Server database. I just rename them when I want to switch to the other data.

I was hoping to have one set of reports that can be used to report on both data sources. However I am finding that this approach will not work. It appears that Crystal formats it's query syntax differently depending on the source of the data, especially when joins are involved. When I switch to the other DSN, the reports no longer work.

Is there a way to get around this and have one set of reports that will work with either set of data?