0 Replies Latest reply on Oct 17, 2015 6:51 AM by wcallman

    Subsummary answer ID: 6198


      I used answer ID: 6198 as a potential solution to a subsummary problem I was having.

      The solution works but only if you have a data file that contains just three fields add a forth or fifth field

      into a datafile, as simple as a date and the use the recommended script it only brings back the first

      record total and does summarizes.

      Fields in database:

      E_Control Number       type: number

      E_Date                          type: date

      E_Estimate Number      type: number

      E_Referral                     type: text

      E_Total Job Cost           type: number

      E_totalsales                   type: summary


      Following the all recommended steps in ID: 6198 using E_Referral (subbing for region), E_Total Job Cost (subbing for amount), and E_totalsales (for TotalSales), and setting up the script verbatim, the solution when it is in a new layout only brings back the first record of data.


      HOWEVER, when I extract E_Referral, E_Total Job Cost and set up everything else in a stand alone database, the solution works perfectly.


      Does anyone have any thoughts?