Dynamics CRM‎ > ‎

Add a hyperlink to opportunity in a SSRS Report

When building a SSRS Report of opportunities.  You can add a hyperlink to open the Opportunity in a new CRM window using the Placeholder Property in CRM

You will need the opportunityid field in your dataset.  
Select the desired cell's data in your report table to add your link, then right click and select Placeholder Properties...
Select the Action tab, click the Go To Url action
In the Select URL expression editor paste the following text:

="javascript:void(window.open('https://crm.boydss.com/Boyd/main.aspx?etn=opportunity&pagetype=entityrecord&id=%7b" & CType(Fields!opportunityid.Value, GUID).ToString & "%7d'))"

Save your report.

Michael Plonowski,
Nov 29, 2017, 8:21 AM