Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Answered

Dynamic Hyperlink in SSRS 2008 for CRM 2011

Posted on by 3,155 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?

  • Verified answer
    Charan Raju C R Profile Picture
    Charan Raju C R 3,155 Moderator on at
    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 Profile Picture
    jlattimer 24,556 on at
    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)

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,349 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,212 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans