Display BLOB Field (Containing Text) in RDLC Report Dynamics NAV

I have the field Note from table Record Link that i want to display in an rdlc report. How can i include it in the dataset to loop into the BLOB field to extract the text value ? Using NAV90

Thanks

Notes are stored as Binary Text. You need to use .NET to read out the value into a string.

From the .NET side of things you'll need:

• BinaryReader from 'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.IO.BinaryReader
• Encoding from 'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Text.Encoding

As for reading the actual BLOB into a string:

RecordLink.Note.CREATEINSTREAM(InStream);
BinaryReader := BinaryReader.BinaryReader(InStream,Encoding.UTF8,FALSE);
MESSAGE('Your note text is %1',BinaryReader.ReadString);