Jump to content
Changes to the Jaspersoft community edition download ×

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


fiyov46807

Recommended Posts

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_IDDATEAMOUNTPAYMENT_DESCRIPTION
2507/12/20211500DESC 1
24/05/20222300DESC 2
11/09/2022500DESC 3
4024/05/20221800TRAVEL EXP 1
6224/02/20231500BUY 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!

 

Link to comment
Share on other sites

  • 4 weeks later...
  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...