locked
Errors on Custom Reports in CRM 2011 RRS feed

  • Question

  • I have created some custom reports, when i run the report, sometimes it works just fine and sometimes it has some errors, the error is 'Type' is undefined & 'Sys' is undefined. What is the reason behind this and how could i stop this from happening?
    Danny
    Monday, October 17, 2011 9:22 AM

Answers

  • Hi Guys,

    The issue was with the Reporting Group, someone accidently removed the Reporting Group, added the Reporting Group to the list with a role of Browser for Microsoft CRM.



    Danny
    • Marked as answer by Danny_Archer Thursday, November 24, 2011 7:14 AM
    Thursday, November 24, 2011 7:14 AM

All replies

  • Hi Danny,

    Do the reports always fail for a certain filter (i.e. always failing when running for a particular Account say) or do they randomly fail where you can run the report one minute with an error and the next the report works fine.

    If you provide the following details about the error, am sure someone here will be able to help get to the bottom of things:

      - CRM 4 or 2011

      - Has the custom report being developed using Visual Studio or the Report Wizard in CRM

      - Screen grab of the error message

    At a glance, looks like this could be a problem to do with the SQL Reporting Server but could also be to do with how the SQL of the report has been developed. (sorry, when you add CRM, SQL, Reporting Services and custom developed reports, does give a few 'moving parts' that could be contributing to the error!)


    Kind Regards, Paul | http://crmconsultancy.wordpress.com
    Monday, October 17, 2011 10:14 AM
  • Hi Paul,

    Yes reports are running in CRM 2011, i have developed them in Visual Studio 2008, and error occurs randomly, if i keep pressing refresh it might work after 7-8 times.

     


    Danny
    Monday, October 17, 2011 10:29 AM
  • First thought - could be worth adding 'http://12.129.200.109' to the list of Trusted Sites in Internet Explorer, this will add the CRM Server as a trusted site as this looks to be a Client-side scripting issue.

    Also, do you have the Reporting Data Connector installed on your Reporting Server?


    Kind Regards, Paul | http://crmconsultancy.wordpress.com
    Monday, October 17, 2011 10:35 AM
  • Yes Paul i have SRS Data Connector installed on the reporting server.
    Danny
    Tuesday, October 18, 2011 11:37 AM
  • Hi Danny,

    There is a component which installs onto your CRM Server as part of the MSCRM Install to view reports from your Reporting Server, this component is Report Viewer 2010 and provides the reportviewer.aspx page that presents the reports from the SQL Reporting Server.

    Your problem might be caused by this component in CRM is out of synch version-wise with your Reporting Server, and might be resolved by reinstalling this component, the following thread over on the SQL Forums might be useful:

    http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/e07e3c10-eafb-415c-befa-6775d3d0bd36

    (essentially behind the scenes, I think the Report Viewer Webpage is looking for a set of Jscript libraries and not finding them - hence giving you the xxx is undefined errors)


    Kind Regards, Paul | http://crmconsultancy.wordpress.com
    • Proposed as answer by P McQ Friday, October 21, 2011 11:02 AM
    Tuesday, October 18, 2011 2:44 PM
  • By the way, the download link for the Report Viewer Redistributable is http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=6442

    Definately would be worth trying this in a Dev/Test environment before Production as could freeze users out of reporting whilst installing, or after if anything goes wrong afterwards, as is a bit of guess work based on the error message that this is indeed the cause.


    Kind Regards, Paul | http://crmconsultancy.wordpress.com
    • Proposed as answer by P McQ Friday, October 21, 2011 11:03 AM
    Tuesday, October 18, 2011 2:49 PM
  • I just ran into this issue and what happened was that I had multiple organizations. I created a bunch of users in one org, and didn't assign any security roles. I then stopped using that org, created a new one, created all the users again, and gave them the proper security roles. However, all of the users default organizations were set to the first org that I wasn't using, and never assigned their security roles in. When I tried to use the report viewer it was failing so I began to try and access the individual files it used, and what I noticed was that the users didn't have access to the file ScriptResource.axd because it is a shared resource across all orgs and since they didn't have security roles setup in the first org, which was their default, it was failing.... That was a hard one to explain sort of so please feel free to ask me questions...


    Rick Hopkins
    Wednesday, November 16, 2011 10:02 PM
  • Hi Rick,

    I have only one organization on the deployment server. I did assign proper security role to the user and shared the reports with them. Now when i copy the same report file and deploy it on my Dev env which is a replica of Production env it works just fine. But it doesn't work at all on production even for System Admin Role. Any idea on this? I thought that the production reporting server must be having some issues but i didn't find anything in the event viewer too. This is a hot item and i have no clue what so ever to fix this one. Please let me know if you find anything on this.

    Danny


    Danny
    • Edited by Danny_Archer Thursday, November 17, 2011 7:42 AM mistake
    Thursday, November 17, 2011 5:04 AM
  • Hi Guys,

    The issue was with the Reporting Group, someone accidently removed the Reporting Group, added the Reporting Group to the list with a role of Browser for Microsoft CRM.



    Danny
    • Marked as answer by Danny_Archer Thursday, November 24, 2011 7:14 AM
    Thursday, November 24, 2011 7:14 AM
  • What do you mean by reporting group? And what list did you add them to? Do you have more than one WebServer in your environment hosing CRM?


    Keith Mescha

    Thursday, February 7, 2013 3:30 PM