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

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.