Jump to content
We've recently updated our Privacy Statement, available here ×

combine dupplicate lines that have only one different column


hn.exvivo

Recommended Posts

Hello everyone , i m beginner in jasper report  i have mysql table that have dupplicate row with one different columns i need to eliminate this dupplication in jasper report and combine this rows . Like this 

ColACol BCol CCol D
1aabk
1acdk
1aefk
2bzal
2bmll
2bsql
2baal
2blkl
3cqsqm

 I need it to be like this 

Col ACol BCol CCol D
1a

ab

cd

ef

k
2b

za

ml

sq

aa

lk

l
3cqsqm

 How i can do it ? any help please 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

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...