title: Creating a BIRT using query params
body: <p>I'm to a query multiple times from a single query in BIRT. For example, my <strong>DB2</strong> query could be <code>SELECT * FROM GROUPS</code> and my dataset would look like</p>
  
  <pre><code>id  |  name
  1   |  group 1
  2   |  group 2
  </code></pre>
  
  <p>From that dataset I'd like to run another query for each row. So maybe something like <code>SELECT * FROM ORDERS WHERE group_id = params['id']</code> where <code>id</code> is id of the current <code>GROUP</code> record.</p>
  
  <p>The actual report would look something like:</p>
  
  <pre><code>Order for Group 1
  01/01/2015  Order #321
  01/15/2015  Order #948
  
  Orders for Group 2
  01/02/2015  Order #123
  01/23/2015  Order #456
  </code></pre>
  
  <p>I'm fairly new to BIRT and have seen examples of using scripts on certain events (<code>beforeOpen</code>, etc), but I wanted to make sure that was the proper way to go for something this rudimentary.</p>