Reports for two different databases using ODBC
I've been struggling with Crystal bundled with VS.Net 2003 to create reports for two different database back-ends (postgreSQL and MS SQL Server). As soon as I change the ODBC connection under "Administrative Tools" from one a SQL Server one to a postgreSQL one, veryfing the database in the report designer view results in it "fixing" my report by removing everything!:(
My application uses WinForms for a GUI to a EJB back-end communicating via CORBA and Crystal is the only part that doesn't seem to be database independant.
Surely someone else has done the same thing (different databases "hidden" by ODBC) before?
Any comments welcome.