Using "Master Lookup" filter 
The gadget spec URL could not be found


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. 

Configuring filter parameters
   
LHS: select "CategoryCode" from the dropdown list. 

Operator: select "="from the dropdown list.

Filter Type: select "Master Lookup" from the dropdown list.

RHS: Enter the filter display field name "Category Code" in the textbox. Click on the pen icon next to the RHS parameter to create master lookup relationship.
   


   


Creating category code master lookup
   
Master lookup dialog box will be displayed. Select "Category" from the list of models displayed and then select "CategoryCode" from the list of display cells.

Click on the "OK" button to create a master lookup.

Save the changes in server and deploy the application.
   




Category code report filter parameter
   
A dropdown list with the list of valid values for category code from the category model will be displayed for the category code report filter parameter.

Users can view only the products belonging to a category by selecting the respective category code for the report parameter and clicking on the "Run" button.
   







Report data filtered based on user input.
   
Users can view only the products belonging to a category by selecting the respective category code for the report parameter dropdown list and then clicking on the "Run" button.