Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 2011 On Premise - Execute External SSRS Report RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    We have a report on an SSRS server linked to an external (non CRM) system. This external system contains similar data to our CRM  - Example - Account IDs .  Is there a way in CRM to have a particular record open (ex account) and have a link or button that executes the same report on the same SSRS server in the same way the external system is capable of.  Note this SSRS server is separate from the SSRS server used to house normal CRM related reports.

    Rob

    Tuesday, April 11, 2017 6:34 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    If the external report has a defined parameter (e.g. AccountID) that you can pass, and you have that AccountID stored in CRM, then you open the external report from a ribbon button, and pass the parameter value using SSRS url access

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

    Wednesday, April 12, 2017 8:36 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks

    I can open the report but the one parameter I require (which is a field value in CRM) only works if I hard code the value.

    If I get the value from the entity form into a variable and try to pass that variable in the ssrs url it takes the variable name literally and not the value.

    Rob

    Thursday, April 13, 2017 11:49 AM