We're making reports in the Report Designer 1.6 and publishing them to put them in Pentaho Studio and then on a server. We want to put a parameter the user can enter and have it used in criteria for the SQL. If we add an input variable to "inputs", and add it to "Prompt for Report Export Type" , we can get at it in the SQL with code like

`utilitybillingmasterfile`.OwnSection = substr('{INPUT_METERNO}',1,1)

(INPUT_METERNO is the variable)

but this ONLY WORKs when we add
the part in bold below BY HAND to the XML.
<INPUT_METERNO type="string"/>

Is there a way to do this in the report designer or studio through the GUI?

John Holland