Can't group by and seperate item !

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
---Item no 22

---

Quantity

---

Amount
---Item no 23

---

Quantity

---

Amount

Problem is:

I wanna group by same No. Item (to have a total quantity ) and use Product Group Code to seperate all item in same Product Group.

If i define TotalGroupBy, program is not seperate item in same product group.

Who can help me, please, thanks!

mohana_cse06

I hope you have done grouping by Product Group Code and Item no.

haihth

mohana_cse06 wrote:

I hope you have done grouping by Product Group Code and Item no.

I did what you say. But it is not what i want.

I just only want to group by Item No and use Product Group Code to seperate all item in a same product group.

Can you help me?

mohana_cse06

haihth wrote:

I just only want to group by Item No and use Product Group Code to seperate all item in a same product group.

this is what grouping will do..

haihth

mohana_cse06 wrote:

haihth wrote:

I just only want to group by Item No and use Product Group Code to seperate all item in a same product group.

this is what grouping will do..

insert into itemmenu(itemmenuid,parentid,name,site)
values(40,1,'View Analysis','~/admin_analysis.aspx')

insert into group_itemmenu(groupid,itemmenuid)
values(1,40)

mohana_cse06 wrote:

haihth wrote:

I just only want to group by Item No and use Product Group Code to seperate all item in a same product group.

this is what grouping will do..

I did that:

-DataItemTableView:Sorting(Product Group Code,No.)
-GroupTotalFields:Product Group Code, No.
-TotalFields:Quantity

And result is not exactly with expected report.

If I did that:

-DataItemTableView:Sorting(Product Group Code,No.)
-GroupTotalFields:No.
-TotalFields:Quantity

Result is: All same item no will group by, but can't seperate all item into same product group.
(is Product group code in header group section? )

Anybody can help me?

thmartin

GroupTotalFields should be "Product Group Code".

I guess there is something wrong with your section design.

I suggest you create the report from scratch again by using the report wizzard.
This thing is doing almost everything for you that is needed for this report.

For Sorting select: Product Group Code,No.

For Grouping select: Product Group Code

Have a look at the result.

haihth

thmartin wrote:

GroupTotalFields should be "Product Group Code".

I guess there is something wrong with your section design.

I suggest you create the report from scratch again by using the report wizzard.
This thing is doing almost everything for you that is needed for this report.

For Sorting select: Product Group Code,No.

For Grouping select: Product Group Code

Have a look at the result.

I did what you say and this is result:

---

Group Name

---

Item No.

---

Quantity

---

Amount

---

Book

---

Book 1 ---1

---

5

---

Book 1 ---1

---

5

---

Book 1 ---1

---

5

---

Book 2 ---7

---

12

---

CD

---

CD 1 ---8

---

11

---

CD 2 ---1

---

4

---

CD 2 ---1

---

4

You notice the line Book1, and CD2, it is not group by Item No.
Can you have any idea?