QODBC v5.0.0.102 or later works perfectly using Crystal Reports XI Profesional or Developer Editions with the Empolyee and Empolyee Earnings Tables using either Inner Joins or Left Outer Joins.
If you have Crystal Reports (CR) 9 and when refreshing an existing report with linked tables, or when creating a new report and linking the tables, this error message "Crw32.exe has encountered a problem and needs to close. We are sorry for the inconvenience" appears, it means the file SACommonControls.dll is not registered properly.
CR 9 needs to have the copy of SACommonControls.dll in the C:\Program Files\Common Files\Crystal Decisions\2.0\Bin folder registered.
To Register the Correct Version of SACommonControls.dll ------------------------------------------------------------------------------------ 1. Click the 'Start' button, and then click 'Run'. 2. Enter the following in the 'Open' combo-box: Regsvr32 "C:\Program Files\Common Files\Crystal Decisions\2.0\bin\SACommonControls.dll" 3. Click 'OK'. A dialog box will appear indicating you have successfully registered the DLL. Click 'OK'.
Now, when you open reports with linked tables in CR 9 the error message will not appear.
|