SQL Query Report contains Columns which are of Image Attachments Data Type hence not VIEWABLE

[NCP]

image view is not possible in any report view but maybe, clickable is possible.

Please check the example, here we make clickable link for image.

SELECT 
    name, 
    CONCAT('<a href="', image, '" target="_blank">', image, '</a>') AS 'Image::500'
FROM 
    `tabItem`