# Report Viewer datasets and store procedures

**URL:** <https://forum.inductiveautomation.com/t/report-viewer-datasets-and-store-procedures/9544>\
**Category:** General Discussion\
**Created:** [January 14, 2015, 2:06pm UTC](https://forum.inductiveautomation.com/t/report-viewer-datasets-and-store-procedures/9544 "2015-01-14T14:06:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tkelch](https://avatars.discourse-cdn.com/v4/letter/t/ccd318/32.png) [@tkelch](https://forum.inductiveautomation.com/u/tkelch)\
**Post date:** [January 14, 2015, 2:06pm UTC](https://forum.inductiveautomation.com/t/report-viewer-datasets-and-store-procedures/9544/1 "2015-01-14T14:06:52Z")

</div>

Is there anyway to bind a report viewer’s custom property dataset to a store procedure?

I have a store procedure that returns a temporary table and that temp table will need to be displayed in a report. Is there anyway to do this?

---

<div class="post-metadata">

**Author:** ![george](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/george/32/14066_2.png) [@george](https://forum.inductiveautomation.com/u/george)\
**Post date:** [January 16, 2015, 10:04am UTC](https://forum.inductiveautomation.com/t/report-viewer-datasets-and-store-procedures/9544/2 "2015-01-16T10:04:15Z")

</div>

If you go into the binding for the custom property, then select SQL Query as the binding type you can then execute the stored procedure in there?

(i.e. rather than doing “SELECT \* FROM tablename” just write an SQL line to execute the SP)