After upgrading from sql2008 to sql2014, the code-behind of the rdl report used to convert RTF to Text was failing and displaying #Error instead of the converted text. There are numerous reasons this can happen, but for me, it was an obscure setting in the rssrvpolicy.config file that was causing it.
The code-behind: The highlighted line of code crashes
Public Shared Function ConvertRtfToText(ByVal input As String) As String
Dim returnValue As String = String.Empty
Dim converter As New System.Windows.Forms.RichTextBox()
converter.Rtf = input.Trim
returnValue = converter.Text
Return returnValue
End Function
The fix:
Change the PersmissionSetName from Nothing to FullTrust for the FirstMatchCodeGroup as follows:
<CodeGroup class=”FirstMatchCodeGroup” version=”1″ PermissionSetName=”FullTrust“>