Multi Level Grouping

arjunmanju

Hi all,<br />
<br />
In the report we are doing first level grouping, ie.. for example Product,Category,Location etc <br />
<br />
<br />
<br />
(Please see the attached image bi.jpg)<br />
<br />
<br />
<br />
for first level grouping option we are giving radio button for users as above image<br />
<br />
first level is like below <br />
<br />
product <br />
Column1 Column 2 Column 3 Column 4<br />
DETAIL ROW DETAIL ROW DETAIL ROW DETAIL ROW <br />
<br />
<br />
product2 <br />
Column1 Column 2 Column 3 Column 4<br />
DETAIL ROW DETAIL ROW DETAIL ROW DETAIL ROW <br />
<br />
<br />
product3 <br />
<br />
Column1 Column 2 Column 3 Column 4<br />
DETAIL ROW DETAIL ROW DETAIL ROW DETAIL ROW <br />
<br />
<br />
<br />
----> second level of grouping is like after grouping on product again on product1 data it shud group .... for that below the radiobutton ....parameters we should give drop down for ex:<br />
<br />
(Please see attached img bir.jpg)<br />
<br />
it should display only drop down with categories values ... <br />
<br />
(Please see attached img birt.jpg)<br />
<br />
it should display only drop down with location values ... <br />
<br />
<br />
<br />

---

>so after selecting product in radiobutton(first level grouping) we should select category or location or both (second level grouping)...<br />
<br />
<br />
if i select product in radiobutton(first level grouping) and only category(second level grouping) we should get the output like ....<br />
<br />
<br />
<del class='bbc'>grp 1:</del> product <br />
<del class='bbc'>grp2 :</del> category <br />
<br />
Column1 Column 2 Column 3 Column 4<br />
DETAIL ROW DETAIL ROW DETAIL ROW DETAIL ROW<br />
<br />
<br />
<del class='bbc'>grp 1:</del> product <br />
<del class='bbc'>grp2 :</del> category <br />
<br />
Column1 Column 2 Column 3 Column 4<br />
DETAIL ROW DETAIL ROW DETAIL ROW DETAIL ROW <br />
<br />
<del class='bbc'>grp 1:</del> product <br />
<del class='bbc'>grp2 :</del> category <br />
<br />
<br />
Column1 Column 2 Column 3 Column 4<br />
DETAIL ROW DETAIL ROW DETAIL ROW DETAIL ROW <br />
<br />
<br />
<br />
if i select product in radiobutton(first level grouping) and only location(second level grouping) we should get the output like ....<br />
<br />
<br />
<del class='bbc'>grp 1:</del> product <br />
<del class='bbc'>grp2 :</del> location<br />
<br />
Column1 Column 2 Column 3 Column 4<br />
DETAIL ROW DETAIL ROW DETAIL ROW DETAIL ROW <br />
<br />
<br />
<br />
if i select product in radiobutton(first level grouping) and both location and category (second level grouping) we should get the output like ....<br />
<br />
<br />
<br />
<del class='bbc'>grp 1:</del> product <br />
<del class='bbc'>grp2 :</del> category<br />
<del class='bbc'>grp 3 :</del> location<br />
<br />
Column1 Column 2 Column 3 Column 4<br />
DETAIL ROW DETAIL ROW DETAIL ROW DETAIL ROW <br />
<br />
<br />
So ultimately the output should get generated for dynamic values(product,location,category) given by user and group based on it....<br />
<br />
please help me out how to acheive it as soon as possible<br />
<br />
Thanks in advance<br />
<br />
Arjun H Manju

mcremer

Hi arjunmanju,<br />
<br />
Your story wasnt that clear but the ghist of it is you want conditional grouping. You can do this quite simple in any complexity you want by doing the following:<br />
<br />
<img src='http://a1.img.mobypicture.com/fd873c9a9a7517405af511ab3ea6ee64_large.jpg' alt='Posted Image' class='bbc_img' /><br />
<br />
When making a group you can select in Group on a data row from your table. However you can also select for script option.<br />
<br />
Here you could do something like this:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
if (params["PARM1"].value == 'X'){
0;
}else {
row["COL1"]
}
</pre>
<br />
You can do this with all the groups. Disabling them (by setting them to 0 meaning all for that group will be the same value and thus not sorted.<br />
<br />
The biggest problem I cant tell you will be dynamically changing the sorting direction of the Group I'm afraid I never attempted it nor do I know if you can actually change on runtime the group sorting direction of a table group maybe someone of the more experienced people (or the folks from Actuate) out here can tell you that.