Dynamically Populate SSRS Report Parameter from a field on the CRM Form

• Dennis McGowan

  SSC Enthusiast

  Points: 168

  More actions

  November 12, 2009 at 2:47 pm

  #217612

  I have written a report in SSRS. This report is published in CRM using the Link to Web Page Option.

  This report is available to run from the contact Form. Currently if you select the report, it will bring you to the Report Manager and prompt you for the parameter, say Contactid.

  What I want to accomplish is: once the user selects this report I want to populate that parameter with the ContactId from the form that they are on in CRM.

  Any help would be greatly appreciated.

  Dennis

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  November 13, 2009 at 7:33 am

  #1078925

  I don't know how the CRM Link to Web Page option works because I don't run the CRM product, but if you are specifying the link to the report you can pass in parameter values to a report in a link. See the BOL entry on Passing a Report Parameter within a URL.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question