Displaying Microsoft Project Task’s Notes in SSRS 2008 RRS feed

  • Question

  • I have followed this thread to display the TASK_RTF_NOTES in a report.

    However this  doesn't work and expression gives "n/a" only. To resolve the issue i find this blog

    The code behind the report is    

    ‘Instantiate a stringbuilder object
    Public s As New System.Text.StringBuilder()

    Public Function byteArrayToString(ByVal b() As Byte) As String
    Dim i As Integer
    dim mystr as string

    s.length = 0

    For i = 0 To b.Length – 1
    If i <> b.Length – 1 Then
    End If

    mystr = left(s.ToString, len(s.ToString)-1)

    return ConvertRtfToTextRegex(mystr)
    Catch ex as exception
    return ex.tostring()
    s.length = 0
    End Try
    End Function

    Public Function ConvertRtfToTextRegex(ByVal input As String) As String
    Dim returnValue As String = String.Empty
    returnValue = System.Text.RegularExpressions.Regex.Replace(input, "\{\*?\\[^{}]+}|[{}]|\\\n?[A-Za-z]+\n?(?:-?\d+)?[ ]?", "")
    Return returnValue
    End Function


    • An error occurred during local report processing.
      • The definition of the report 'Report3.rdlc' is invalid.
        • An unexpected error occurred while compiling expressions. Native compiler return value: ‘[BC40000] 'RequestMinimum' is obsolete: 'Assembly level declarative security is obsolete and is no longer enforced by the CLR by default. See for more information.'.’.
    Monday, September 17, 2012 5:28 AM