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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×