Results 1 to 5 of 5

Thread: Crystal and SQL

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Feb 2009
    Location
    Australia
    Posts
    1,292

    Default Crystal and SQL

    There was a thread back in 2006 asking about running Crystal Reports after a conversion of tables from Embedded to SQL. Dave Martinko offered some advice.

    https://support.dataaccess.com/Forum...tal+native+sql

    Is the effort required to continue using Crystal still the same? Although we intend to convert to DataFlex Reports, we would like to continue with Crystal in the short term
    Last edited by philby; 17-Feb-2019 at 09:02 PM.
    Phil
    Weather forecast for tonight. Dark !

  2. #2
    Join Date
    Feb 2009
    Location
    Queens, NY, NY
    Posts
    6,399

    Default Re: Crystal and SQL

    If you can find a copy of Davids Utility, that does the heavy lifting, but you will still have issues, usually with date & time fields.

    Basically you need to "touch" each and every report you have, run the change datasource wizard, and point to your new SQL server data. If you only have a few it's easy enough to deal with, but if you have hundreds, it's gonna get expensive.

    MM
    Michael Mullan.
    Danes Bridge Enterprises.

    ++++++++++++++++++++++++++++
    There is just today. Tomorrow is a concept
    that is mostly theoretical. -- GM Wylie
    ++++++++++++++++++++++++++++

  3. #3
    Join Date
    Feb 2009
    Location
    Adelaide, South Australia, Down under
    Posts
    2,157

    Default Re: Crystal and SQL

    Couldn’t autohotkey do this for you?
    Marco Kuipers
    DataFlex Consultant
    28 IT Pty Ltd - DataFlex Specialist Consultancy
    Adelaide, South Australia
    www.28it.com.au

  4. #4
    Join Date
    Feb 2009
    Location
    Somewhere in Vermont, USA - unless I'm not
    Posts
    9,316

    Default Re: Crystal and SQL

    Mertech offers Flex2Crystal which allows later versions of CR - but it requires the use of their SQL driver. That being said, I have a couple of clients using it.
    Garret

    Don't always believe what you think...



  5. #5
    Join Date
    Feb 2009
    Location
    Denmark
    Posts
    315

    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
  •