> Task 7: | Edit the query

> In this procedure, you edit the query in the Products data set so that it is dynamically updated at run time to use the values of the report parameters.

> 1 | Choose Layout to resume editing the report.

> 2 | In Data Explorer, right-click the Products data set, and choose Edit.

> 3 | Edit the query to add a WHERE clause as follows:

> select productname,
> productvendor,
> quantityinstock
> from Products
> where quantityinstock <= ?
> and productvendor Like ?
> The WHERE clause contains two parameter markers, ?, which indicate where you want BIRT to insert the report parameter values at report run time. The Like operator is a SQL pattern-matching option. Using Like, you can replace the parameter marker with a value, such as A%, to return rows where the vendor name starts with A. In a later procedure, you see the flexibility of using the Like operator instead of the = operator.

(c) Copyright Actuate Corporation 2008