Tuesday, June 12, 2012

Why my navigation control isn't clickable?

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

Select
Cast(accountid as VarChar(36)) Id
From FilteredAccount


2. Use ToString for Value in your navigation formula:

=Parameters!CRM_URL.Value & "?ID=" & Fields!Id.Value.ToString() & "&LogicalName=account"