2 Replies Latest reply: May 15, 2014 10:10 AM by mikequin _ RSS

    Picking up totals in detail

    mikequin _

      How do i filter out the detail from the totals being picked up from the last employee, here is a sample payroll report

       

       

      SMITH, JANE                     1 REGULAR              7100      99400                                              

      1845 XXX-XX-XXXX                2 OVERTIME  210000      850      17850                                              

      26 S9/S9 1    201               3 DOUBLETI                         000                                              

        14.0000 Hourly                                                                               

      EMPLOYEE TOTAL                                       7950     117250                                              

      -


      FINANCE                         1 REGULAR              7100      99400                                              

      DEPARTMENT TOTALS               2 OVERTIME             -750     -15750                                              

          1 EMPLOYEES    3 CHECKS      3 DOUBLETI            -3200     -89600                                                                               

      DEPARTMENT TOTAL                                     3150      -5950                                              

      -


      Corporate                       1 REGULAR            809950   42781598                      C1 CHECKING 1     1036677

      BRANCH TOTALS                   2 OVERTIME            20600     673330                      C2 CHECKING 2      345573

        137 EMPLOYEES  166 CHECKS      3 DOUBLETI             -050     -33140                      C9 CHECKING NE   32119502

                                       4 JURY DUT                         000                      CS CHILD SUPRT      36692

                                       B BONUS                            000                      DD DIRECT DEPO        000

                                       H HOLIDAY                          000                      DP DOMESTIC PA       5476

                                       M MISC                             000                      G1 GARNISH 1        35631

                                       R RETRO PA                     1585445                      GT GTL             141823

                                       S MAJOR SI             3600     111366                      K1 403B LOAN 1     321673

                                       V VACATION                         000                      K2 403B LOAN 2      85102

                                      10 CASE REG            16750     721250                      S1 SAVINGS 1        74000

                                      1P MED HMO                      -227156                      S2 SAVINGS 2        16500

                                      20 ADMIN RE             8975     177500                                                                               

      30 CALL REG            29842     190710                                                                               

      36 CAREER L                       34616                                                                               

      3P MED PPO                      -183190                                                                               

      4P MED PPO                        -6937                                                                               

      5P MED PPO                        -7593                                                                               

      AE AUTO EAR                     3338472                                                                               

      AL AUTO LEA                         000                                                                               

      BR BEREAVEM              650      14618                                                                               

      CN CHRISTMA                         000                                                                               

      CP DEP FSA                      -114995                                                                               

      D1 DENTAL P                        -811                                                                               

      DP DENTAL P                      -53293                                                                               

      ED EXECUTIV                       80668                                                                               

      FL FLOATING                         000                                                                               

      GT GTL                           144509                                                                               

      H1 HSA EE 1                      -89970                                                                               

      H3 HSA FAM                      -198610                                                                               

      H4 HSA FAM                       -17885                                                                               

      K1 403B EE                     -2225943                                                                               

      K3 457 EE                        -93828                                                                               

      MP MED FSA                      -104033                                                                               

      NL NO LUNCH              200       5408                                                                               

      PS PRECEPTO                       40000                                                                               

      PT PTO                 82552     830136                                                                               

      SV SEVERANC                     4588281                                                                               

      TW TEAM WOR                     1140000                                                                               

      V1 VISION 1                        -126                                                                               

      VP VISION 1                       -8581                                              

       

      And this is the table view, Jane Smith only has 3 detail records, but is picking up the detail from the lines after her record

       

      SMITH, JANE      1     REGULAR             7100     99400               

      SMITH, JANE      2     OVERTIME             -750     -15750               

      SMITH, JANE      1     REGULAR           809950     42781598     C1     CHECKING 1     1036677

      SMITH, JANE      2     OVERTIME            20600     673330     C2     CHECKING 2     345573

      SMITH, JANE      4     JURY DUT               0     CS     CHILD SUPRT     36692

      SMITH, JANE      B     BONUS               0     DD     DIRECT DEPO     0

      SMITH, JANE      H     HOLIDAY               0     DP     DOMESTIC PA     5476

      SMITH, JANE      M     MISC               0     G1     GARNISH 1     35631

      SMITH, JANE      R     RETRO PA               1585445     GT     GTL     141823

      SMITH, JANE      S     MAJOR SI             3600     111366     K1     403B LOAN 1     321673

      SMITH, JANE      V     VACATION               0     K2     403B LOAN 2     85102

      SMITH, JANE     10     CASE REG            16750     721250     S1     SAVINGS 1     74000

      SMITH, JANE     1P     MED HMO               -227156     S2     SAVINGS 2     16500

      SMITH, JANE     20     ADMIN RE             8975     177500               

      SMITH, JANE     30     CALL REG            29842     190710               

      SMITH, JANE     36     CAREER L               34616               

      SMITH, JANE     3P     MED PPO               -183190               

      SMITH, JANE     4P     MED PPO               -6937               

      SMITH, JANE     5P     MED PPO               -7593               

      SMITH, JANE     AE     AUTO EAR               3338472               

      SMITH, JANE     AL     AUTO LEA               0               

      SMITH, JANE     BR     BEREAVEM              650     14618               

      SMITH, JANE     CN     CHRISTMA               0               

      SMITH, JANE     CP     DEP FSA               -114995               

      SMITH, JANE     D1     DENTAL P               -811               

      SMITH, JANE     DP     DENTAL P               -53293               

      SMITH, JANE     ED     EXECUTIV               80668               

      SMITH, JANE     FL     FLOATING               0               

      SMITH, JANE     GT     GTL               144509               

      SMITH, JANE     H1     HSA EE 1               -89970               

      SMITH, JANE     H3     HSA FAM               -198610               

      SMITH, JANE     H4     HSA FAM               -17885               

      SMITH, JANE     K1     403B EE               -2225943               

      SMITH, JANE     K3     457 EE               -93828               

      SMITH, JANE     MP     MED FSA               -104033               

      SMITH, JANE     NL     NO LUNCH              200     5408               

      SMITH, JANE     PS     PRECEPTO               40000               

      SMITH, JANE     PT     PTO            82552     830136               

      SMITH, JANE     SV     SEVERANC               4588281               

      SMITH, JANE     TW     TEAM WOR               1140000               

      SMITH, JANE     V1     VISION 1               -126               

      SMITH, JANE     VP     VISION 1               -8581     

       

      Any assistance would be appreciated

        • Picking up totals in detail
          Olly Bond

          Hello Mike,

           

          It sounds like you might need to use the "invisible" data to distinguish between the records you want to trap and the records you don't.

           

          Jane needs to be trapped for Regular, Overtime and Doubletime, I guess, but we need to avoid all the totals below for Jury Duty and the rest of it.

           

          I presume that you're trapping Jane's name as an Append template, and the Detail is picking up the classifications and values.

           

          If you introduce a Footer template that picks out the Employee Total, then (I assume you have v10) edit the template properties of the Append template so that this is Cleared By the instance of the Footer template.

           

          You will still have records in the table for all the totals, but they will have a null value for the employee name so you can filter them out easily.

           

          Hope this helps,

           

          Olly