Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Non-CRM Report in a Dashboard

Proposed Answer Non-CRM Report in a Dashboard

  • Tuesday, 15 May, 2012 6:42 AM
     
     
    Sign In to Vote
    0

    Hi,

    I am using CRM 2011 online. I have a non-CRM report in a SSRS hosted on my local network. I wish to create a dashboard with this report. Is it possible?

    I tried using Report Control for Dashboard. This works fine when CRM is On-Premise. But with CRM ONLINE, while browsing the dashboard, it prompts a javascript error that says " 'Sys' is undefined".

    Also please note that CRM online uses SSL and local SSRS report server does not use SSL.

    Thanks & Regards,

    Ajay Chawla

    Ajay Chawla


    • Edited by Ajay Chawla Tuesday, 15 May, 2012 6:43 AM not using IFrame
    •  
     

All Replies

  • Tuesday, 15 May, 2012 7:41 AM
     
     
    Sign In to Vote
    0

    Hi,

    Check whether the required security roles are assigned. Verify that you have same security roles or privileges are given on the on premises and online.

    I hope this helps. If my response answered your question, please mark the response as an answer and also vote as helpful.

    Ashish Mahajan, CRM Developer, CSG (Melbourne)
    My Personal Website: http://www.ashishmahajan.com
    My Blogs: http://ashishmahajancrm.blogspot.com.au and http://ashishmahajancrm.wordpress.com
    My Youtube Channel: http://www.youtube.com/user/ashishmahajanmscrm

    My Linkedin: View Ashish Mahajan's profile on LinkedIn
    My Twitter: https://twitter.com/#!/ashishmahajan74

     
  • Tuesday, 15 May, 2012 8:03 AM
    Moderator
     
     
    Sign In to Vote
    0

    I would expect that this could wokr, if the report server url is accessible from the client. I'd first check your IE settings to see if you're allowing mixed (HTTP and HTTPS) content

    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk


     
  • Tuesday, 15 May, 2012 9:07 AM
     
     
    Sign In to Vote
    0

    Hi David,

    Yes, I have ensured that IE allows mixed content.

    I have configured SSRS installed on network to use SSL. Now a report (hosted on local network) gets rendered in CRM dashboard online. But drill down feature does not work. After rendering it prompts me with a javascript error shown below:

    Webpage error details
    User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; GTB7.3; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; .NET4.0C; .NET4.0E)
    Timestamp: Tue, 15 May 2012 08:40:36 UTC

    Message: Access is denied.

    Line: 33
    Char: 5
    Code: 0
    URI: https://technology.crm.dynamics.com/%7B634726574610000000%7D/WebResources/msdyn_ReportControl?data=DB683971-509E-E111-9A4C-3C4A92DBC837

    Thanks

    Ajay Chawla

     
  • Tuesday, 15 May, 2012 9:35 AM
     
     
    Sign In to Vote
    0

    Hi Ashish,

    I am not sure about which security roles that are distinguished as On-Premise and Online for reports.

    Thanks

    Ajay Chawla

     
  • Tuesday, 15 May, 2012 9:45 AM
     
     
    Sign In to Vote
    0

    Hi Ajay,

    I just wanted to make sure whether the required security roles are given to the user. If you have same security roles with same privileges on both the environments (online an on premises) then you can rule out security roles.

    You mentioned above that the drill down doesn't work. After drill down, the data is on the same report or in a sub-report. If it is in a sub-report, then see whether you have defined the parent report in the properties of the child report.

    Ashish Mahajan, CRM Developer, CSG (Melbourne)
    My Personal Website: http://www.ashishmahajan.com
    My Blogs: http://ashishmahajancrm.blogspot.com.au and http://ashishmahajancrm.wordpress.com
    My Youtube Channel: http://www.youtube.com/user/ashishmahajanmscrm

    My Linkedin: View Ashish Mahajan's profile on LinkedIn
    My Twitter: https://twitter.com/#!/ashishmahajan74

     
  • Tuesday, 15 May, 2012 10:51 AM
     
     
    Sign In to Vote
    0

    Hi Ashish,

    The drill down works fine when I browse the report from Reports section. When I use the report via dashboard, it prompts me with the error shown below:

    Webpage error details
    User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; GTB7.3; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; .NET4.0C; .NET4.0E)
    Timestamp: Tue, 15 May 2012 08:40:36 UTC

    Message: Access is denied.

    Line: 33
    Char: 5
    Code: 0
    URI: https://technology.crm.dynamics.com/%7B634726574610000000%7D/WebResources/msdyn_ReportControl?data=DB683971-509E-E111-9A4C-3C4A92DBC837


    Ajay Chawla

     
  • Tuesday, 15 May, 2012 1:57 PM
    Moderator
     
     Proposed Answer
    Sign In to Vote
    0

    Hi Ajaym

    The solution does not work in CRM Online because it uses unsupported customizations. If you want to make it work, you'd have to fix it: Go to Settings --> Customizations --> Customize the system --> Web resources and open the msdyn_ReportControl web resource. Then in the "source" tab you need to remove the function "ShowFrame" and remove references to that function in the code. Save & publish.

    Now it should work ;-)

    Gonzalo | gonzaloruizcrm.blogspot.com