none
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.

    http://blogs.msdn.com/b/chrisfie/archive/2008/06/04/how-to-display-microsoft-project-task-s-notes-field-in-a-report.aspx

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

    http://www.jasonstrate.com/2010/06/displaying-microsoft-project-tasks-notes-in-ssrs-2008/

    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

    Try
    s.length = 0

    For i = 0 To b.Length – 1
    If i <> b.Length – 1 Then
    s.Append(chr(b(i)))
    End If
    Next

    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

    Error:

    • 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 http://go.microsoft.com/fwlink/?LinkID=155570 for more information.'.’.
    Monday, September 17, 2012 5:28 AM