# Base 64 images in report

**URL:** <https://forum.inductiveautomation.com/t/base-64-images-in-report/49314>\
**Category:** Ignition\
**Created:** [July 28, 2021, 4:52pm UTC](https://forum.inductiveautomation.com/t/base-64-images-in-report/49314 "2021-07-28T16:52:52Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\
**Post date:** [July 28, 2021, 4:52pm UTC](https://forum.inductiveautomation.com/t/base-64-images-in-report/49314/1 "2021-07-28T16:52:52Z")

</div>

I have a perspective view that uses the signature pad component to store signature images in a mysql database. I would like to display these images in a report, but i don’t believe the report image component is able to display base 64 images, is there a way to convert to binary, or another method to accomplish this? Thanks for the help!

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [July 28, 2021, 5:03pm UTC](https://forum.inductiveautomation.com/t/base-64-images-in-report/49314/2 "2021-07-28T17:03:48Z")

</div>

Possibly the [`FROM_BASE64`](https://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_from-base64) MySQL builtin function.

---

<div class="post-metadata">

**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\
**Post date:** [July 28, 2021, 5:44pm UTC](https://forum.inductiveautomation.com/t/base-64-images-in-report/49314/3 "2021-07-28T17:44:53Z")

</div>

I gave that a try, but it doesn’t appear to result in a valid BLOB image. I attempted with and without removing the leading characters “data:image/png;base64,” but neither worked.

---

<div class="post-metadata">

**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\
**Post date:** [July 28, 2021, 10:24pm UTC](https://forum.inductiveautomation.com/t/base-64-images-in-report/49314/4 "2021-07-28T22:24:23Z")

</div>

I couldn’t get this working so instead used this in the signature pad component’s onSignatureSubmitted event to save the file on the gateway:

```auto
event.signatureFile.copyTo(os.path.join('c:\signatures', fn))

```

I then stored the resulting file name in the database, and used the report query to construct the full path and use that as the image components key.

---

<div class="post-metadata">

**Author:** ![fpskoo](https://avatars.discourse-cdn.com/v4/letter/f/9f8e36/32.png) [@fpskoo](https://forum.inductiveautomation.com/u/fpskoo)\
**Post date:** [April 23, 2025, 1:15pm UTC](https://forum.inductiveautomation.com/t/base-64-images-in-report/49314/5 "2025-04-23T13:15:25Z")

</div>

Hello,  
u can make named query with base64Binary, and put it in Key props in report image.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/9/899d976d9d0a520833285592fbbd8ad2ce6ff987.png)