Error message when you try to edit a Microsoft SQL Server Reporting Services report in Microsoft Dynamics CRM 3.0: "String was not recognized as a valid DateTime" (920125)


The information in this article applies to:

  • Microsoft CRM 3.0

SYMPTOMS

When you try to edit a Microsoft SQL Server Reporting Services report in Microsoft Dynamics CRM 3.0, you may receive the following error message:
String was not recognized as a valid DateTime.
The problem occurs if you use Microsoft Visual Studio .NET to publish the report to Microsoft Dynamics CRM.

CAUSE

This problem occurs because the Microsoft SQL Server Reporting Services report contains functionalities that are specific to Microsoft Dynamics CRM. For example, the Microsoft Dynamics CRM Pre-filtering functionality is specific to Microsoft Dynamics CRM. If you use Microsoft Visual Studio .NET to publish the report, instead of using Microsoft Dynamics CRM to add the report, the process that enables the Microsoft Dynamics CRM-specific functionalities will fail. Microsoft Dynamics CRM does not support the use of Microsoft Visual Studio .NET to publish reports to Microsoft Dynamics CRM.

RESOLUTION

To resolve this problem, follow these steps:
  1. After you design a report by using Microsoft Visual Studio .NET, save the report as an .rdl file instead of publishing the report to the Microsoft SQL Server Reporting Services instance that is used by Microsoft Dynamics CRM.
  2. Log on to the Microsoft Dynamics CRM Web client as a user whose role has the Manage Reports permission.
  3. Click Workplace, and then click Reports.
  4. Click New.
  5. In the Report:New dialog box, click Browse to find the .rdl file for the report, fill in the additional information for the report, and then click Save.
Modification Type:MajorLast Reviewed:6/16/2006
Keywords:kbtshoot kbMbsreports kberrmsg kbMBSMigrate kbprb KB920125 kbAudEndUser kbAudKnowledgeWorker
©2004 Microsoft Corporation. All rights reserved.