Creating multiple groups in a table

riyaz_itls

Hi,<br />
<br />
I have a dataset returning the following:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>

Month Customer Operation Count

---

Jun2011 Cust_1 Add 100
Jun2011 Cust_1 Update 200
Jun2011 Cust_2 Add 50
Jun2011 Cust_2 Update 150
Aug2011 Cust_1 Add 70
Aug2011 Cust_1 Update 110
Aug2011 Cust_2 Add 40
Aug2011 Cust_2 Update 30

</pre>
<br />
Now I need to create a report which gives the following output<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>

Group_1 Group_2 Operation Count

---

Jun2011

MonthSummary
Add 150
Update 350

Cust_1
Add 100
Update 200

Cust_2
Add 50
Update 150

Aug2011

MonthSummary
Add 110
Update 140

Cust_1
Add 70
Update 110

Cust_2
Add 40
Update 30

</pre>
<br />
In short I need to create a table with two subgroups:<br />
- one group on month (master group)<br />
- subgroup on Operation only<br />
- subgroup on Customer + Operation<br />
<br />
Is this possible with BIRT

mwilliams

Yes. You'd just group your table on Month, then group it on Customer, then group it on Operation. This would create the above layout you're wanting. Just make sure the groups are in that order and then you'll have group headers and footers that you can do summations and group title information, etc.