I have a dataset like this. ColA ColB ColC ColD A1 B1 C1 D1 A1 B2 C1 D1 A1 B2 C2 D2 A2 B1 C1 D1 A2 B1 C1 D1 I want my report to display like this. 1 A1 B1 C1 D1 2 A1 B2 C1 D1 C2 D2 3 A2 B2 C1 D1 C2 D2 Because of the layout i dont use table, what is the right direction to do this? Query is executed in code and pass a JRResultSet as datasource to report. I'm using Jasperreport 6.9.0. Thanks a lot.