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

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

SSRS Report with Hyperlinks to CRM Records

(0) ShareShare
ReportReport
Posted on by

I have built an SSRS report that I added hyperlinks to CRM records. I created the parameter CRM_URL with the org URL (myorg/.../main.aspx). From the placeholder properties, under the Action-->Go to URL, I added the expression (=Parameters!CRM_URL.Value & "etc=2&extraqs=&histKey=552288729&id={" & Fields!new_contactid.Value.ToString() & "}&newWindow=true&pagetype=entityrecord#38642313"). From Visual Studio, this works as expected; directs me to the expected record in CRM.  I added the report to CRM by creating a new report, select Existing File for the Report Type, save the report then run it. When I clicked on the hyperlink, it directs me to https://myorg/myorg-dev/CRMReports/viewer/drillopen.aspxetc=2&extraqs=&histKey=552288729&id=%7Be477687d-1841-e711-8141-005052931fe1%7D&newWindow=true&pagetype=entityrecord#38642313. Why is the CRMReports/viewer/drillopen.aspx being added to the URL? Why is this happening? How can I correct it? Is there another way to add the link?

Any help would be greatly appreciated.

Thank you,
Chrys

*This post is locked for comments

I have the same question (0)
  • Verified answer
    a33ik Profile Picture
    84,331 Most Valuable Professional on at
    RE: SSRS Report with Hyperlinks to CRM Records

    Hello,

    This is how it works in CRM. I would recommend follow instructions mentioned here if you want your functionality work - technet.microsoft.com/.../dn531150.aspx

  • ChrysDW Profile Picture
    on at
    RE: SSRS Report with Hyperlinks to CRM Records

    Thank you Andrew, that did work for me.

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#2
ED-30091530-0 Profile Picture

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans