# Retrieve Image from sql server database to ignition report?

**URL:** <https://forum.inductiveautomation.com/t/retrieve-image-from-sql-server-database-to-ignition-report/24408>\
**Category:** Ignition\
**Tags:** ignition79, database, scripting\
**Created:** [April 25, 2019, 7:25pm UTC](https://forum.inductiveautomation.com/t/retrieve-image-from-sql-server-database-to-ignition-report/24408 "2019-04-25T19:25:12Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bluemonkey136](https://avatars.discourse-cdn.com/v4/letter/b/71e660/32.png) [@Bluemonkey136](https://forum.inductiveautomation.com/u/Bluemonkey136)\
**Post date:** [April 25, 2019, 7:25pm UTC](https://forum.inductiveautomation.com/t/retrieve-image-from-sql-server-database-to-ignition-report/24408/1 "2019-04-25T19:25:12Z")

</div>

I am trying to make a project that has a few forms to input data and an image. Then create a page to generate a report/“process guide” based on the ID of the data. The image files will be associated with the “Steps” that appear similar to a table on this report.

I have seen some examples with this using python online, but was wondering if anyone had some advice or insight on a better method for this in Ignition?

Database Tables:  
ProcessGuides  
Steps

Each guide has many steps. Each step has on guide.

Each step has an optional associated image. I would like to image to populate when calling upon this step in a report.