Hai All, I need help in this generating jasper report in I Report 5.5.0. Please check and Update

[ssr452]

I Have Query result Like This.

--- Query

Select Companyid,itemid,sum(Qty),Sum(Amount) From ItemSummary group by companyid,itemid;

---- Result set

Company Id.       Item id.        Qty.         Amount

UNIT I                  ITEM A         10           1000

UNIT I                  ITEM B          20          3000

UNIT I                  ITEM C          30          5000

 

UNIT II                ITEM  A          10        1000 

UNIT II                ITEM B           20        2000

 

---- I want to display my jasper like this

Global Industries                                                    Item Summary Details                                                  ---- > Tiltle Band

Company Id	Item Id.	Qty.	Amoumt
UNIT I	ITEM A	10	1000
	ITEM B	20	3000
	ITEM C	30	5000
	TOTAL	60	9000
UNIT II	ITEM A	10	1000
	ITEM B	20	2000
	TOTAL	30	3000

[mtn]

to be clear do you want the necessary steps for building the report? Kan you give a bit more information on your question?