How To Show BLOB Image in iReport And SpagoBI?

1. Add the BLOB field to your report’s sql.

2. In the Report Inspector, expand Fields, find BLOB field and change Field Class as java.io.InputStream.

3. Open Palette(Ctrl+Shift+8) and drag&drop image element to place where you want to display.

4. Finally set the below settings in the $F{FIELD_NAME} properties;
Image Expression: $F{FIELD_NAME}
Expression Class: java.io.InputStream

Note: There is no need anything to display image in SpagoBI.