![]() In this section, we will implement the "Master Lookup" filter for the "Product List" report. This report must provide the users with the option to filter products by selecting a category from the dropdown list. We know that each product belongs to category. The product-category relationship is maintained in the "Product" master data model, while the category details are maintained in the "Category" master data model. To implement the required report filter, we must match the category code in the "Product" model (LHS) against the category code in the "Category" model by creating a lookup relationship for the RHS parameter. This will also ensure that a dropdown list is provided for the category code report filter paramter. It must be noted that whenever the "Master Lookup" filter type is selected, the LHS must be a reference parameter.
|