# Report Query Parameter Error

**URL:** <https://forum.inductiveautomation.com/t/report-query-parameter-error/19382>\
**Category:** Ignition\
**Created:** [August 23, 2018, 2:35pm UTC](https://forum.inductiveautomation.com/t/report-query-parameter-error/19382 "2018-08-23T14:35:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [August 23, 2018, 2:35pm UTC](https://forum.inductiveautomation.com/t/report-query-parameter-error/19382/1 "2018-08-23T14:35:12Z")

</div>

I have several reports that I created that uses a string parameter which is a tag. All the reports worked flawless when I realized I used gateway type tags so if multiple instances of the client are opened there would be tag writing issues, so I recreated the tags to client tags. I changed all parameter tag paths etc and the reports show up perfect in the report viewer. When you go into the Report itself it will not execute any of the queries, it says "WARN: Error Executing query parameter expression “{Parameter}” Any ideas?

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [August 23, 2018, 2:41pm UTC](https://forum.inductiveautomation.com/t/report-query-parameter-error/19382/2 "2018-08-23T14:41:36Z")

</div>

I dragged the parameter to the report to see its value, and it shows up as “N/A”  
I then created a tag in the gateway using a expression to reference the client tag. This does not work. It seems that the error has something to do with reading a client tag in the expression language.

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [August 23, 2018, 5:12pm UTC](https://forum.inductiveautomation.com/t/report-query-parameter-error/19382/3 "2018-08-23T17:12:02Z")

</div>

Can anyone tell me why you can’t read a client tag in expressions, or how it can be done?

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [August 23, 2018, 5:25pm UTC](https://forum.inductiveautomation.com/t/report-query-parameter-error/19382/4 "2018-08-23T17:25:59Z")

</div>

> [@Report DataSet Table](https://forum.inductiveautomation.com/t/report-dataset-table/18408/3):
>
> Reports are executed and built on the gateway, so you don't have access to client tags' values

Just found this ☹

I was using executeAndDistribute, but wasn't passing an overriding parameter to fill in the client tag parameter. Once I filled in that parameter into the function it worked fine. Thanks @KathyApplebaum

> [@Report DataSet Table](https://forum.inductiveautomation.com/t/report-dataset-table/18408/4):
>
> You can't use client tags directly in a report, because reports are generated in the gateway.
> 
> What you'll need to do is use your client tag to override an existing parameter for your report in either the report viewer or through system.report.executeAndDistribute()
