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?
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"
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"
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,349
Super User 2024 Season 2
#2
Martin Dráb
228,212
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (