Hi,
To set up parameter dependencies in Blitz Report, you can use the syntax :$flex$.parameter_or_lov_name. The parameter_or_lov_name should reference the name of the dependent parameter or the LOV (List of Values) name. This allows you to dynamically filter LOV results based on the value of another parameter.
Key Details:
- Case-Insensitive References: The parameter or LOV name is not case-sensitive.
- Special Characters: Any spaces or non-word characters in the name are automatically replaced with underscores.
- Handling Multiple Values: If the dependent parameter supports multiple values, you can use the xxen_util.contains function in your query.
Example:
If you have an Operating Unit parameter that allows multiple selections, you can configure the query for an AP Supplier LOV to filter results based on the selected operating units using xxen_util.contains. This ensures that the LOV dynamically adjusts to the selected values of the dependent parameter.
Additional Resources:
For a detailed explanation of dependent parameters and how to implement them, refer to the Developer Guide:
Blitz Report Developer Guide – Dependent Parameters
If you need help with a specific query or configuration, feel free to reach out to us. We’re here to assist you!