birt-11-3.html from BIRT at Krugle
Show birt-11-3.html syntax highlighted
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<meta name="GENERATOR" content="Quadralay WebWorks Publisher 2003 for FrameMaker 8.0.7.2249" />
<meta name="TEMPLATEBASE" content="Dynamic-HTML-Eclipse-20060620" />
<meta name="LASTUPDATED" content="06/23/06 16:57:39" />
<title>How to filter at the data-set level</title>
<link rel="StyleSheet" href="document.css" type="text/css" media="all" />
<link rel="StyleSheet" href="catalog.css" type="text/css" media="all" />
<link rel="contents" title="Table of Contents" href="TOC.html" />
<link rel="first" title="First" href="TOC.html" />
<link rel="last" title="Last" href="birt-24-1.html" />
<link rel="previous" title="Previous" href="birt-11-2.html" />
<link rel="next" title="Next" href="birt-11-4.html" />
</head>
<body>
<table id="SummaryNotReq1" border="0" align="right" cellpadding="4" cellspacing="0">
<tr>
<td>
<a accesskey="4" href="birt-11-2.html"><img id="LongDescNotReq1" src="images/prev.gif" border="0" alt="Previous Topic" /></a><a accesskey="5" href="birt-11-4.html"><img id="LongDescNotReq2" src="images/next.gif" border="0" alt="Next Topic" /></a>
</td>
</tr>
</table>
<br />
<br />
<!-- AC_CONTENT -->
<a name="wp138199"> </a><h4 class="pHeading4">
How to filter at the data-set level
</h4>
<div class="pSmartList1"><ol type="1" class="pSmartList1">
<a name="wp138219"> </a><div class="pSmartList1"><li>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 <a href="birt-11-3.html#wp206837">Figure 11-1</a>.</li></div>
<a name="wp143734"> </a><p class="pBodyRelative">
<img src="images/basic_query.gif" height="239" width="446" id="wp143739" border="0" hspace="0" vspace="2"/>
</p>
<a name="wp206837"> </a><div class="pFigTitle">
Figure 11-1 Edit Data Set, displaying the query
</div>
<a name="wp138222"> </a><div class="pSmartList1"><li>Choose Filters from the left side of the window. Edit Data Set displays filter information, as shown in <a href="birt-11-3.html#wp197153">Figure 11-2</a>.</li></div>
<a name="wp157654"> </a><p class="pBodyRelative">
<img src="images/add_ds_filter.gif" height="176" width="441" id="wp157659" border="0" hspace="0" vspace="2"/>
</p>
<a name="wp197153"> </a><div class="pFigTitle">
Figure 11-2 Edit Data Set, displaying filtering information
</div>
<a name="wp181477"> </a><div class="pSmartList1"><li>Specify the filter condition:</li></div>
<div class="pSmartList2"><ol type="1" class="pSmartList2">
<a name="wp181478"> </a><div class="pSmartList2"><li>Click the cell below Expression. Two buttons appear on the right. The arrow button displays a list of fields you can use in Expression. The ellipsis (...) button launches Expression Builder, which you can use to create a more complex expression.</li></div>
<a name="wp186836"> </a><div class="pSmartList2"><li>For Expression, select a field. You can also type the filter expression.</li></div>
<a name="wp153153"> </a><div class="pSmartList2"><li>For Operator, select an operator from the drop-down list.</li></div>
<a name="wp153154"> </a><div class="pSmartList2"><li>For Value 1, specify the search value. You can type the value, select from the list of values, or use 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.</li></div>
<a name="wp197170"> </a><div class="pSmartList2"><li>For Value 2, specify a value only if you select the Between or Not Between operator. <a href="birt-11-3.html#wp197202">Figure 11-3</a> shows some examples of filter conditions.</li></div>
<a name="wp197182"> </a><p class="pBodyRelative">
<img src="images/dataset_filter.gif" height="172" width="461" id="wp197175" border="0" hspace="0" vspace="2"/>
</p>
<a name="wp197202"> </a><div class="pFigTitle">
Figure 11-3 Filter conditions in Edit Data Set
</div>
</ol></div>
<a name="wp138232"> </a><div class="pSmartList1"><li>Choose Preview Results to verify the results that the data set returns. If you specified multiple filter conditions, the report displays only rows that match all filter conditions. To display 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. This task is described later in this chapter.</li></div>
</ol></div>
<!-- /AC_CONTENT -->
<!--
<blockquote>
< !--BeginHiddenExpansion Dollar_BP80PageASP_Content; EndHiddenExpansion-- >
</blockquote>
<br />
-->
<br />
<a href="../notices.html">
<img src="images/ac-copyright.gif" width="296" height="14" border="0" alt="(c) Copyright Actuate Corporation 2006" /><br />
</a>
<br />
<!--
<hr />
<table id="SummaryNotReq2" align="right" border="0" cellspacing="0" cellpadding="4">
<tr>
<td align="right">
<span style="font-size: 10px">
<img src="images/actuate_logo.gif" width="186" height="42" border="0" alt="(c) Copyright Actuate Corporation 2005" /><br />
<span style="font-size: 14px ; font-weight: bold; font-family: Arial, Helvetica, sans-serif">
Actuate Corporation<br />
</span>
Actuate Corporation<br />
<a href="http://www.actuate.com">http://www.actuate.com</a><br />
<a href="mailto:info@actuate.com">info@actuate.com</a>
<br />
</span>
</td>
</tr>
</table>
-->
<table id="SummaryNotReq3" border="0" align="left" cellpadding="4" cellspacing="0">
<tr>
<td>
<a accesskey="4" href="birt-11-2.html"><img id="LongDescNotReq3" src="images/prev.gif" border="0" alt="Previous Topic" /></a><a accesskey="5" href="birt-11-4.html"><img id="LongDescNotReq4" src="images/next.gif" border="0" alt="Next Topic" /></a>
</td>
</tr>
</table>
</body>
</html>
See more files for this project here