通过

Help! A new CRM report....

  • 项目

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.

Comments

  • Anonymous
    May 23, 2006
    Followed your instructions under 2003 and still get the error. Interestingly it did not have use share datasource ticked (even though it did previously use a shared data source).
    Is there any way to edit the rdl file manually (since it is xml) or anything else you can recommend?

  • Anonymous
    May 23, 2006
    The comment has been removed

  • Anonymous
    June 27, 2006
    Robert,

    Your solution is described here:
    http://ronaldlemmen.blogspot.com/2006/06/crmexception-exception-of-type.html

  • Anonymous
    October 03, 2006
    hi dear all! i have been developing MSCRM for 8 months. Maybe it's too long for you. but i'm not good experienced programmer. i did one report on visual studio 2003 and i uploaded that rdl file to my CRM report server. But there is one problem. i don't know how to fix it. that problem is i can see my report only on server computer by crm or report server. but i can't see it from other computers, by crm or report server. i hope some one will help me. :D

  • Anonymous
    January 04, 2007
    The comment has been removed

  • Anonymous
    January 11, 2007
    It worked for me! I was a bit frustrated, but then I found this post. I am using Visual Studio 2003. Thanks!

  • Anonymous
    January 11, 2007
    I hope you can smile again Michael :)

  • Anonymous
    May 01, 2007
    Your suggestion worked perfectly. Thanks a lot.

  • Anonymous
    May 23, 2007
    The comment has been removed

  • Anonymous
    May 24, 2007
    The comment has been removed

  • Anonymous
    July 06, 2007
    The comment has been removed

  • Anonymous
    July 26, 2007
    I’m noticing a very peculiar Reporting Services error with several CRM 3.0 Pro installations.  This doesn’t seem to happen to the Small Business version.  After installation, the Domain Admin can see the CRM reports fine but no other CRM users.   It’s probably a permission problem, but I haven’t have time to chase it down yet.  I did a quick comparison between the Pro and SB version but didn’t see any obvious differences with the Reporting Services permission.  I’ll have to bring it up the next I talk with a Microsoft CRM support engineer.  Anyone came across this problem?

  • Anonymous
    August 07, 2007
    You might also want to check out the following post: http://blogs.msdn.com/mscrmfreak/archive/2007/08/07/error-0x80048298.aspx

  • Anonymous
    August 15, 2007
    The comment has been removed

  • Anonymous
    August 17, 2007
    The comment has been removed

  • Anonymous
    August 17, 2007
    The comment has been removed

  • Anonymous
    August 21, 2007
    mennotk - Your solution of adding CRM server to the roles in report manager worked perfectly.  Not sure how this got changed over the weekend but it is back to working and the world is right again... or atleast the CRM part of it.

  • Anonymous
    August 23, 2007
    I am looking for assistance as I am an extreme novice with CRM.  I just started using the program and made my first rookie mistake.  I imported all of our contact data in under contacts; including both Leads and current Customers.  Now I need to separate the two.  Is there a way to do this with out having to export the Leads and then import them back into the program in their proper location?

  • Anonymous
    September 06, 2007
    The comment has been removed

  • Anonymous
    September 06, 2007
    Mike, please take a look at this post: http://blogs.msdn.com/mscrmfreak/archive/2007/08/07/error-0x80048298.aspx This should solve your problem!

  • Anonymous
    October 02, 2007
    Hi all, I'm new in CRM Report developer.I've try to publish my custom report(MyReport.rdl) to the crm server. I did folow step. 1.Setup Reporting Service on my local machince(in the same domain as CRM Server). 2.Create report in VS Studio 2005 and save to MyReport.rdl 3.Copy report.rdl to CRM Server as crm folder(CRMServerNamec:Program FilesMicrosoft CRMReportsMSCRM) 4.Open Microsoft CRM, and in theWorkplace pane, under My Work, click Reports. 5.Click New, click Browse, and then browse to the CRM Reports project on CRMServerNamec:Program FilesMicrosoft CRMReportsMSCRMMyReport.rdl file. 6.When I clicked Save and Close I met error message "Error uploading Report. An error occurred while trying to add the report to Microsoft CRM. Try adding the report again. If this problem continues, contact your system administrator." I notice that when I copy existing report from Microsoft CRM and change the report name to another.I can added the report to CRM. But if i made change on that report I can't add that report to CRM. Anybody can helpme what should i do to fix this problem? Thank you for advance, Rath:Avanade,Thailand

  • Anonymous
    November 28, 2007
    Thanks!  Worked for me (very noob when it comes to CRM & SRS).  Now . . . . how to figure out making the report filter for account when it is opened from the account object . . . time for more searching . . .

  • Anonymous
    February 03, 2008
    The "real" key to this is that the database name on your dev environment must be the same database name as that on your testing and live environment.  For example, I have a database called CRM_Data on my dev (local) machine but my testing environment has a database called CRM_Test_Data, and my live working environment has one called CRM_Live_Data.  No matter what I did with datasource it didn't work until I had unified my database names, they are now called CRM_Data on all environments and the above solution works perfectly.

  • Anonymous
    June 08, 2009
    PingBack from http://insomniacuresite.info/story.php?id=7969