Error message when you try to print a report in Microsoft Dynamics SL: "Crystal Print Engine Error: 723… Failed to open a rowset"

Article ID: 905310 - View products that this article applies to.
  
Expand all | Collapse all

On This Page

SYMPTOMS

When you try to print a report in Microsoft Dynamics SL or in Microsoft Business Solutions - Solomon, you receive an error message that is similar to the following:
Crystal Reports Helper Application for Solomon IV
Cannot start print job.
Report: Drive:\Program Files\Solomon\Module_Code\XXXXX.RPT
Crystal Print Engine Error: 723 - Error in File Drive:\Program Files\Solomon\Module_Code\XXXXX.RPT:
Failed to open a rowset.
Note In this error message, Drive represents the drive on which you installed Microsoft Dynamics SL, Module_Code represents the module code that corresponds to the Microsoft Dynamics SL module in which the report is located, and XXXXX represents the file name of the report.

CAUSE

This problem occurs for one or more of the following reasons.

Cause 1

The report contains notes. See Resolution 1 in the "Resolution" section.

Cause 2

You have Microsoft Solomon 6.0 installed, and the report that causes the error is the Account Distribution (01.ACC.DI) report. See Resolution 2 in the "Resolution" section.

Cause 3

The report is a custom report that uses a preprocess. See Resolution 3 in the "Resolution" section.

Cause 4

The Open DataBase Connectivity (ODBC) Data Source Names (DSNs) are missing or corrupted. See Resolution 4 in the "Resolution" section.

Cause 5

The option to use ANSI quoted identifiers is not selected. See Resolution 5 in the "Resolution" section.

Cause 6

There is not enough free disk space on the computer that is running Microsoft SQL Server and that hosts the Microsoft Dynamics SL databases or the Microsoft Business Solutions - Solomon databases. See Resolution 6 in the "Resolution" section.

RESOLUTION

To resolve this problem, use the appropriate resolution.

Resolution 1

If you receive the error message when you try to print a report that contains notes, click to clear the Select Distinct Records check box on the Database menu in Crystal Reports for Solomon. For more information about how to turn off this option, click the following article number to view the article in the Microsoft Knowledge Base:
896330 You receive a Crystal Print Engine error message when you try to print a Microsoft Crystal Reports for Solomon 6.0 Invoice/Memo Forms report that includes notes

Resolution 2

If you receive the error message only when you try to print the Account Distribution (01.ACC.DI) report, and if you have Microsoft Solomon 6.0 installed, replace the 01acctdi.rpt file that is in your installation by using the 01acctdi.rpt file from the Microsoft Solomon 5.5 installation CD. For more information about how to make this replacement, click the following article number to view the article in the Microsoft Knowledge Base:
898694 The Account Distribution report is blank for a company that is not the master company in Microsoft Solomon

Resolution 3

If you receive the error message when you try to print a custom report that uses a preprocess, use one of the following methods.

Method 1

Add the custom report as a separate item in the Microsoft Dynamics SL menu structure. For more information about how to add items to the menu structure, click the following article number to view the article in the Microsoft Knowledge Base:
887345 How to add a third-party software program to the Microsoft Solomon menu in Version 6.0

Method 2

Attach the custom report as a new report format to an existing report that does not use a preprocess. To attach the custom report, follow these steps:
  1. Start Microsoft Dynamics SL.
  2. On the Utility menu, click Report Control Maintenance.

    Note The Report Control Maintenance (98.300.00) dialog box opens.
  3. In the Report Number box, enter the number of the report to which you want to attach the custom report.
  4. Click Control Options.
  5. Verify that the Pre-Process box is blank. If the Pre-Process box is not blank, go back to step c, and then enter a different report number.
  6. On the first blank row, type the display name of the report in the Report Format Name box, and then type the report file name in the Report Format box.

    In this step, "the report" refers to the Crystal Reports report in Microsoft Windows. For example, type 01accdi in the Report Format box if the report file name is 01accdi.rpt.
  7. Click Save. Then click Close.

Resolution 4

Remove and then re-create the Microsoft Dynamics SL or Microsoft Solomon database ODBC DSNs. To do this, follow these steps:
  1. Click Start, click Control Panel, click Administrative Tools, and then click Data Sources (ODBC).
  2. On the User DSN tab, select a Dynamics SL database, and then click Remove. Repeat for all Dynamics SL databases that appear in the list.
  3. On the System DSN tab, select a system data sources that relates to a Dynamics SL database, and then click Remove.
  4. Click OK.
  5. To re-create the ODBC DSNs, start Microsoft Dynamics SL, and then run a print preview of any report.

Resolution 5

Turn on ANSI quoted identifiers. To do this, follow these steps:
  1. Click Start, click Control Panel, click Administrative Tools, and then click Data Sources (ODBC).
  2. On the User DSN tab, select the appropriate database, and then click Configure.
  3. Click Next.
  4. Specify the appropriate credentials, and then click Next.
  5. Click to select the Use ANSI quoted identifiers check box.
  6. Click Next.
  7. Click Finish.
  8. Click OK two times.

Resolution 6

Free some disk space on the computer. To do this, delete unnecessary data or increase the disk capacity.

Properties

Article ID: 905310 - Last Review: July 13, 2011 - Revision: 6.0
APPLIES TO
  • Microsoft Dynamics SL 2011
  • Microsoft Dynamics SL 7.0
Keywords: 
kbtshoot kbexpertiseinter kbexpertisebeginner kberrmsg kbmbsenvironment kbinfo kbmbsmigrate KB905310

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com