Invalid Parameter Value

Your input must match the parameter type.

In case the parameter type is Date or DateArray, your input must also match the pattern.

Parameter formulas

You can use formulas instead of fixed values for CDA parameters. Here are some useful examples:

${TODAY()}

Today's date

${YESTERDAY()}

Yesterday's date

$FOREACH(dataAccess,colIdx,param1=val1,...,paramn=valn)

Iterate over the values for colIdx in query dataAccess with the given parameters. Queries using this construct return no values, and its main purpose is to provide parameter ranges for cache warming.

Please refer to the Pentaho Reporting Engine documentation for a full description of the syntax.