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

Notifications

Announcements

No record found.

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

    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

    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…

Neeraj Kumar – Community Spotlight

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

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