Please help me to make report like that !

haihth

Hi all mem !

I have to make a report like that: ( from Sales Lines table)

Product Group Code 1
---Item no 11

---

Quantity

---

Amount
---Item no 12

---

Quantity

---

Amount
Product Group Code 2
---Item no 21

---

Quantity

---

Amount
---Item no 22

---

Quantity

---

Amount

Problem is:
If i want to group by Product Group Code, I can't group by quantity of same item no.

Please help me !
Thanks you.

abhinav0408

Just check your GroupTotalFeilds...and corresponding to this check DataItemTableView property and define proper keys,which u want to group

deepaknav

create the composite key : Product Group Code, Item No. (i.e. No. field in the Sales Line table).

then you group by product group code and within each product group code items can grouped and also quantity can summed.

haihth

deepaknav wrote:

create the composite key : Product Group Code, Item No. (i.e. No. field in the Sales Line table).

then you group by product group code and within each product group code items can grouped and also quantity can summed.

Thanks your reply.

But problem is:

I don't want to group by Product Group Code, I just only want group by same No. Item and use Product Group Code to seperate all item in same Product Group.

if i do that:
DataItemTableView:SORTING(Product Group Code,No.) ORDER(Ascending)
GroupTotalFields:Product Group Code, No.

Program will group by ProductGroupCode and Item No.

It's not what i want. I wanna group by Item No. , and seperate all item in same group into a one Product Group.

Can anybody help me?