Results 1 to 5 of 5

Thread: Crystal and SQL

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #5
    Join Date
    Feb 2009
    Location
    Denmark
    Posts
    311

    Default 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •