Wyszukaj w bazie

REPORTS: To use one parameter within the combo selection of a subsequent parameter

Hint Ref: 020705240004
Hint Date: 24/05/2007

Hint Details:

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.