<p>I'm relatively new to BIRT but making good progress. I'm struggling with getting a report done for my client in which they want totals broken down by week. My strategy was to create 2 sql statements, one that gives me all the Sundays-Saturdays in a given date range, and the other to give me all the results I need to compute the totals. I thought I was on a good roll until I realized I can't bind 2 datasets to one table. I also can't join them logically.</p>
<p> </p>
<p>My next plan is to try and put the resultset/dataset of the weeks into an array, loop through the array and populate the first column of the table and then perform aggregate counts on the second dataset filtered by the weeks... if that's possible.</p>
<p> </p>
<p>However if someone has done this before and has an example or a suggestion I'd be most appreciative.</p>
<p> </p>
<p>Thanks.</p>
