[RESOLVED] CR 11 & VB6: Help with Groups Total..

[cometburn]

Experts need help here!

Ive searched the forums but havent found the answer to my problem.

how can i do this? with CR 11?

Group 1
item 1
....
item N

(total of items)

Group 1
item 1
....
item N

(total of items)

how can i get total items? im using CR 11 and VB...

can somebody please help me.

[VBFnewcomer]

Welcome cometburn :wave: :afrog:
Well there is an option called Running Totals Fields(looks like E) in the Field Explorer. Right click it and select New... Give a name in the Running Total Name(Default is RTotal0). You should find Field to summarize select the necessary field from the Tree view on the left (click + if all fields are not visible) Now click Type of Summary (count,max,min etc). Now go to option called Reset and select On change of Group, select the group (which should be available in the dropdown box). Now click ok. In thefield explorer you should find the totals field with the name you have given, pull it and place it in the desired location, in your case it might be footer of item N group
It is presumed you have already created the necessay groupings & sortings
Hope I was able to help you... :wave:

[cometburn]

Thanks! you really solved my problem. been looking for this for about an hour now.

[VBFnewcomer]

Also if you are interested see the creation of a multi column report in my signature.
Glad I was able to help you :wave: