Use of parameters in report queries

Ignition
1

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.

2

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
image1682×554 93.5 KB

3

Yes, as in Crystal and BIRT reports. Thanks.