Just imagine... You are developing report for CRM which should allow you to open records of CRM from report. You have done everything in accordance to SDK - http://technet.microsoft.com/en-us/library/gg309480 but... navigation item doesn't work.
I had this issue today. I noticed that during testing VS shown me following message:
The Hyperlink expression for the text box ‘censored’ contains an error: Operator '&' is not defined for string "censored" and type 'Guid'
So to solve this issue and make your item clickable you have 2 ways out:
1. Use in your select statement cast like
Cast(accountid as VarChar(36)) Id
2. Use ToString for Value in your navigation formula:
=Parameters!CRM_URL.Value & "?ID=" & Fields!Id.Value.ToString() & "&LogicalName=account"