# Use of parameters in report queries

**URL:** <https://forum.inductiveautomation.com/t/use-of-parameters-in-report-queries/52362>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [October 26, 2021, 7:49pm UTC](https://forum.inductiveautomation.com/t/use-of-parameters-in-report-queries/52362 "2021-10-26T19:49:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Footuck](https://avatars.discourse-cdn.com/v4/letter/f/ad7895/32.png) [@Footuck](https://forum.inductiveautomation.com/u/Footuck)\
**Post date:** [October 26, 2021, 7:49pm UTC](https://forum.inductiveautomation.com/t/use-of-parameters-in-report-queries/52362/1 "2021-10-26T19:49:26Z")

</div>

When attempting to use a runtime parameter in a Perspective report, I’m expecting to be asked to provide a parameter value when I run the report, but I’m not.  
I have created the parameter in the report Data tab and given it a valid default value of string data type.  
I have embedded the parameter in the Where Clause of the reports Basic SQL Query as  
worktype = ‘{WorkType}’  
The report uses the parameters default value and runs fine. I need to know how to prompt a report user to provide the parameter value when they run the report from a Perspective web page.

---

<div class="post-metadata">

**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\
**Post date:** [October 26, 2021, 7:52pm UTC](https://forum.inductiveautomation.com/t/use-of-parameters-in-report-queries/52362/2 "2021-10-26T19:52:06Z")

</div>

I struggled with this having designed reports using crystal reports for years. You need a component on your perspective page where the user can input the parameter value, and bind that to the report parameter.  
Here is an example:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/b/ebc61ed50714b6a0f72d4901a506596327b32437.png)

---

<div class="post-metadata">

**Author:** ![Footuck](https://avatars.discourse-cdn.com/v4/letter/f/ad7895/32.png) [@Footuck](https://forum.inductiveautomation.com/u/Footuck)\
**Post date:** [October 26, 2021, 7:55pm UTC](https://forum.inductiveautomation.com/t/use-of-parameters-in-report-queries/52362/3 "2021-10-26T19:55:22Z")

</div>

Yes, as in Crystal and BIRT reports. Thanks.