You receive a "The syntax of the value for prompt 'List1' is incorrect near '<value>'" error message when you try to print a parameterized report in Microsoft CRM 1.2 (889642)



The information in this article applies to:

  • Microsoft CRM 1.2

SYMPTOMS

After you run a report that uses input values to complete report processing (a parameterized report) in Microsoft Business Solutions CRM 1.2, you experience the following symptoms:
  • When you view the report, it appears correctly on the computer screen.
  • When you try to print the report, you receive the following error message:
    Crystal Report Viewer

    The syntax of the value for prompt 'List1' is incorrect near 'value'.
    Please correct the syntax and try again.

CAUSE

This problem occurs if the following conditions are true:
  • One of the report parameter values contains an apostrophe. For example, the report contains the following parameter value:

    User's sales

  • Hotfix 834913 is installed on the computer that is running Microsoft CRM 1.2. For information about hotfix 834913, click the following article number to view the article in the Microsoft Knowledge Base:

    834913 You are prompted for parameters two times when you try to print a parameter-driven report in Microsoft CRM 1.2

RESOLUTION

Microsoft CRM has a fix for this problem that is part of a cumulative update. The cumulative update information is described in the following Microsoft Knowledge Base article:

904435 Update Rollup 2 is available for Microsoft CRM 1.2

MORE INFORMATION

To obtain a list of frequently asked questions about Microsoft CRM reports, visit the following Microsoft Download Center Web site: For more information about how to use Crystal Reports 9 to write parameter-driven reports in Microsoft CRM 1.2, click the following article number to view the article in the Microsoft Knowledge Base:

834790 How to use Crystal Reports 9 to write parameter-driven reports for Microsoft Business Solutions CRM version 1.2

For more information about how to use Microsoft CRM 1.2 Reports Manager to modify reports, click the following article number to view the article in the Microsoft Knowledge Base:

834791 Adding, deleting, and renaming Microsoft CRM Reports by using Microsoft CRM 1.2 Report Manager

For more information about the terminology that is used to describe Microsoft product updates, see the following articles in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

887283 Microsoft Business Solutions CRM software hotfix and update package naming standards


Modification Type:MinorLast Reviewed:6/2/2006
Keywords:kbMbsreports kbMBSMigrate kbQFE kbHotfixServer KB889642 kbAudDeveloper