13 Replies Latest reply on May 4, 2012 9:03 AM by TC

    Sub-Summary Report does not show correct Total Values

    TC

      All,

      I have 3 tables:

       

       

      Filter Requirements Field
      __Kp_FilterID
      RatingOfFilter (Text)
      SizeOfFilter (Text)
      RatingSize (Calculation appending two previous Fields)
      Qty (Niumber)
      Total Qty (Summary Calculation - Total of Qty)

       

      Months
      __Kp_MonthsID
      Months

       

      Join Table
      __Kp_JoinID
      _kf_FilterID
      _kf_MonthID

       

      When I create a list layout using the Filter table , output is correct correctly showing all filter records with the correct month(s).
      When I add a Sub-Summary part above with the break field on Months and another Sub-summary part above and below (below for testing) with the break field on RatingSize, the output is correct after I sort on Months and RatingSize
      However, when I add the Total Qty field to both the upper and lower sub-summary part with the break field as rating size, I get two different values and neither is correct:
      for the above part, I get the value for the first record in the break area
      For the below part, I get the value for the last record in the break area

       

      The only time the values are correct is when there is only on filter of X for a specific month.

       

      Any ideas?

       

      Thanks in advance

      Tym