# Report Table Select as Parameter in Report

**URL:** <https://forum.inductiveautomation.com/t/report-table-select-as-parameter-in-report/31752>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [January 30, 2020, 10:33am UTC](https://forum.inductiveautomation.com/t/report-table-select-as-parameter-in-report/31752 "2020-01-30T10:33:31Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![iottest07](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/iottest07/32/17393_2.png) [@iottest07](https://forum.inductiveautomation.com/u/iottest07)\
**Post date:** [January 30, 2020, 10:33am UTC](https://forum.inductiveautomation.com/t/report-table-select-as-parameter-in-report/31752/1 "2020-01-30T10:33:31Z")

</div>

Hii all

I want to select Report Table from Viewer and than Report Show.

Here is Simple script:-

SELECT \* FROM ?  
where t\_stamp between ? and ?  
order by t\_stamp asc

Its Given Error for Syntax please guide me for this.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [January 30, 2020, 12:39pm UTC](https://forum.inductiveautomation.com/t/report-table-select-as-parameter-in-report/31752/2 "2020-01-30T12:39:36Z")

</div>

Question-mark substitution (secure substitution by the JDBC driver) cannot work on SQL structure, just values. So the first question mark in your query is not allowed. You may be able to use curly-brace substitution for that part, but be aware that this is a security hole in your application.

---

<div class="post-metadata">

**Author:** ![iottest07](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/iottest07/32/17393_2.png) [@iottest07](https://forum.inductiveautomation.com/u/iottest07)\
**Post date:** [January 31, 2020, 4:58am UTC](https://forum.inductiveautomation.com/t/report-table-select-as-parameter-in-report/31752/3 "2020-01-31T04:58:55Z")

</div>

> [@pturmel](#):
>
> stitution for that part, but be aware that this is a security hole in your application.

hii

I am try to used curly-brace but same error through.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [January 31, 2020, 12:13pm UTC](https://forum.inductiveautomation.com/t/report-table-select-as-parameter-in-report/31752/4 "2020-01-31T12:13:23Z")

</div>

Please show the “full” error report.