question: how to link from MS CRM 3.0 a CRM parameter driven SSRS report ?

• Franky Leeuwerck

  SSCrazy

  Points: 2036

  More actions

  October 5, 2007 at 7:32 am

  #179897

  Dear,

  I managed to define a report in MS CRM that opened up a customized MS Reporting Server report by using a weblink in the CRM report definition form, something like this :

  http://myServer/reportserver?/myReportPath/myReport/&rs:Command=Render&parmAccount=myAccountString

  So far so good, clicking the report in MS CRM, nicely runs the ReportingServer report.

  Now, I want to run this report from an account selected in the CRM Account list view.

  How can I pass the corresponding AccountID to the report ?

  Thanks in advance for any idea's.

  Franky

  FYI, I'm unfamiliar with MS CRM, so I don't know if it is possible to realize what I'm asking for.

  Franky L.

• Franky Leeuwerck

  SSCrazy

  Points: 2036

  More actions

  October 8, 2007 at 5:25 am

  #739942

  Dear,

  In the mean time, I found the solution.

  It is mentioned here :

  http://www.microsoft.com/dynamics/crm/using/customizing/reporttutorial.mspx

  Carefull, you should use an unshared datasource in your report definition. This can be defined at the report's dataset level, not at the BI project level.

  Regards,

  Franky

  Franky L.