CRM 4.0 SSRS Report hyperlinks with ObjectIds

I needed to build a report with hyperlink actions. The hyperlink needed to have the account id passed to the url. The SQL query I used for the dataset was:
SELECT name, accountid FROM account

I then went to the Properties of the Chart field that will contain the hyperlink and clicked the Action tab and selected Jump to URL. The value for the URL was
="http://localhost/CRM/sfa/accts/edit.aspx?id={" & Fields!accountid.Value & "}#"

This resulted in the following warning on previewing the report and caused the hyperlink to not work.
[[rsRuntimeErrorInExpression] The Hyperlink expression for the chart ‘ProjectStatusReports.DataPoint.ActionInfo.Action’ contains an error: Operator '&' is not defined for string http://localhost/CRM/sfa and type 'Guid'.
Preview complete -- 0 errors, 1 warnings

The issue is that I was trying to pass a GUID type value when I needed a string. To resolve this, I altered my SQL query to return the accountid as a string by using the CAST function. Here is the new query in the dataset.
SELECT name, CAST(accountid as char(36)) as acctid FROM account

After making that change, I updated the hyperlink expression to read
="http://localhost/CRM/sfa/accts/edit.aspx?id={" & Fields!acctid.Value & "}#"

That solved the issue with the GUID.

Comments

[Jevgenij]

You can also use Fields!accountid.Value.ToString()

[Michael Dodd]

You can also use SRS's .ToString() in the report designer, which will accomplish the same thing.
...Fields!AccountId.Value.ToString()
--MD

[léo]

use crm_url