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

  • Question

  • 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

  • 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
  • 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