birt-12-6.html from BIRT at Krugle
Show birt-12-6.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:46" />
<title>How to dynamically update a filter condition when the report runs</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-12-5.html" />
<link rel="next" title="Next" href="birt-13-1.html" />
</head>
<body>
<table id="SummaryNotReq1" border="0" align="right" cellpadding="4" cellspacing="0">
<tr>
<td>
<a accesskey="4" href="birt-12-5.html"><img id="LongDescNotReq1" src="images/prev.gif" border="0" alt="Previous Topic" /></a><a accesskey="5" href="birt-13-1.html"><img id="LongDescNotReq2" src="images/next.gif" border="0" alt="Next Topic" /></a>
</td>
</tr>
</table>
<br />
<br />
<!-- AC_CONTENT -->
<a name="wp170692"> </a><h4 class="pHeading4">
How to dynamically update a filter condition when the report runs
</h4>
<a name="wp170742"> </a><p class="pBody">
This procedure assumes that you already created:
</p>
<div class="pSmartList1"><ul class="pSmartList1">
<a name="wp170743"> </a><div class="pSmartList1"><li>A report that contains a table or list to display data from a data set</li></div>
<a name="wp170748"> </a><div class="pSmartList1"><li>One or more report parameters for the report</li></div>
</ul></div>
<a name="wp274937"> </a><p class="pBody">
</p>
<div class="pSmartList1"><ol type="1" class="pSmartList1">
<a name="wp170696"> </a><div class="pSmartList1"><li>In the layout editor, select the table element or list element to filter. The property editor displays the properties of the selected table or list. </li></div>
<a name="wp240063"> </a><div class="pSmartList1"><a href="birt-12-6.html#wp250709">Figure 12-6</a> shows an example of a selected table and its properties.</div>
<a name="wp170904"> </a><p class="pBodyRelative">
<img src="images/table_selected.gif" height="307" width="453" id="wp260221" border="0" hspace="0" vspace="2"/>
</p>
<a name="wp250709"> </a><div class="pFigTitle">
Figure 12-6 Table properties
</div>
<a name="wp170701"> </a><div class="pSmartList1"><li>Choose the Filters tab. The property editor displays the Filters page, as shown in <a href="birt-12-6.html#wp250717">Figure 12-7</a>.</li></div>
<a name="wp170915"> </a><p class="pBodyRelative">
<img src="images/new_filter.gif" height="125" width="451" id="wp260295" border="0" hspace="0" vspace="2"/>
</p>
<a name="wp250717"> </a><div class="pFigTitle">
Figure 12-7 The Filters page in Property Editor
</div>
<a name="wp170706"> </a><div class="pSmartList1"><li>Choose Add to create a new filter condition.</li></div>
<a name="wp170710"> </a><div class="pSmartList1"><li>Specify the filter condition:</li></div>
<div class="pSmartList2"><ol type="1" class="pSmartList2">
<a name="wp170711"> </a><div class="pSmartList2"><li>Click the cell below Expression.</li></div>
<a name="wp170715"> </a><div class="pSmartList2">Two buttons appear at the right.</div>
<a name="wp170716"> </a><div class="pSmartList2"><li>Choose the arrow button, then select the field for which you want the user to specify a value when the report runs.</li></div>
<a name="wp170720"> </a><div class="pSmartList2"><li>For Operator, select an operator from the drop-down list.</li></div>
<a name="wp170721"> </a><div class="pSmartList2"><li>For Value 1, specify the name of the report parameter that you created.</li></div>
<a name="wp170722"> </a><div class="pSmartList2">You can use the expression builder to select the report parameter from the list of report parameters that you created for the report. <a href="birt-12-6.html#wp250725">Figure 12-8</a> shows an example of a filter condition for which the value is set to a report parameter.</div>
<a name="wp170730"> </a><p class="pBodyRelative">
<img src="images/filter_with_reportparam.gif" height="125" width="451" id="wp260369" border="0" hspace="0" vspace="2"/>
</p>
<a name="wp250725"> </a><div class="pFigTitle">
Figure 12-8 Filter condition, set to a report parameter
</div>
</ol></div>
<a name="wp170738"> </a><div class="pSmartList1"><li>Preview the report.</li></div>
<a name="wp170749"> </a><div class="pSmartList1">Enter Parameters appears and displays the report parameters that you created. <a href="birt-12-6.html#wp250753">Figure 12-9</a> shows an example.</div>
<a name="wp170765"> </a><p class="pBodyRelative">
<img src="images/enter_param_example.gif" height="133" width="354" id="wp260444" border="0" hspace="0" vspace="2"/>
</p>
<a name="wp250753"> </a><div class="pFigTitle">
Figure 12-9 Enter Parameters, showing a report parameter
</div>
<a name="wp170776"> </a><div class="pSmartList1"><li>Specify values for the report parameters, then choose OK.</li></div>
<a name="wp170780"> </a><div class="pSmartList1">The report displays data that matches the values that you specified.</div>
</ol></div>
<a name="wp173184"> </a><p class="pBody">
</p>
<!-- /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-12-5.html"><img id="LongDescNotReq3" src="images/prev.gif" border="0" alt="Previous Topic" /></a><a accesskey="5" href="birt-13-1.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