KB14226: How to display a .JPG or .GIF image as an attribute element in a report in MicroStrategy

Older versions of Strategy Web do not support blob data type to be an attribute form. However, there is a way to display images as attribute elements in a report in Strategy Web and Library. Refer to the following Strategy Knowledge Base technical note for more information about this limitation:
KB7704 - How to display Oracle database image in MicroStrategy Web 9.x
This article includes more detailed steps to implement the workaround using the following simple example:
 

• Create a table with a column with the following SQL:
  CREATE TABLE ImageTest (Image VARCHAR2(200))
  
• NOTE: Oracle Database syntax is used as an example. Consult the DBA for database specific syntax to create table.
   
  
• Populate a column with a value of URL with the following SQL:
  INSERT INTO ImageTest Image VALUES ('https://<webserver_name>:8443/MicroStrategy/images/airport/Paris.jpg');
   
  
• Save an image on the Web Server machine. For this example, C:\Program Files (x86)\Common Files\Strategy\Tomcat\apache-tomcat-9.0.83\webapps\Strategy\images\airport\Paris.jpg:
  

• Bring the table into the project, as shown below via Warehouse Catalog:
  

• Create an attribute with column name 'Image' as an expression and data type 'Picture', as shown below:
  

• Create a report with this attribute and execute in Strategy Web:
  

• Same works in Strategy Library:
  

• NOTE: The string of the path to the image is shown instead of the image itself when the same report is executed through Strategy Developer, as shown below: