nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Grouping by Parameters

Bordihn

Hi,
 
I would like to group different parameter in a report, meaning that the user can select a parameter and gets a sorted report by this groups as a result.
 
For example: I have 8 rows in a report and want 3 of them to offer the possibilty for grouping/sorting. So I created a report and added 3 TableGroups for this 3 rows (datapoints) which results as expected in a report with static groups (TableGroup 1 first sorted, Table Group 2 second sorted...). I also added 3 Report parameters (Boolean, Check Box), so that the user can choose which group sorting he wishes.
 
This dynamic groups, which the user can choose by selecting parameters, donÂ´t work actually and I found nothing similar in the forum. So, anyone any ideas?
 
Thanks in advance and best regards.

Find more posts tagged with

Comments

micajblock

Check out this DevShare
 
<a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/1-dynamic-grouping-example/'>http://developer.actuate.com/community/forum/index.php?/files/file/1-dynamic-grouping-example/</a>

Clement Wong

You can create a dynamic group based on a parameter.
 
First, create a new column binding on the table for your groups. In the attached example, we'll either group by country or state.
<pre class="_prettyXprint">
if (params["pColumnGroup"].value == "Country")
row["COUNTRY"];
else
row["STATE"];</pre>
Then, you can Edit Group and change the Group On column to the newly created column.
 
The attached design demonstrates a dynamic grouping between country and state.
 
Another similar technique illustrated by Michael Williams changes the dynamic group directly in the Group On column as an expression. See it here @ <a data-ipb='nomediaparse' href='https://www.eclipse.org/forums/index.php/t/452359/'>https://www.eclipse.org/forums/index.php/t/452359/</a>
 
 
A more advanced technique would be to use the Design Engine API in the beforeFactory event to dynamically group and construct the table based on the group.

Bordihn

Hi Clement,
 
your solution worked pretty well, so I prefer this way instead of mblockÂ´s example (less changes). But itÂ´s good to know that there are different working solutions for this problem.
 
Thanks a lot for your help and best regards.

Clement Wong

Good to hear. With BIRT, there are many ways and techniques to solve a problem/requirement!