Microsoft KB Archive/920124

= You receive an error message when you try to add, publish, or upload a report to Microsoft Dynamics CRM =

Article ID: 920124

Article Last Modified on 1/4/2008

-

APPLIES TO


 * Microsoft Dynamics CRM 4.0
 * Microsoft Dynamics CRM 3.0

-



SYMPTOMS
You experience one of the following symptoms in Microsoft Dynamics CRM:  When you try to add or publish a report to Microsoft Dynamics CRM 3.0, you receive the following error message:

Object reference not set to an instance of an object.

When you try to add or publish a report to Microsoft Dynamics CRM 4.0, you receive the following error message:

An error has occurred.

Try this action again. If the problem continues, check the Microsoft Dynamics CRM Community for solutions or contact your organization's Microsoft Dynamics CRM Administrator. Finally, you can can contact Microsoft Support.

Error code:

Note To publish a report to Microsoft Dynamics CRM, use the PublishReports.exe tool. By default, this tool is in the following location:

C:\Program Files\Microsoft Crm\Reports

 When you try to upload a report that is created in Microsoft Visual Studio 2005 to Microsoft Dynamics CRM, you receive the following error message:

>MSCRM Application Error Report:

Error: Exception of type System.Web.HttpUnhandledException was thrown. Error Message: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Error Details: Exception of type System.Web.HttpUnhandledException was thrown.

Source File: Not available

Line Number: Not available

Request URL: http:// : /CRMReports/reportproperty.aspx Stack Trace Info: at System.Web.UI.Page.HandleError(Exception e)

Note You receive this error message if the DevErrors value is set to On in the Web.config file.



CAUSE
This problem can have either of the following causes.

Cause 1
The data source of the report is a shared data source. See Resolution 1 in the &quot;Resolution&quot; section. The data source of the report must be an embedded data source.

Cause 2
The publish.config file contains a reference to a report that does not exist. See Resolution 2 in the &quot;Resolution&quot; section.



Resolution 1

 * 1) Open the report in Report Designer.
 * 2) On the Data tab, click the lookup button to the right of the Dataset list.
 * 3) Click the lookup button to the right of the Data Source list.
 * 4) Click to clear the Use shared data source reference check box.
 * 5) Click Edit to the right of the Connection box.
 * 6) In the Server name box, type the server name. Then, select the authentication method and the correct database name.
 * 7) Click OK two times.
 * 8) On the File menu, click Save as.
 * 9) Save the report on the Microsoft Dynamics CRM server, and then add the report.

Resolution 2
Follow these steps on the Microsoft Dynamics CRM server:  Locate the folder that contains the publishreports.config file. By default, this folder is the following folder:

C:\Program Files\Microsoft Crm\Reports

 Make a backup of the publish.config file. Open the publishreports.config file in Notepad. Find the line that contains the report that does not exist. For example, find the line that begins with ‘<report filename=’ pointing to a report that does not exist or that contains misspelled words.</li> Remove that line, and then save the file.</li></ol>

For more information about how to use the PublishReports tool, click the following article number to view the article in the Microsoft Knowledge Base:

918841 How to manually connect SQL Reporting Services (SRSS) to Microsoft Dynamics CRM 3.0

Keywords: kbmbscrm40 kbmbsreports kberrmsg kbtshoot kbmbsmigrate kbprb KB920124

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.