Results 1 to 2 of 2

Thread: [Resolved] Additional group Sum question

Threaded View

  1. #1

    Thread Starter
    Member
    Join Date
    Mar 2006
    Posts
    50

    [Resolved] Additional group Sum question

    I noticed a post which asks about summing and was resolved by simply doing a 'Summary' from the Crystal menu. I have the same problem, but I need one value (which must be in the report) removed from the summary.

    For example there's a field:
    {Intran.Quantity} which I need summed on a group level, however I need it filtered by the 'Type' field: {Intran.Type}. The report SQL pulls in several 'Type' (IN, CM, RC). I need just the IN and CM types summed on a group level. Just running a summary does give me the correct groupings, but the results are high because the RC's are also included.
    Last edited by BIGGY; May 4th, 2006 at 11:39 AM.

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