Is there a way to print a Part Image on a SSRS Report

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:

  1. Create BAQ:
    image
    image

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

  1. then create your BAQ report and on SSRS add immage and set fields:

  2. and thats it, the result is:

6 Likes