web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Dynamic Hyperlink in S...
Microsoft Dynamics CRM (Archived)

Dynamic Hyperlink in SSRS 2008 for CRM 2011

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Suggested answer
    jlattimer Profile Picture
    jlattimer 24,562 on at

    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)

  • Verified answer
    Charan Raju C R Profile Picture
    Charan Raju C R 7 Moderator on at

    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"

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans