Reports with BLOBS

[benjax911]

I am not the best with SQL, but I learn fast. I have been working on a report to generate a printable report with a contact's information as well as their picture.
I have two tables:
_contact
_contact_img

I have a query in my report to generate the contact's name concatenated, dates, serial bar code, etc.

The image table contains it's own PK and a field for the _contact PK, and two images - before and after, stored as a long blob.

I have sweated feverishly to solve getting the image to display in the picture box from the toolbox of the report editor. I have the image return as expr1 due to ifnull(after_pic, before_pic). Many thanks for anyone willing to shed some light on this.

Thanks

[benjax911]

UPDATE...
My mistake. I used and auto cropping batch utility for my pics which showed fine in the windows system and imaging software but was corrupt in dbforge studio. I simply re-exported each image from gimp and viola; blob returns wonderfully into a report.

This software is amazing!!
Thanks

[alexa]

Please let us know if any questions arise.