Pictures can be queried from a relational database if they are image data collected as a BLOB data type and stored as a binary unit in the database management system with ODBC connections. BLOB image files available to include: .JPEG, .BMP, .GIF, and .PNG image formats. Pictures can be dragged and dropped from a query table to the request line, displayed as strings in columns in the Results and Table sections, or shown graphically in the bands of the Report section. Dashboard developers can select images from results sets, not just static images from the file system.
The following restrictions apply to BLOB images in Interactive Reporting:
The ODBC connection must use a server-defined join
It is not possible to determine the data type of an image in advance
See also: