Convert a PSQL Forms Printer Report to a SQL Forms Printer Report

23 December 2003

Issue Description

When migrating a database from Pervasive SQL to Microsoft SQL database, it is necessary to use Forms Printer reports designed for that database platform. If there are customized Forms Printer reports that have been utilized on the PSQL platform, it will be necessary to convert the Forms Printer reports for use in the SQL platform.

Important Note - These instructions are for reports created in Crystal Reports versions 8.0 and 8.5 only. If your reports were created in Crystal Reports 9.0 or higher, please refer to the Forms Printer documentation for the recommended technique to convert your reports.

Solution

  1. Create the SQL DSN. - Create a temporary DSN using a unique name Data Source Name. For example, use ASIFPTemp. This DSN should connect to your Company database. To do this, follow these steps:
    1. Go to the Control Panel Folder then double click the 32 bit ODBC Administrator icon.
    2. Click the 'System DSN' Tab.
    3. Click the 'Add' button. Select the **SQL Server Driver from the list. Click the 'Finish' button.
    4. Enter ASIFPTemp for the Data Source Name, enter a Description, and Server Name for this DSN.
    5. Click the 'Next' button.
    6. Click the radio button for: "With SQL Server authentication using a login ID and password entered by the user."
    7. Click the checkbox for: "Connect to SQL Server to obtain default settings for the additional configuration options."
    8. Enter a valid User and password for your SQL Server. Click the 'Next' button.
    9. Click the Checkbox for 'Change the default database' to Select your company database.
    10. Clear the checkboxes for 'Create temporary stored procedures…', 'Use ANSI Quoted identifiers.', and 'Use ANSI nulls, paddings, and warnings.'
    11. Click the 'Next' button.
    12. Leave the checkbox selected for: 'Perform translation for character data.'
    13. Click the 'Finish' button.
    14. Click the 'Test Data Source' button. The test window should show 'Tests completed successfully' if the DSN has been configured.
    15. Click the 'OK' button on the test window.
    16. Click the 'OK' button on the ODBC Server setup window.
  2. Open the report in Crystal Reports 8.0 or 8.5.
  3. From the Database menu, select 'Convert Database Driver'. Mark the checkbox 'Convert Database Driver on next Refresh'. From the drop down box, select 'psodbc.dll [ODBC]'. Click 'OK'.
  4. From the Select Data Source window, navigate to the Machine Data Source tab. Select the Data Source Name you created in step one. Click 'OK'.
  5. From the SQL Server Login window, click 'Options >>' to make sure you are connecting to the correct database. Enter your SQL Login ID and Password and click 'OK'.
  6. You will receive Verify Database dialog box for each table in the report that says, "The database file "table name" has changed. Proceeding to fix up the report!" Click 'OK' on each of these dialog boxes. If there is a field in the PSQL table that does not exist in the SQL version, after you click 'OK' you will see a Map Fields window. In general, the only column you will want to map is 'CMMTTEXT_TEXT' to 'CMMTTEXT'. Otherwise, simply click 'OK'. For more information on mapping fields in Crystal Reports, please refer to Crystal Decisions' Support web site at http://support.businessobjects.com/Default.asp
  7. Save the new report.
Site Map