|
SYMPTOMS
When you try to edit a Microsoft SQL Server Reporting Services report in
Microsoft Dynamics CRM, 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. Use the appropriate method:
a. 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.
b. 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:
a. 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.
b. 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.
|