Create a row grouping in Table Component (Jasper Report)

Create a row grouping in Table Component (Jasper)

Consider an example currently you are showing the data as shown in below using tabular component.

Example:

But If you want to show the data as shown in the table.

For this you need to follow these simple steps.

1. 1. Create a group in the Groups property of data set (This data set is used by table component).
      Say Country is the name of the group and then put the expression.

Note : Sometime in the Jasper Studio 6.0.1 the name of the group does not change in that case you need to keep the by default name to the group.

1. 1. After creating the Group you can see the two new bands added to table component. You can see in the figure.

1. Create a cell in Group header and put group expression in it (in my case $F{country}).

Make data easy with Helical Insight.
Helical Insight is world’s best open source business intelligence tool.

Claim Your 30 Days Free Trail

2. In order to calculate the total group wise you need to create a variable with reset type your group name (Country) otherwise you will not get the correct result.
3. Put this variable (say total) in the group footer.

Note: You can create multiple group in a table.

Best Open Source Business Intelligence Software Helical Insight is Here

A Business Intelligence Framework

Free
Download