Solve the case, so I will share with screenshots, maybe it will be useful for someone. For the base script thanks to EXPERT @josecgomez
So you need:
-
Create BAQ:
-
Create empty calculated field as NVARCHAR
3.Make baq updatable, go to advaced BPM section, on GetList create PostProcessing and add custom code:
foreach(var y in result.Results) //UBAQ results
{
var arr= (from x in Db.FileStore.With(LockHint.NoLock) where x.FileName == y.Part_ImageID && x.Company == y.Part_Company select x.Content).FirstOrDefault(); //Get image content
if(arr!=null)
y.Calculated_calc = Convert.ToBase64String(arr); //Convert content to string
}
4.if you test baq you shoud see that calculated field empty but it actualy carries hudge data, you can check that by copying in like MSWord
-
then create your BAQ report and on SSRS add immage and set fields:
-
and thats it, the result is: