Re: Crystal and SQL
I’m in the process of moving an application from the embedded DB to MS-SQL. I have 70 Crystal Reports, and it is no big deal to replace the embedded DB with an SQL DB – I estimate 1 minute pr. report. It’s a lot of clicking but is easily done.
As default the conversion utility in DFFile replaces Date with Date-Time, and that will give a lot of work in Crystal as these types are not compatible. In my tests I have changed the default so Date is replaced with Date, and all reports seem to work with no changes.
Let me know if any of you thinks it’s a problem to replace DateTime by Date?
As my customers have different names for their SQL server and maybe for the database, I have subclassed cCrystal.pkg with procedures to change the database at runtime.
Last edited by Jørgen Münster; 22-Apr-2019 at 03:12 AM.
Jørgen Münster
Senior Analyst Programmer
Dialog Consult
Denmark