Using multiple filters 
The gadget spec URL could not be found


In this section, we will learn to configure multiple report filter parameters for a report. We will implement a price range lookup for the "Product List" report so that users can filter the products displayed by entering a min price and/or max price. 

Configuring multiple report filter parameters
   
Filter parameter 1: Price From

LHS: select "ProductPrice" from the dropdown list.

Operator: select ">" from the dropdown list.

Filter Type: select "User Input" from the dropdown list.

RHS: Enter the filter display field name "Product From" in the textbox.
   

Filter parameter 2: Price Till

LHS: select "ProductPrice" from the dropdown list.

Operator: select "<" from the dropdown list.

Filter Type: select "User Input" from the dropdown list.

RHS: Enter the filter display field name "Product Till" in the textbox.
   


"Price From" and "Price Till" report filter parameters 
   
A textbox will be available for "Price From" and "Price Till" report filter parameters.

Users can filter the data displayed in the report by entering the appropriate values for the report filter parameters.
   





Use both the parameters to filter report data
   
If the values for both "Price From" and "Price Till" parameter is entered, then all the products with price in the price range entered by the user will be displayed.
   





Use "Price From" parameter to filter report data
   
If the value for "Price From" parameter is only entered, then all the products with price starting from the value entered by the user will be displayed.
   
   


Configuring multiple parameters - An exercise
   
Create a product list report with the following report filter parameters:
  • Price From
  • Price Till
  • Category Code
  • Product Description