birt-03-10.html from BIRT at Krugle
Show birt-03-10.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:56:54" />
<title>How to define a dynamic query</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-03-09.html" />
<link rel="next" title="Next" href="birt-03-11.html" />
</head>
<body>
<table id="SummaryNotReq1" border="0" align="right" cellpadding="4" cellspacing="0">
<tr>
<td>
<a accesskey="4" href="birt-03-09.html"><img id="LongDescNotReq1" src="images/prev.gif" border="0" alt="Previous Topic" /></a><a accesskey="5" href="birt-03-11.html"><img id="LongDescNotReq2" src="images/next.gif" border="0" alt="Next Topic" /></a>
</td>
</tr>
</table>
<br />
<br />
<!-- AC_CONTENT -->
<a name="wp200837"> </a><h4 class="pHeading4">
How to define a dynamic query
</h4>
<div class="pSmartList1"><ol type="1" class="pSmartList1">
<a name="wp200838"> </a><div class="pSmartList1"><li>On the Query page of a data set, define a SQL query, such as:</li></div>
<div class="pPreformattedRelative"><pre class="pPreformattedRelative">
SELECT CUSTOMERNAME FROM CUSTOMERS<a name="wp200843"> </a>
</pre></div>
<a name="wp200840"> </a><div class="pSmartList1"><li>Create a table in the report layout that uses this data set.</li></div>
<a name="wp200866"> </a><div class="pSmartList1"><li>Create a report parameter, such as a String parameter called "passName".</li></div>
<a name="wp200852"> </a><div class="pSmartList1"><li>In Edit Data Set, choose Property Binding, and define the query text to use the report parameter that you created:</li></div>
<div class="pPreformattedRelative"><pre class="pPreformattedRelative">
"SELECT CustomerName From CUSTOMERS WHERE CustomerName LIKE '" + params["passName"] + "'"<a name="wp200876"> </a>
</pre></div>
<a name="wp193071"> </a><div class="pSmartList1"><li>Choose OK. </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-03-09.html"><img id="LongDescNotReq3" src="images/prev.gif" border="0" alt="Previous Topic" /></a><a accesskey="5" href="birt-03-11.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