How to show BLOB on SSRS Report

franciscom

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.

Any ideas will help.

RockWithNAV

Did you tried doing.

Find the exact record of this Table and then

PostedDocumentPictures.CALCFIELDS(Picture);

On SSRS Textbox expression
Convert.ToBase64String(Control.Value);

ppavuk

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