Help! A new CRM report....

  • Article

Today i will posting something technical, since my last post was even described as pr0n..Yeah I also can't believe it..maybe it's jealousy....

I often see people having problems publishing/load new reports into Microsoft CRM.
They will get errors such as:

NullReferenceException: Object reference not set to an instance of an object.]
Microsoft.Crm.Reporting.SRSReport.convertDataSource(CrmContext context) +115
Microsoft.Crm.Reporting.SRSReport..ctor(String name, String description, String xmlContent, String showin, String relatedentity, String category, CrmContext context, String filename, String origFilter) +136
Microsoft.Crm.Reports.ReportCache.CreateSRSReport(String name, String description, String template, String showin, String relatedEntity, String category, String filename, Boolean isNewReport, String defaultFilter) +100
Microsoft.Crm.Application.Platform.Report.InternalCreate(String xml) +629
Microsoft.Crm.Application.Platform.Entity.Create() +109
Microsoft.Crm.Application.Forms.AppForm.RaiseDataEvent(FormEventId eventId) +404
Microsoft.Crm.Application.Forms.EndUserForm.Initialize(Entity entity) +56
Microsoft.Crm.Application.Forms.EndUserForm.Execute(Entity entity) +13
Microsoft.Crm.Web.Tools.ReportProperty.ReportPropertyPage.ConfigureForm() +202
Microsoft.Crm.Application.Controls.AppPage.OnPreRender(EventArgs e) +30
System.Web.UI.Control.PreRenderRecursiveInternal() +62
System.Web.UI.Page.ProcessRequestMain() +1499

The steps below describe the way how to solve it when you are using Visual Studio 2005, i bet 2003 works kinda similair.

1. Create a new Report Project in Visual Studio 2005

2. Right click on Reports, choose to add Existing Item

3. Double Click on the report to open it.

4. Click on the Data (top tab) above the open report file.

5. Click the "..." button just to the right of Dataset to open Dataset Properties.

6. Click on the "..." button to the right of the Data Source drop down list.

7. Clear the "Use shared data source reference" option.

8. Click on the "Edit..." button to the right of Connection string.

9. Enter the correct SRS Server Name, enter the authentication method, and choose the correct database name.

10. Click OK, this will change the source for the entire report.

11. Click OK to the Visual Studio window again.

12. Choose, File, Save <Report> as...

13. Save the report on the CRM Server and try to upload it again. This time it should load.