Results 1 to 4 of 4

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

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Apr 2007
    Location
    Cebu PH
    Posts
    95

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

    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.

  2. #2
    Frenzied Member
    Join Date
    Aug 2006
    Location
    India, Punjab, Bhatinda
    Posts
    1,689

    Red face Re: CR 11 & VB6: Help with Groups Total..

    Welcome cometburn
    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...

  3. #3

    Thread Starter
    Lively Member
    Join Date
    Apr 2007
    Location
    Cebu PH
    Posts
    95

    Re: CR 11 & VB6: Help with Groups Total..

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

  4. #4
    Frenzied Member
    Join Date
    Aug 2006
    Location
    India, Punjab, Bhatinda
    Posts
    1,689

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

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width