Report Writer Parameters

Parameters are used to add output filtering options and indicators to reports:

• Runtime parameters - these allow the user to enter information when running the report. The report output will be filtered using the parameter values. All standard Greentree reports have runtime parameters, for example, Customer From/To, Reference From/To, Posting Date Ranges, and the like.
• Indicators - these are true/false parameters. As well as being used at runtime, these types of parameters can be used to set report visibility conditions. Data can be output to the report depending on the database value of a true/false parameter - this does not must be seen by the user as it is determined by Greentree Desktop. at runtime.
• Queries - parameters can be referenced in the Query Designer, specifically where you are using a query to filter the output of a report, and 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 will also need to 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, Greentree will expect the user to 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.

JADE systems recognise lower case as coming after upper case.

Select True or False to make the field available to the user. If True is selected, the parameter will be visible at runtime. You can select False if you are setting up a parameter just to use as a behind the scenes visibility condition, or to use elsewhere in a query.

The icons can be used to shift the position of the parameters in the list, hence the position they will ultimately display at runtime. You can clickto delete a parameter from the list, but only if it is not being used in the report (for example, it is in a report section to print, or being used in a query/condition, and the like).

• Field Properties
• Section Properties/Other