Report Writer Parameters

Use parameters to add output filtering options and indicators to reports:

• Runtime parameters - Users can enter information when running the report. The report output is filtered using the parameter values. All standard Greentree Desktop reports have runtime parameters — for example, Customer From/To, Reference From/To, Posting Date Ranges, and the like.
• Indicators - True/false parameters. As well as being used at runtime, you can use these types of parameters to set report visibility conditions. You can output data to the report depending on the database value of a true/false parameter.
• Queries - The Query Designer can reference the parameters if you are using a query to filter the output of a report. This is based around the parameter values that are entered by the user during runtime. For example, if you have set up Customer From Code and Customer To Code parameters because you want to filter the report output on the basis of these values, then you must set up a query to specify that the report should only output data for customers with a code >= the Customer From Code parameter, and <= the Customer To Code parameter.

You can also assign parameters as input values to methods, and use them in calculations.

Enter a name for the parameter, then select from one of these types:

• Alphanumeric
• Numeric
• True/false
• Date

At runtime, enter parameter values using the type assigned (if they are Available to user). For example, if you assign a true/false type, this will present at runtime as a checkbox.

Enter an Initial Value for the parameter. For example, you can enter zzzzzzz as the initial value for the Item Code To parameter, if it is most common that the report runs using the full range of items.

Note: JADE systems recognise lower case as coming after upper case

Select True to make the parameter is visible at runtime. Select False if you are setting up a parameter just to use as a behind the scenes visibility condition, or to use elseif in a query.

Use the arrow icons to change the position of the parameters in the list. You can click the Deleteicon to delete a parameter from the list, but only if it is not being used in the report.

• Field Properties
• Section Properties/Other
• Query Designer
• Methods
• Calculations