How can I merge row cell with same values on a specific column?

[fiyov46807]

Hello, I am  trying to use Spring Boot and Jasper Report, to create an excel file that has the following format.  I  would like to group by EMP_ID and merge the repeated values of that  column.

EMP_ID	DATE	AMOUNT	PAYMENT_DESCRIPTION
25	07/12/2021	1500	DESC 1
	24/05/2022	2300	DESC 2
	11/09/2022	500	DESC 3
40	24/05/2022	1800	TRAVEL EXP 1
62	24/02/2023	1500	BUY HARDWARE

 

The above table shows that I would like to merge EMP_ID with the same value. I have attached the .jrxml file

How can I do something like that?  I think it can be possibly done by  using sub-report, but I do not know the way. I crated the .jrxml report on Jaspersoft Studio and then I used Spring Boot to populate the report. 

I have seen this post: https://community.jaspersoft.com/wiki/how-merge-table-rows-repeated-values  but I was unable to fix my issue because I am not very familiar with jasper reports.   

Thank you in advance!

 

[anish.rai]

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.

[Mehul Bamania]

Hi, 

 

Please see this article:

 

https://community.jaspersoft.com/wiki/how-merge-table-rows-repeated-values

 

https://community.jaspersoft.com/questions/1050351/merge-rows-when-repeated-values-table

[Mehak Rajkumar]

Dear user, did the articles we provided help with your question? If you need further assistance, please let us know.