Dynamic Hyperlink in SSRS 2008 for CRM 2011

(0) Share

Report

Posted on by Charan Raju C R

7 Moderator

I have created one report using SSRS 2008 for CRM 2011 records. Here my requirement is to create an hyperlink for Name column in that table and it has to open that record in CRM.

Eg: For the Account records table, we have a 'Name' column. On click of Name field, it has to open that particular Account record just like subgrid records in CRM.

How can we achieve this in SSRS reports?

*This post is locked for comments

All responses (2)

Answers (1)

Verified answer

Charan Raju C R 7 Moderator on at

Like (0)

Report

RE: Dynamic Hyperlink in SSRS 2008 for CRM 2011

But it has to be dynamic to pick up the current Organization URL. So, below will be useful.

Add CRM_URL parameter to your report parameters list, make it hidden. Then add action to the name column field from the text box properties: go to Text Box Properties->Actions->Go to URL ->add an expression. Here is the example of the expression you should use: =Parameters!CRM_URL.Value & "?ID={"&Fields!accountid.Value.ToString()&"}&LogicalName=account"
Suggested answer

jlattimer 24,558 on at

Like (0)

Report

RE: Dynamic Hyperlink in SSRS 2008 for CRM 2011

Right click on the table cell for the name field and select Text Box Properties -> Action -> Go to URL

Here you'll have the option to create and Expression - enter the URL and substitute the data set field for the record GUID.

Like: ="https://YourCRM.crm.dynamics.com/main.aspx?etc=1&extraqs=%3f_gridType%3d1%26etc%3d1%26id%3d%257b" + Fields!accountid.Value + "%257d%26pagemode%3diframe%26preloadcache%3d1368622508605%26rskey%3d582517150&pagetype=entityrecord"

Add a Hyperlink to a URL (Report Builder and SSRS)