Link to a record in CRM from SSRS report

Hi All, I have develped a simple report in SSRS, I would like to link to the record in CRM from SSRS.

Example:

Report looks like

Id Name

-

001 ABS Co.

If I click on ABS Co. it should take me the record details of ABS Co. in CRM.

Please help

Hi,

you′ve to add the AccountId to your reportdataset. Using the field AccountId you can build up the following link for the action property (Jump to URL) of the field:

="http://CRMSERVER/sfa/accts/edit.aspx?id={" & Fields!AccountId.Value.ToString() & "}"

Best regards