REPORTS: To use one parameter within the combo selection of a subsequent parameter
Hint Ref: 020705240004
Hint Date: 24/05/2007
Previous Parameters can be utilised in subsequent ones by prefixing the parameter name with : and surrounding it with brackets.
To create a report which offers ledgeritems based on the Areaname parameter, create a parameter with the following combo setup:
select ledgeritem.description from ledgeritem join site where sitename=(:Areaname) order by ledgeritem.description
Note: You cannot use the Area parameter as is does not appear that you can use macro substitutions within a parameter's setup as you can in the SQL.