Migrating Legacy Reports to SQL Format

Modified on Wed, 03 Mar 2021 at 09:09 AM

When upgrading to Version 6 of ProCal crystal reports will require modification to run correctly.

This modification takes approximately 1 minute however does require a copy of Crystal Reports.

  1. Open the report file in Crystal Reports.
  2. Using the top bar, navigate to Database and then select 'Set Datasource Location'.
  3. The data source location window will appear.

  4. Select the database (In this case the default C:\ProCal\Certificates\proresdb.mdb, and then expand the 'Create New Connection' box in the 'Replace With' box. Highlight the 'OLE DB (ADO) item and click the Plus icon.

  5. When the next window appears, select 'Microsoft OLE DB Provider for SQL Server' and click 'Next'.

  6. From the Server dropdown, select the SQL Server that the ProCal Database is stored on (In this case TRANSWINSERVER\TRANSMILLE).

  7. Enter the User ID and Password used to connect to the server. If you do not know this your system administrator will be able to assist. Please note that this is NOT your ProCal login details.

  8. Select the Database drop-down and select ProCal. Click next, and then next again. The window will disappear.

  9. At the 'Set Datasource Location', select the new database connection (TRANSWINSERVER\TRANSMILLE) and the current database (C:\ProCal\Certificates\ProResDB.mdb) and then click the 'Update' button on the right which has now become accessible.

  10. The original database will be updated to the new database which indicates that the data source has been updated.

  11. Click 'Close' on the window.

  12. Save the report to the new file location into the 'Reports_SQL' folder.

  13. The report is now available for use in ProCal, ProCal-Track and ProSales.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article