Handling Crystal Reports in Dynamics SL

SL User is moving to Dynamics SL 2011 upgrading. Migrating customizations from SL 6.5 or SL 7.0 to SL 2011 has gone fine, on the other hand custom reports need an exact manner to ensure a smooth alteration. They can differ, but usually issues have to do “Report Execution” error messages when previewing a Report.

This concern is easily resolute by succeeding these steps:

1. Open the problematic report in Crystal Reports
2.  Go to the Database menu and select “Set Data source Location”

   3.  The “Set Data source Location” dialog opens. The top half is the current data source; the second is the  

    replacement data source. Each table and/or view involved in the report is listed at the top. If there are

 multiple instances of the same table, the Alias will appear before the table name in parenthesis. For

example, Ship Country (Country) – Country is the table name, Ship Country is the alias.   

 

4.  In the Replace with section, expand Create New Connection > ODBC

5.  When you expand ODBC, a list of data source names will appear, select the appropriate database, then press Next

6.  Enter the SQL Credentials press Finish.

7.  Select the first table/view on the Current Data Source and locate the matching table/view in the Replace With. Press Update.

8.  Repeat step 7 for ALL tables and views, including sub reports. Save the report and you will no longer see the error message! Before login Dynamics SL.