Results 1 to 3 of 3

Thread: [RESOLVED] CR11 Running Total Based on Group Name?

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Nov 2001
    Location
    Mass USA
    Posts
    1,674

    Resolved [RESOLVED] CR11 Running Total Based on Group Name?

    Hi,
    I need to do some summarizing on the report footer. There are calculations that I need to display based on each group name. How would I go about creating running totals based on group names?

    thanks

  2. #2
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: CR11 Running Total Based on Group Name?

    You create a running total and set it to reset on change of group. See attached image.
    Attached Images Attached Images  
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1

  3. #3

    Thread Starter
    Frenzied Member
    Join Date
    Nov 2001
    Location
    Mass USA
    Posts
    1,674

    Re: CR11 Running Total Based on Group Name?

    Thanks, got it by just running the total based on the group criteria. thanks again for the fast reply.

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