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 data at the cross tab level

Choose Group level to filter data in a specific group. For example, if the cross tab displays sales totals by product line and by year, you can create a filter to display data for certain product lines or for certain years.
Choose Measure to filter measure data. For example, you can create a filter to display sales totals greater than a specific number.
In the first field, choose <Filter by...> to select a dimension or a measure, or a group total whose values to evaluate, as shown in Figure 17‑32. Alternatively, choose <Build expression...> to create an expression.

In the third field, specify the value to search in the dimension or measure specified in the first field. You can type a value, or choose <Select value...> to display a list of values. You can also specify an expression that evaluates to a value. Choose <Build expression...> to open the expression builder.
Figure 17‑33 shows an example of a complete filter condition. The filter limits the data to only the years where the annual sales exceed 2000000. The annual sales is calculated by the data field, EXTENDED_PRICE_Group2/year, under Grand Total in the Filter By dialog box shown in Figure 17‑32.

(c) Copyright Actuate Corporation 2009

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