I am facing a problem when I need to populate some pictures out of table (Posted Document Pictures Entry). I am using a vertical call LinkFresh. On NAV field is setup as BLOB but on SQL it is defined as Image.
The blob in NAV is compressed with nav proprietary algorithm (variation of ZIP). So you can't read it from SQL. But, you can change 'Compressed' property of your blob field to No inside NAV and then you must be fine...
Answers
Find the exact record of this Table and then
PostedDocumentPictures.CALCFIELDS(Picture);
On SSRS Textbox expression
Convert.ToBase64String(Control.Value);
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/