I’m using Ignition 7.9.1 and trying to make a report using the Reporting module that has dynamic product images.
I have some images that I would like to show on the report stored on the Gateway in Image management.
Is there a way to bind the key of an image placeholder of a report to the Gateway Image storage?
I currently have an SQL query that points to the Gateway Images but it doesn’t work.
I create a string like this:
SELECT ‘Product Images/’ + SUBSTRING(SKU,5,3) + ‘.png’ AS ImageKey
The correct variables pass through but I get the following in the Console:
15:39:08.106 [SwingWorker-pool-2-thread-4] WARN reporting.Web - Attempt to get web file at location /Product Images/LIT.png failed.