5 Replies Latest reply: May 15, 2014 9:52 AM by Michael-B _ RSS

    Multiple Footers

    Michael-B _

      Hello all,

       

      I have a report that I need to capture data BELOW the detail level.  Unfortunately, this data is not present in each record.  If I select and trap this data as the FOOTER it will append to other records where the data isn't present.  How can I get around this?  I only want to see the data when it's present for that line item.

       

      Here is what the report looks like:

       

      [font="courier"] TELLER: 00094 LOCK BOX:   BUNDLE: 001

                          INV  TR   PDTO   DATE      PRIN BAL        ACTIVITY  PRIN ACTIVITY  ESC ACTIVITY  LATE CHG ACT   TIME    CASH

      ACCOUNT    NAME     IM  CD   DATE LAST ACT    ESC BAL          TOTAL     INT ACTIVITY  LPMI ACTIVITY  OPT INS ACT   OF DAY  MODE

       

      0000000001 CURRY   00241 AP  06/11 10/16/06     98669.19        1036.68          51.53           0.00        49.36   18:01    C

                            0                             0.00                        935.79           0.00         0.00

      0000000002 DERBY   00241 AP  06/10 09/27/06     62449.99         488.33          58.58           0.00         0.00   18:01    C

                            0                             0.00                        429.75           0.00         0.00

      0000000002 DERBY   00241 AP  06/11 11/28/06     62391.00         561.56          58.99           0.00        73.23   18:01    C

                            0                             0.00                        429.34           0.00         0.00

      0000000003 WATSON  00001 AP  05/09 11/16/06     51906.18         411.74          45.97          30.25         0.00   18:01    C

                            0                          -385.50                        335.52           0.00         0.00

                                                          ESCROW RETURN                       -30.25

      0000000004 ONEAL   00244 SRA 06/10 11/28/06     97293.72         279.98           0.00           0.00         0.00   18:01    C

                            0                         -3209.54                          0.00           0.00         0.00

           UNAP FUND BALANCE          279.98  AMOUNT TO UNAP FUND          279.98   PREV UNAP CD .   CURR UNAP CD F

      0000000004 ONEAL   00244 AP  06/10 10/31/06     97293.72        1215.16          51.34         291.77         0.00   18:01    C

                            0                         -3209.54                        872.05           0.00         0.00

                                                          ESCROW RETURN                      -291.77

      0000000005 MCDANIE 00244 SWA 06/10 11/28/06     30441.15          16.22           0.00           0.00         0.00   18:01    C

                            0                           692.72                          0.00           0.00         0.00

           UNAP FUND BALANCE           16.22  AMOUNT TO UNAP FUND           16.22   PREV UNAP CD .   CURR UNAP CD U

      0000000005 MCDANIE 00244 AP  06/10 11/28/06     30441.15         367.82         133.37          43.36         0.00   18:01    C

                            0                           692.72                        191.09           0.00         0.00

      0000000005 MCDANIE 00244 FEA 06/09 11/28/06     30574.52          15.00           0.00           0.00         0.00   18:01    C

                            0                           649.36                          0.00           0.00         0.00

                   FEES:           15.00         SPEEDPAY

      0000000006 GREEN   00248 AP  06/11 11/28/06    100875.04        1408.30          75.40         431.23       159.26   18:01    C

                            0                         -9946.70                        742.41           0.00         0.00

                                                          ESCROW RETURN                      -431.23 /font[/quote]My problem lies with the following data:

       

      ESCROW RETURN

      UNAP FUND BALANCE

      FEES

       

      Does this make sense?

       

      Any assistance is GREATLY appreciated!

       

      Thx!

      Michael

        • Multiple Footers
          Michael-B _

          Hello all,

           

          I have a report that I need to capture data BELOW the detail level.  Unfortunately, this data is not present in each record.  If I select and trap this data as the FOOTER it will append to other records where the data isn't present.  How can I get around this?  I only want to see the data when it's present for that line item.

           

          Here is what the report looks like:

           

          [font="courier"] TELLER: 00094 LOCK BOX:   BUNDLE: 001

                              INV  TR   PDTO   DATE      PRIN BAL        ACTIVITY  PRIN ACTIVITY  ESC ACTIVITY  LATE CHG ACT   TIME    CASH

          ACCOUNT    NAME     IM  CD   DATE LAST ACT    ESC BAL          TOTAL     INT ACTIVITY  LPMI ACTIVITY  OPT INS ACT   OF DAY  MODE

           

          0000000001 CURRY   00241 AP  06/11 10/16/06     98669.19        1036.68          51.53           0.00        49.36   18:01    C

                                0                             0.00                        935.79           0.00         0.00

          0000000002 DERBY   00241 AP  06/10 09/27/06     62449.99         488.33          58.58           0.00         0.00   18:01    C

                                0                             0.00                        429.75           0.00         0.00

          0000000002 DERBY   00241 AP  06/11 11/28/06     62391.00         561.56          58.99           0.00        73.23   18:01    C

                                0                             0.00                        429.34           0.00         0.00

          0000000003 WATSON  00001 AP  05/09 11/16/06     51906.18         411.74          45.97          30.25         0.00   18:01    C

                                0                          -385.50                        335.52           0.00         0.00

                                                              ESCROW RETURN                       -30.25

          0000000004 ONEAL   00244 SRA 06/10 11/28/06     97293.72         279.98           0.00           0.00         0.00   18:01    C

                                0                         -3209.54                          0.00           0.00         0.00

               UNAP FUND BALANCE          279.98  AMOUNT TO UNAP FUND          279.98   PREV UNAP CD .   CURR UNAP CD F

          0000000004 ONEAL   00244 AP  06/10 10/31/06     97293.72        1215.16          51.34         291.77         0.00   18:01    C

                                0                         -3209.54                        872.05           0.00         0.00

                                                              ESCROW RETURN                      -291.77

          0000000005 MCDANIE 00244 SWA 06/10 11/28/06     30441.15          16.22           0.00           0.00         0.00   18:01    C

                                0                           692.72                          0.00           0.00         0.00

               UNAP FUND BALANCE           16.22  AMOUNT TO UNAP FUND           16.22   PREV UNAP CD .   CURR UNAP CD U

          0000000005 MCDANIE 00244 AP  06/10 11/28/06     30441.15         367.82         133.37          43.36         0.00   18:01    C

                                0                           692.72                        191.09           0.00         0.00

          0000000005 MCDANIE 00244 FEA 06/09 11/28/06     30574.52          15.00           0.00           0.00         0.00   18:01    C

                                0                           649.36                          0.00           0.00         0.00

                       FEES:           15.00         SPEEDPAY

          0000000006 GREEN   00248 AP  06/11 11/28/06    100875.04        1408.30          75.40         431.23       159.26   18:01    C

                                0                         -9946.70                        742.41           0.00         0.00

                                                              ESCROW RETURN                      -431.23 /font[/quote]My problem lies with the following data:

           

          ESCROW RETURN

          UNAP FUND BALANCE

          FEES

           

          Does this make sense?

           

          Any assistance is GREATLY appreciated!

           

          Thx!

          Michael

          • Multiple Footers
            Grant Perkins

            Hi Michael,

             

            That one doesn't look like it will give up without a fight. Nice challenge.

             

            See if this works for you.

             

            For the detail template I assume you are using a 2 line sample and trapping on the Account number - or at least on that line?

             

            That's fine, pick what field you want from those lines.

             

            Now define an APPEND template using the same sample and trap. Looks like you will always have at least 2 lines so we should be safe. NOTE: The APPEND TRAP DEFINITION MUST NOT END AFTER[/b] THE DETAIL TRAP ENDS. So all trap positions must be the same as or to the LEFT of the detail trap positions. This is because an append templates' trap must appear to be occurring BEFORE the detail records. (But an exact match seems to be OK.)

             

            On one of the two lines paint a field in the HORIZONTAL position of the UNAP FUND BALANCE field. Go into the advanced properties for that field and set the 'Start Field On' value to all or part of "UNAP FUND BALANCE" as a PRECEDING STRING. However much you need of it will do. You will see what I mean in a moment. If you need any of the other UNAP field values I would suggest painting them on the same line for ease of maintenance.

             

            On the other line do the same for the "FEES" field but using the Preceding string "FEES" of course.

             

            A little further across the line do the same for the ESCROW field, again with a suitable unique preceding string.

             

            Confirm the template, go to your table and you should see 3 (or more if you defined more fields) new columns which are populated when they need to be or are otherwise empty.

             

            Hopefully this will work for the entire report - it certainly works for the posted sample!

             

            Let us know how you get on.

             

            Have fun.

             

            Grant

            • Multiple Footers
              Grant Perkins

              Hi Michael,

               

              That one doesn't look like it will give up without a fight. Nice challenge.

               

              See if this works for you.

               

              For the detail template I assume you are using a 2 line sample and trapping on the Account number - or at least on that line?

               

              That's fine, pick what field you want from those lines.

               

              Now define an APPEND template using the same sample and trap. Looks like you will always have at least 2 lines so we should be safe. NOTE: The APPEND TRAP DEFINITION MUST NOT END AFTER[/b] THE DETAIL TRAP ENDS. So all trap positions must be the same as or to the LEFT of the detail trap positions. This is because an append templates' trap must appear to be occurring BEFORE the detail records. (But an exact match seems to be OK.)

               

              On one of the two lines paint a field in the HORIZONTAL position of the UNAP FUND BALANCE field. Go into the advanced properties for that field and set the 'Start Field On' value to all or part of "UNAP FUND BALANCE" as a PRECEDING STRING. However much you need of it will do. You will see what I mean in a moment. If you need any of the other UNAP field values I would suggest painting them on the same line for ease of maintenance.

               

              On the other line do the same for the "FEES" field but using the Preceding string "FEES" of course.

               

              A little further across the line do the same for the ESCROW field, again with a suitable unique preceding string.

               

              Confirm the template, go to your table and you should see 3 (or more if you defined more fields) new columns which are populated when they need to be or are otherwise empty.

               

              Hopefully this will work for the entire report - it certainly works for the posted sample!

               

              Let us know how you get on.

               

              Have fun.

               

              Grant

              • Multiple Footers
                Michael-B _

                Grant -

                 

                THANK YOU SO MUCH!!  It worked!

                 

                I never would have thought of that.  I tried everything I could think of and was unable to get the desired results.

                 

                I really appreciate all of your time and assistance!!

                 

                You ROCK!

                • Multiple Footers
                  Michael-B _

                  Grant -

                   

                  THANK YOU SO MUCH!!  It worked!

                   

                  I never would have thought of that.  I tried everything I could think of and was unable to get the desired results.

                   

                  I really appreciate all of your time and assistance!!

                   

                  You ROCK!