How can I arrange my sql result in jasper report in below mentioned format

[varsha.jacob]

My SQL result as folllows

Order Num	Order Date	Orded By	Product	Colour	Quantity
OD11	01-06-2016	John	Pen	Blue	100
OD11	01-06-2016	John	Pen	Red	150
OD11	01-06-2016	John	Pen	Black	250
OD22	02-06-2016	Smith	Pen	Blue	50
OD22	02-06-2016	Smith	Pen	Red	60
OD22	02-06-2016	Smith	Pen	Black	100
OD22	02-06-2016	Smith	Shirt	Green	15
OD22	02-06-2016	Smith	Shirt	Black	12
OD22	02-06-2016	Smith	Shirt	White	13

I want the table as follows in jasper report

 

Sl No.	Order Num	Order Date	Order By	Product	Colour	Quantity
1	OD11	01-06-2016	John	Pen	Blue	100
					Red	150
					Black	250
2	OD22	02-06-2016	Smith	Pen	Blue	50
					Red	60
					Black	100
				Shirt	Green	15
					Black	12
					White	13

 

 

Varsha

[Filip C.]

Make sure the result set is ordered on SI No. - Order By - Product - Colour

Create 4  groups on SI No. - Order By - Product - Colour

Put all your fields in the group header of Colour

Uncheck 'Print repeated' values for fields SI No. - Order Num - Order date - Order By - Product

Indicate 'Print when group changes'

SI No. -> SI No.

Order Num -> SI No.

Order Date -> SI No.

Order By -> Order By

Product -> Product

That should do the trick ...