Need a help with grouping and totaling

yopstar25

Hi,

Will someone help me how to modify the version of the report 5970(Service contract) with grouping the ItemNo by Serviceintervall and totaling ?

pls see the attached screenshot

Can you help me please...Thanks a lot!

einsTeIn.NET

You have to use a key that contains Item No. and Service Period.

yopstar25

hi,
first thanks for the quick reply.
so.
I have added the new key:
I set the the keyfields in the GroupTotalFields of Dataitem : Service Contract Line

GroupTotalFields = Item No.,Service Period

After sort and group the Itemno by Service period how can i do the following:

Item No:
80001
1M = 1x
2M = 0x
3M = 0x

80201
1M = 3x
2M= 1x
3M= 1x

Etc….


may i use a Footer or Groupfooter section or any code on the GroupFooter?
Any help would be greatly appreciated.thanks...

vijay_g

if everything is right(key,property and sections) then do not forget to use CurrReport.TOTALSCAUSEDBY function in case of grouping for more than one field in Groupheader and Groupfooter sections.

yopstar25

hi.
thanks, the CurrReport.TOTALSCAUSEDBY soved the problem..

but how can i make a total of each group?

the result is:
Item

---

Service Period

80001

---

1M
80001

---

1M

80002

---

1M
80002

---

1M
80002

---

2M
80002

---

2M


80102

---

1M
80102

---

1M
80102

---

1M
80102

---

2M
80102

---

2M


it's possible to have a total of the Field: Service Period like so:


80001 1M
Total = 1

80002 1M
Total = 2

2M
Total = 2

80102 1M
Total = 3

2M
Total = 2

thanks in advance

yopstar25

i 've solved it with a new section & a counter
thanks a lot. :thumbsup: