How to limit the data displayed in a report
You can use Table Builder—Filter to specify a filter at the data set level. The following example sets a filter condition such that only data for the country USA is retrieved from the data set.
1  
2  
3  
1  
2  
Based on your selection, either one or two fields appear in Value.
3  
*
*
*
Figure 1-18  
4  
Choose Add Condition. The condition appears in Filters, as shown in Figure 1-19. Choose Validate. After a message appears confirming that the syntax of the filter condition is valid, choose OK.
Figure 1-19  
The filter condition appears in Table Builder—Filter. Choose OK.
You can also create additional conditions and group them using logical operators such as and, or, and not. More information about using the logical operators, and creating more complex filter conditions is available in later sections of this document.
The data fields that meet the filter condition appear in the report design, as shown in Figure 1-20.
Figure 1-20  
You are now ready to format the report design.

Additional Links:

Copyright Actuate Corporation 2013 BIRT iHub 2