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 D1aabk1acdk1aefk2bzal2bmll2bsql2baal2blkl3cqsqm I need it to be like this Col ACol BCol CCol D1aab cd ef k2bza ml sq aa lk l3cqsqm How i can do it ? any help please