My SQL result as folllows Order NumOrder DateOrded ByProductColourQuantityOD1101-06-2016JohnPenBlue100OD1101-06-2016JohnPenRed150OD1101-06-2016JohnPenBlack250OD2202-06-2016SmithPenBlue50OD2202-06-2016SmithPenRed60OD2202-06-2016SmithPenBlack100OD2202-06-2016SmithShirtGreen15OD2202-06-2016SmithShirtBlack12OD2202-06-2016SmithShirtWhite13I want the table as follows in jasper report Sl No.Order NumOrder DateOrder ByProductColourQuantity1OD1101-06-2016JohnPenBlue100 Red150 Black2502OD2202-06-2016SmithPenBlue50 Red60 Black100 ShirtGreen15 Black12 White13 Varsha