Skip to Content

Changing Crystal Report datasource from Access to SQL DB

I have over 100 legacy crystal reports which are pointing to older access database.

We recently migrated from access DB to SQL server DB. Few tables from access DB have been split into multiple granular tables in the new SQL server DB

What are the effective options to change datasource from access database to SQL server database without changing crystal report?

Is there a way to do bulk update without opening each and every crystal report?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jul 29, 2020 at 07:56 PM

    You could potentially use either the .NET or the Java SDK to update the reports where the tables are exactly the same in both databases. However, any reports where the tables have changed will have to be manually updated by opening the report in Crystal, Going to Database >> Set Location, selecting the old database connection in the top and new database in the bottom, and clicking "Update". Crystal will then have you remap any fields that don't match between the two.


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.