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

Resposta Proposta Non-CRM Report in a Dashboard

  • terça-feira, 15 de maio de 2012 06:42
     
     
    Entrar para Votar
    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


    • Editado Ajay Chawla terça-feira, 15 de maio de 2012 06:43 not using IFrame
    •  
     

Todas as Respostas

  • terça-feira, 15 de maio de 2012 07:41
     
     
    Entrar para Votar
    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

     
  • terça-feira, 15 de maio de 2012 08:03
    Moderador
     
     
    Entrar para Votar
    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


     
  • terça-feira, 15 de maio de 2012 09:07
     
     
    Entrar para Votar
    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

     
  • terça-feira, 15 de maio de 2012 09:35
     
     
    Entrar para Votar
    0

    Hi Ashish,

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

    Thanks

    Ajay Chawla

     
  • terça-feira, 15 de maio de 2012 09:45
     
     
    Entrar para Votar
    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

     
  • terça-feira, 15 de maio de 2012 10:51
     
     
    Entrar para Votar
    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

     
  • terça-feira, 15 de maio de 2012 13:57
    Moderador
     
     Resposta Proposta
    Entrar para Votar
    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