How to create multiple filter parameters
1  
Select the first column for which you want to create a prompt, and choose Filter. Filter appears. The selected column appears in Filter By.
2  
Select Static or Dynamic.
*
To create a static filter parameter, complete steps 1 to 9 in How to create a static filter parameter with a list of values.
*
To create a dynamic filter parameter, complete steps 1 to 10 in How to create a dynamic filter parameter at the report table level.
3  
On Filter, choose Advanced Filter.
4  
On Advanced Filter, choose Add Condition. The filter parameter condition you previously specified appears in the Filters area in Advanced Filter.
5  
Choose Add Filter.
6  
To define the next condition, in Advanced Filter, complete the following steps:
1  
In Filter, select Static or Dynamic.
2  
In Filter By, select a column from the drop-down list.
3  
In Prompt Text, type the display text for the prompt.
4  
If the report contains aggregate data, do one of the following:
*
To recalculate aggregate data values across the filtered data rows, select Recalculate Totals if necessary.
*
To calculate aggregate data for the unfiltered data, deselect Recalculate Totals.
5  
Choose Edit Parameter.
*
If you selected Static in step 1, complete steps 1 to 9 in How to create a static filter parameter with a list of values.
*
If you selected Dynamic in step 1, complete steps 1 to 10 in How to create a dynamic filter parameter at the report table level.
6  
In Advanced Filter, choose Add Filter.
7  
To define additional filter parameters, in Advanced Filter, repeat step 6. Choose OK. The example in Figure 5-37 shows Advanced Filter displaying three filter parameter conditions.
Figure 5-37  
Defining multiple filter parameters in Advanced Filter
8  
To test the prompt in BIRT Studio choose Parameter. Parameters displays the prompt with the three defined conditions for which the user can supply values, as shown in Figure 5-38. The first condition is a static filter parameter, and the remaining two conditions are dynamic filter parameters.
Figure 5-38  
Specifying multiple filter parameter values
 
Additional Links: Forums | Blogs | Support | Give Us Feedback | More...

© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy

 BIRT iHub 2