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

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

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.

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. Use the appropriate method:
   • In Microsoft Dynamics CRM 3.0, log on to the Microsoft Dynamics CRM Web client as a user whose role has the Manage Reports permission.
   • In Microsoft Dynamics CRM 4.0, log on to the Microsoft Dynamics CRM Web client as a user whose role has the Publish Reports permission and the Add Reporting Services Reports permission.
3. Click Workplace, and then click Reports.
4. Click New.
5. Use the appropriate method:
   • In Microsoft Dynamics CRM 3.0, click Browse in the Report:New dialog box to find the .rdl file for the report, fill in the additional information for the report, and then click Save.
   • In Microsoft Dynamics CRM 4.0, open the Report:New dialog box. Next, click Existing Report in the Report Type list. Finally, click Browse to find the .rdl file for the report, fill in the additional information for the report, and then click Save.