Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Posts
    1

    Unanswered: Summary Field Help

    Here's the deal. I have a report with colums a,b, c, d, and e. All from the same database.

    Field a is a date field, field b and c are normal string fields. Field d is what I need to summarize. However, I need to summarize that field based on distinct values of fields b and c. For example, say Field b is a list of part numbers. Field c is a list of operators who produced the part numbers, and field d is number of parts produced. This report I run is a monthly report. So the same part number (field b) and operator (field c) combination can appear multiple times, and I need the sum of number of parts produced OF that combination.

    Does that make sense? For example, if Part number A1 and Operator 100, if that combination shows up on 8 different days within the month, I need to sum up the number of A1 parts produced by Operator 100 within that month timeframe.

    How do I do this is Crystal Reports, in a standard report design? Everytime I try and do a summary expression or formula summary, I get the ENTIRE summary of parts produced, not selective.

  2. #2
    Join Date
    Oct 2003
    Posts
    357
    Hi,
    Try this

    Group the Records first by B and by C

    Create a Running Total Field having the field d. Select summary type as Sum
    and in the Reset Option select Group filed C

    Insert this Running total filed in Group Footer of C

    Madhivanan
    Last edited by Madhivanan; 01-11-05 at 07:20.

Posting Permissions

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