In iReport how to reset the counter of a group when there are multiple groups

[srikanth.aripirala]

I would like to display a text at the end of the group data i.e., for the last record in that group.

Example:

I have a data set like below,

Building	Part Family	Part	Total
B1	CU	CUCON	10
B1	CU	CUCON	10
B1	CU	CUCON1	10
B1	ZN	ZINC	20
B2	CU	CUCON	10
B2	ZN	ZINC	10
B3	CU	CUCON	10

In case I want the result to be displayed as,

	B1	CU	CUCON
	B1	CU	CUCON
Total	CUCON			20
	B1	CU	CUCON1
Total	CUCON1			10
Total	CU			30
	B1	ZN	ZINC
Total	ZINC			20
Total	ZN			20
Total	B1			50

Further information is that, I have all the data from the query itself i.e., all values including the SUM for each group total are being fetched from query itself and my query is also sorted as Building, Family, and Part. Only grouping has been done via the iReport. Now the data split is correct and grouping correctly as required. But the problem I face is with the Total's because it display at every group split of records i.e., if there is a group split of Part all the 3 totals is displayed which I do not want.

The Total should display based on the Group itself i.e., if there is a change in Part group it should display only the total of the Part not others. In case there is a change in Part Family then it should display only that Group total similarly for Building as well.  

Appreciate your help in this regard