Results 1 to 5 of 5

Thread: Best driver for Crystal 8.5 (yes, 8.5) with MSSQL 2008

  1. #1
    Join Date
    Mar 2009
    Posts
    26

    Default Best driver for Crystal 8.5 (yes, 8.5) with MSSQL 2008

    I have a large number (150 - 200) of Crystal reports written in v8.5. (Yes, I know this is a tad ancient but upgrading is not currently an option). These access native DF files and now will be using MSSQL 2008. In a previous conversion ODBC was used and this worked well but looking around there are references to 'ADO' and 'FILEDSN'.

    Most of these reports are called from VDF but some are 'stand alone'.

    Before starting this conversion, which must include all the date field nonsense, it would be of much help to get advice as to which driver is best. Doing it twice would not be pleasing. These reports are peculiar to this site so no need for them to work with other back-ends. Mass Convert is, sadly, not an option with 8.5 or that would have been used.

    Kind regards from Scotland,

    Sandy.

  2. #2
    Join Date
    Feb 2009
    Location
    Hengelo, Netherlands
    Posts
    10,863

    Default Re: Best driver for Crystal 8.5 (yes, 8.5) with MSSQL 2008

    Sandy,

    How about moving these reports to Visual Report Writer instead?
    Regards,
    Data Access Worldwide
    Vincent Oorsprong

  3. #3
    Join Date
    Feb 2009
    Location
    Queens, NY, NY
    Posts
    7,424

    Default Re: Best driver for Crystal 8.5 (yes, 8.5) with MSSQL 2008

    Vincent,

    How fast do you think crystal reports (from 8.5) can be re-cast into VRW? I spent nearly a full day re-coding a Winreport2 into a VRW RDO report on Monday.

    MM
    Michael Mullan.
    Danes Bridge Enterprises.

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

  4. #4
    Join Date
    Feb 2009
    Location
    Hengelo, Netherlands
    Posts
    10,863

    Default Re: Best driver for Crystal 8.5 (yes, 8.5) with MSSQL 2008

    Michael,

    Depends on the report. Some can be done within minutes, some take more time.
    Regards,
    Data Access Worldwide
    Vincent Oorsprong

  5. #5
    Join Date
    Mar 2009
    Posts
    26

    Default Re: Best driver for Crystal 8.5 (yes, 8.5) with MSSQL 2008

    Vincent,

    150 to 200 reports? If you have a Crystal to VDW conversion program that might be worth a try but doing it manually would take a long time. Yes, some reports are quite simple but others are not and they would be a nightmare.

    Planning to use the OLE Native driver but any other observations would be appreciated.

    Kind regards,

    Sandy.

Tags for this Thread

Posting Permissions

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