"Crystal Print Engine Error 723" when you try to print or to preview a custom report in Microsoft Dynamics SL

Applies to: Dynamics SL 2011

Symptoms


When you try to print or to preview a custom report in Microsoft Dynamics SL, you receive an error message that resembles the following message:
Cannot start print job.
Report: C:\Program Files\Solomon\Usr_Rpts\CUSTOM.RPT
Crystal Print Engine Error: 723 - Error in File
C:\Program Files\Solomon\Usr_Rpts\CUSTOM.RPT: Failed to open a rowset.
This problem occurs if the following conditions are true:
  • The custom report contains a parameter field.
  • You type the appropriate value when the report prompts you for a parameter.
  • You specify additional selection criteria on the Select tab in the Report Options Interpreter (ROI) screen.

Cause


This problem occurs because the Report Options Interpreter (ROI) screen incorrectly concatenates the WHERE clauses that are in the selection criteria and in the parameter field.

Workaround


To work around this problem, do not include the parameter field in the custom report. Instead, create the parameter selection criteria on the Select tab of the Report Options Interpreter (ROI) screen.