# Report Table Parameters? **URL:** \ **Category:** Ignition\ **Created:** [May 20, 2024, 3:44pm UTC](https://forum.inductiveautomation.com/t/report-table-parameters/90628 "2024-05-20T15:44:53Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![CB123](https://avatars.discourse-cdn.com/v4/letter/c/f05b48/32.png) [@CB123](https://forum.inductiveautomation.com/u/CB123)\ **Post date:** [May 20, 2024, 3:44pm UTC](https://forum.inductiveautomation.com/t/report-table-parameters/90628/1 "2024-05-20T15:44:53Z")
My Named Query works, three parameters (default start and end parameters and a string parameter). This all works fine as tested in the named query browser, but I would like to have multiple tables each passing a different string parameter to that one named query. Is this possible? I would imagine through scripting instead of a named query but I'm an SQL guy so I'm stuck in my ways. ---
**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:** [May 20, 2024, 3:51pm UTC](https://forum.inductiveautomation.com/t/report-table-parameters/90628/2 "2024-05-20T15:51:36Z")
You can use a Query String parameter (uses curly braces instead of a colon prefix) instead of a Value parameter. But be aware that if your table name comes from client input, you have opened a huge security hole (aka "SQL Injection"). ---
**Author:** ![CB123](https://avatars.discourse-cdn.com/v4/letter/c/f05b48/32.png) [@CB123](https://forum.inductiveautomation.com/u/CB123)\ **Post date:** [May 20, 2024, 3:56pm UTC](https://forum.inductiveautomation.com/t/report-table-parameters/90628/3 "2024-05-20T15:56:46Z")
Yep I have it set up now as a QueryString parameter, and that works (in the Named Query browser). But that's report-wide as I see it is it not? I want to adjust the value of that parameter for separate tables within that report. Basically every table would be "hardcoded" with a different string. This will be an automated report, no client interaction whatsoever but I hear you on the SQL injection concerns. Thank you! ---
**Author:** ![CB123](https://avatars.discourse-cdn.com/v4/letter/c/f05b48/32.png) [@CB123](https://forum.inductiveautomation.com/u/CB123)\ **Post date:** [May 20, 2024, 4:01pm UTC](https://forum.inductiveautomation.com/t/report-table-parameters/90628/4 "2024-05-20T16:01:28Z")
And to clarify, I know what I want to do can be done by eliminating that parameter and using separate Named Queries with those strings "hardcoded". I'm just trying to find best practice for this and I would think one parameterized query would be it. ---
**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:** [May 20, 2024, 4:02pm UTC](https://forum.inductiveautomation.com/t/report-table-parameters/90628/5 "2024-05-20T16:02:18Z")
> [@CB123](#): > > But that's report-wide as I see it is it not? No, you should be able to set it separately for each query binding in the report. ---
**Author:** ![CB123](https://avatars.discourse-cdn.com/v4/letter/c/f05b48/32.png) [@CB123](https://forum.inductiveautomation.com/u/CB123)\ **Post date:** [May 20, 2024, 4:16pm UTC](https://forum.inductiveautomation.com/t/report-table-parameters/90628/6 "2024-05-20T16:16:15Z")
I think that's where my disconnect is. I don't even see "bindings" like I would see in the Perspective module. I see where my table needs the "Data Key" which I have pointed to what it is for that Query Data Source. But I see nowhere in the table Property Inspector to define the parameter value. I know it must be pilot error on my part. ---
**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:** [May 20, 2024, 4:26pm UTC](https://forum.inductiveautomation.com/t/report-table-parameters/90628/7 "2024-05-20T16:26:30Z")
It isn't in the property inspector. It in the data sources tab. You will need a separate data source (key) for each table. The parameters for your NQ are provided on the data sources tab. ---
**Author:** ![CB123](https://avatars.discourse-cdn.com/v4/letter/c/f05b48/32.png) [@CB123](https://forum.inductiveautomation.com/u/CB123)\ **Post date:** [May 20, 2024, 5:55pm UTC](https://forum.inductiveautomation.com/t/report-table-parameters/90628/8 "2024-05-20T17:55:16Z")
Thanks, got that part. Now off to figure out how to not get tables to collide. Coming from the Iconics ecosystem, I won't say this is worse or better, but I will say it's different.