Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




Eclipse BIRT Report Developer Guide
Previous Page Home Next Page

Previous Next

How to filter at the data set level

In Data Explorer, right-click the data set whose rows you want to filter, then choose Edit. Edit Data Set displays the query for the data set, as shown in Figure 11‑1.

Figure 11-1 Edit Data Set displaying the query

Figure 11-2 Edit Data Set displaying filtering information

In Expression, select a field from the drop-down list. Alternatively, open the expression builder to create a more complex expression.
In Value 1, specify the value to search. You can type the value, select from the list of values, or use the expression builder to create a more complex value expression. If you select the Is True, Is False, Is Null, or Is Not Null operator, you do not specify a value.
In Value 2, specify a value only if you select the Between or Not Between operator. Figure 11‑3 shows an example of a filter condition.

Figure 11-3 New Filter displaying a filter condition

To create additional filter conditions for the data set, repeat steps 3 and 4. Figure 11‑4 shows two examples of filter conditions created for a data set. Figure 11‑5 shows the rows that the data set returns.

Figure 11-4 Edit Data Set displaying the filter conditions for the data set

Choose Preview Results to verify the results that filtering the data set returns. If you specified multiple filter conditions, the data set returns only rows that match all filter conditions, as shown in Figure 11‑5. To return rows that match any one of the filter conditions, create a single filter condition that contains an OR expression, then select the Is True operator.

Figure 11-5 Preview Results shows only rows that meet both filter conditions

(c) Copyright Actuate Corporation 2009

  Published under the terms of the Eclipse Public License Version 1.0 ("EPL") Design by Interspire