Summarizing Item Wise quantity

[LuxCoder]

I want daily report of number of items booked subitem wise. For example: if i have following items booked:

QTY | ITM | SUBITEM
------- | ------ | ---------------
2 | Pant | Formal
1 | Pant | Cotton Style
2 | Pant | With Grip
3 | Pant | Cotton Style
2 | Shirt | Full Readymade
1 | Shirt | Full Readymade
1 | Shirt | Semi Readymade
4 | Pant | Formal
3 | Coat | Only
2 | Shirt | Full Readymade
2 | Pant | Cotton Style

Then i want report should give the following results:

Sl.No. | Quantity | Item | Sub-Item

1 | 6 | Pant | Formal
2 | 6 | Pant | Cotton-Style
3 | 2 | Pant | With Grip

Total Pants: 14


Sl.No. | Quantity | Item | Sub-Item

1 | 5 | Shirt | Full Readymade
2 | 1 | Shirt | Semi Readymade

Total Shirts: 6


Sl.No. | Quantity | Item | Sub-Item
1 | 3 | Coat | Only

Total Coats: 3

How can i do this stuff ? (",)

[gjack72]

Create 2 groups.
1st from your item, the 2nd from subitem. Create a summary off of qnty and place that in your group 2 header, this will give the count of subitems, then place a summary field off of qnty in group header 1 and that will give you your total by Item.

Hope that helps.

GJ