# SQL Reporting

**URL:** <https://forum.inductiveautomation.com/t/sql-reporting/4474>\
**Category:** Ignition\
**Created:** [May 15, 2012, 11:55am UTC](https://forum.inductiveautomation.com/t/sql-reporting/4474 "2012-05-15T11:55:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![DSI600](https://avatars.discourse-cdn.com/v4/letter/d/ad7895/32.png) [@DSI600](https://forum.inductiveautomation.com/u/DSI600)\
**Post date:** [May 15, 2012, 11:55am UTC](https://forum.inductiveautomation.com/t/sql-reporting/4474/1 "2012-05-15T11:55:30Z")

</div>

We are planning on using Ignition for a different option to a “Historian” - They only problem is I see - the customer need the reports on demand and time based to dump from the database to a template excel sheet. I know the reporting module with ignition on dumps to a PDF.

What has some other people done in this case. I found “Navicat Database Admin Tool” - This software looks like it could do what I want and put it in excel. Is there any better options?

Thanks,

---

<div class="post-metadata">

**Author:** ![Greg.Buehler](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\
**Post date:** [May 15, 2012, 1:55pm UTC](https://forum.inductiveautomation.com/t/sql-reporting/4474/2 "2012-05-15T13:55:01Z")

</div>

Check out this: [viewtopic.php?f=88&t=7896](http://www.inductiveautomation.com/forum/viewtopic.php?f=88&t=7896)

---

<div class="post-metadata">

**Author:** ![DSI600](https://avatars.discourse-cdn.com/v4/letter/d/ad7895/32.png) [@DSI600](https://forum.inductiveautomation.com/u/DSI600)\
**Post date:** [May 15, 2012, 9:38pm UTC](https://forum.inductiveautomation.com/t/sql-reporting/4474/3 "2012-05-15T21:38:35Z")

</div>

Then just write a script for the Time based reporting? This looks like it would work thanks.