7 Replies Latest reply: May 15, 2014 10:02 AM by Grant Perkins RSS

    Two line trap that occasionally Spans two pages

    CapQ _

      I have a report that has provides information on customers.   A trap has been created to capture various transaction details.  This trap grabs data from two lines.   Sometimes the second line of data is sent to the next page and the fields of the 2nd line are then NULL.

       

      How do I capture the orphaned 2nd line of data and append it to the detail of the previous page's null values??

       

      Here is sample where it happens:

       

      VISA COMM CNP B     2.25 % $ 0.10               0.01              1                0.10    2.5100                 0.28                 0.00                 

                       0.0925 %  0.000                  0.00              0                0.00    0.2800                 4.08                 0.00               

      VISA COMM CNP C     2.20 % $ 0.10               0.00              0                0.00    0.1675                 0.00                 0.00                 

                       0.0925 %  0.000                  0.00              0                0.00    0.1800                 3.24                 0.00               

      VISA COM RET B      2.20 % $ 0.10              26.00              1                0.67    2.4600                 0.92                 0.00                                                                               

      << PAGE BREAK IS HERE>>

                                                   PAGE    52 FOR qwe: 09875 CAP

                                                                                      gfd23                                               REPORT                   AS OF: 07/31/2008  PAGE:   9966                      

      JOB: Treport  PGM: PMS500                                                                             RUN: 08/01/2008  05:19:30                                                                               

      PRT: N                      

                                                             -


        Some FEES -


                                                                                       

      I COST/      $ DEBITS/    ITEMS DB/      CHANGE FEE/    DISCOUNT RATE/                  FEE CTD             DIST CTD            

      PLAN DESCRIPTION          A COST        $ CREDITS    ITEMS CR       MENT FEE      PER ITEM COST                  FEE YTD             DIST YTD          

      -


       

                       0.0925 %  0.000                  0.00              0                0.02    0.2800                 2.75                 0.00             

      VISA VSP CNP        2.30 % $ 0.10               0.00              0                0.00    0.1675                 0.00                 0.00               

                       0.0925 %  0.000                  0.00              0                0.00    0.1800                 0.84                 0.00             

      VISA VSP RTL        2.10 % $ 0.10               0.00              0                0.00    0.1675                 0.00                 0.00               

      /code

       

      Here is screen shot of the template being used:

       

      http://www.capitalq.com/PlanTemplate.gif[/img]

       

      When the reports gets to the end of the page the 2nd line will begin after the header and title of the following page.

       

      How do I append this to the row that started on the previous page??

        • Two line trap that occasionally Spans two pages
          Data Kruncher

          Hello and welcome to the forum!

           

          All you'll need to do to overcome this is define a page header template that accurately represents the header area. You do not need to define any fields within the page header template.

           

          Based on your sample I created a 16 line header template, trapping the word page on line 5. Monarch then put the orphaned row back together with its first row automatically.

           

          HTH,

          Kruncher

            • Two line trap that occasionally Spans two pages
              CapQ _

              Sounds good, but I have several pages of data on each client and multiple section titles other than --- Some Fees ---.  It will not always start at the same place. 

               

              Do I run a second pass just for Orphans and then Append it??  I created a second append template but it throws the orphan with the row underneath where I wnat the data.  I  don't see where I can create a formula to look down one row.

                • Two line trap that occasionally Spans two pages
                  Data Kruncher

                  Unfortunately, unlike as in Excel, you cannot have table records reference values in other records.

                   

                  It may come to multiple passes, but that isn't usually the case.

                   

                  Can you post another/more sample(s) of your troublemakers for us visual types?

                    • Two line trap that occasionally Spans two pages
                      CapQ _

                      Here is a sample that shows a complete record (too big for two complete records).  We make multiple passes on the file via the COM object.

                       

                      JOB: PRINT321  PGM: ABC321                                                                             RUN: 10/01/2008  07:04:22                                                                               

                      01 LVL: 00321 MEMINE             02 LVL: 12345                 03 LVL: 54321                   04 LVL: 12345 MY ACCOUNTS                                                                  

                      05 LVL: 54321                       06 LVL: 43212 MYDIREC ACCOUNTS    07 LVL: 98765 MYSTUFF                                                                               

                      PRT: N                                                                               

                      98765                                                                               

                      123 ANYWHERE LANE                                                                               

                      ANYWHERE, NN 12345-                                                                               

                      MY OWN ACCOUNTS                                                                               

                      ME MYSELF AND I                                                                               

                      543 ANYWHERE LANE                                                                               

                      MY TOWN            MY STATE 98765                                                                               

                      PAGE     1 FOR LVL: 98765 MYSTUFF                                                                               

                      ABC   X123X                           GIVE ME THE MONEY NOW AND DETAIL REPORT                   AS OF: 09/30/2008  PAGE:  13890                                                              

                      JOB: PRINT321  PGM: ABC321                                                                             RUN: 10/01/2008  07:04:22                                                                               

                      01 LVL: 00321 MEMINE             02 LVL: 12345                 03 LVL: 54321                   04 LVL: 12345 MY ACCOUNTS                                                                  

                      05 LVL: 54321                       06 LVL: 43212 MYDIREC ACCOUNTS    07 LVL: 98765 MYSTUFF                                                                               

                      PRT: N                                                                               

                      -


                      CUSTOMER PROFILE -


                                                                                                       

                      CUSTOMER #: 123456789                        STORE #: 0000000000                          OPEN DATE:    2003-03-04                                                                               

                      CUSTOMER                                     SUBSID#: 00000                               BEERS VENDOR: STUF                                                                               

                      123 ADDRESS DR                               MONTH:   C                                   WINE VENDOR:  STUF                                                                               

                      ACTIVE:  O                                   BILLING DDA:  12345678                                                                               

                      YOUR TOWN                  WI 00000          CUSTOMER CLASSIFICATION: BEERS               CUSTOMER SIC: 000007011                                                                               

                      PHONE #: 321-123-0000                                                                              BPS:        123456789                                                                          

                      -


                                                                                                       

                      -


                        PROFITABILITY -


                                                                                                       

                      DESCRIPTION    CTD UNITS        CTD VOLUME           YTD VOLUME          CTD EXPENSE           CTD INCOME       CTD PROFIT/LOSS      YTD PROFIT/LOSS                                              

                      -


                                                                

                      SALES                                                                               

                      LOCAL             375        124,322.28           852,822.15                                                                               

                      NON-LOCAL          47         15,710.89           216,120.90                                                                               

                      CREDITS                                                                               

                      LOCAL              11          3,949.81            33,302.97                                                                               

                      NON LOCAL           4          1,077.79             9,411.25                                                                               

                      NET SALES           437        135,005.57         1,026,228.83             2,613.14             2,613.14                 0.00                 0.00                                                

                      RETURNS               0              0.00                 0.00                 0.00                 0.00                 0.00                 0.00                                                

                      ADJUSTMENTS           0              0.00                 0.00                 0.00                 0.00                 0.00                 0.00                                                

                      OTHER VOLUME          0              0.00                 0.00                 0.00                 0.00                 0.00                 0.00                                                

                      TOTAL I/C                        2,363.60            15,723.93                                                                               

                      OURTAX CARD                        113.63               782.59                                                                               

                      DRINK  FEES         628                                                       13.32                13.32                 0.00                 0.00                                                

                      OTHER FEES            0                                                        0.00                 0.00                 0.00                 0.00                                                

                      -


                                                                

                      TOTALS                                                                     2,626.46             2,626.46                 0.00                 0.00                                                

                      -


                                                                                                       

                      -


                        LIQUORED FEES -


                                                                                                       

                      INTERCH COST/      $ DEBITS/    ITEMS DB/    INTERCHANGE FEE/    MISCOUNT RATE/      CUSTOMER FEE CTD    CLIENT DIST CTD                                                    

                      PLAN DESCRIPTION        OURTAX COST        $ CREDITS    ITEMS CR     ASSESSMENT FEE      PER ITEM COST       CUSTOMER FEE YTD    CLIENT DIST YTD                                                  

                      -


                                                                

                      CARD SIGN STND      2.70 % $ 0.10               0.00              0                0.00    0.0900                 0.00                 0.00                                                       

                                       0.0125 %  0.000                  0.00              0                0.00    0.0900                28.00                 0.00                                                     

                      CARD SIGN SURF      2.30 % $ 0.10          15,375.79             40              357.52    0.0900               389.30                 0.00                                                       

                                       0.0125 %  0.000                  0.00              0               14.11    0.0900             1,949.04                 0.00                                                     

                      CARD BPS RETAIL     1.54 % $ 0.10           1,861.10              9               29.53    0.0900                33.76                 0.00                                                       

                                       0.0125 %  0.000                  0.00              0                1.70    0.0900               184.27                 0.00                                                     

                      CARD SURF           2.30 % $ 0.10               0.00              0                0.00    0.0900                 0.00                 0.00                                                       

                                       0.0125 %  0.000                  0.00              0                0.00    0.0900               126.24                 0.00                                                     

                      CARD BPS HTL-NP     1.58 % $ 0.10          13,953.57             40              224.37    0.0900               253.54                 0.00                                                       

                                       0.0125 %  0.000                  0.00              0               12.81    0.0900             1,743.24                 0.00                                                     

                      CARD BPS HOTEL      1.58 % $ 0.10             480.67              1                7.69    0.0900                 8.65                 0.00                                                       

                                       0.0125 %  0.000                  0.00              0                0.44    0.0900               115.06                 0.00                                                     

                      CARD US CR CONS     1.76 % $ 0.00               0.00              0               25.93-   0.0900                26.93-                0.00                                                       

                                       0.0000 %  0.000              1,475.17              4                0.00    0.0900               225.11-                0.00                                                     

                      CARD US CR COMM     2.24 % $ 0.00               0.00              0                0.00    0.0900                 0.00                 0.00                                                       

                                       0.0000 %  0.000                  0.00              0                0.00    0.0900                 5.69-                0.00                                                     

                      CARD REWARDS 1      1.65 % $ 0.10           3,085.20              8               51.66    0.0900                58.06                 0.00                                                       

                                       0.0125 %  0.000                  0.00              0                2.82    0.0900               226.69                 0.00                                                     

                      CARD REWDS2 T&E     1.90 % $ 0.10          21,275.25             40              408.14    0.0900               450.66                 0.00                                                                               

                      PAGE     2 FOR LVL: 98765 MYSTUFF                                                                               

                      ABC   X123X                           GIVE ME THE MONEY NOW AND DETAIL REPORT                   AS OF: 09/30/2008  PAGE:  13891                                                              

                      JOB: PRINT321  PGM: ABC321                                                                             RUN: 10/01/2008  07:04:22                                                                               

                      01 LVL: 00321 MEMINE             02 LVL: 12345                 03 LVL: 54321                   04 LVL: 12345 MY ACCOUNTS                                                                  

                      05 LVL: 54321                       06 LVL: 43212 MYDIREC ACCOUNTS    07 LVL: 98765 MYSTUFF                                                                               

                      PRT: N                                                                               

                      -


                        LIQUORED FEES -


                                                                                                       

                      INTERCH COST/      $ DEBITS/    ITEMS DB/    INTERCHANGE FEE/    MISCOUNT RATE/      CUSTOMER FEE CTD    CLIENT DIST CTD                                                    

                      PLAN DESCRIPTION        OURTAX COST        $ CREDITS    ITEMS CR     ASSESSMENT FEE      PER ITEM COST       CUSTOMER FEE YTD    CLIENT DIST YTD                                                  

                      -


                                                                

                                       0.0125 %  0.000                  0.00              0               19.59    0.0900             2,197.70                 0.00                                                     

                      CARD SURF     D     1.75 % $ 0.20               0.00              0                0.00    0.0900                 0.00                 0.00                                                       

                                       0.0125 %  0.000                  0.00              0                0.00    0.0900                25.79                 0.00                                                     

                      CARD HTL-NP   D     1.36 % $ 0.15           7,764.26             25              109.27    0.0900               125.76                 0.00                                                       

                                       0.0125 %  0.000                  0.00              0                7.11    0.0900             1,445.55                 0.00                                                     

                      CARD HOTEL    D     1.36 % $ 0.15             574.87              2                8.11    0.0900                 9.35                 0.00                                                       

                                       0.0125 %  0.000                  0.00              0                0.52    0.0900                89.47                 0.00                                                     

                      CARD CR CONS  D     1.31 % $ 0.00               0.00              0               18.74-   0.0900                19.77-                0.00                                                       

                                       0.0000 %  0.000              1,431.50              3                0.00    0.0900               101.75-                0.00                                                     

                      CARD RETAIL   D     1.03 % $ 0.15             965.48              4               10.52    0.0900                12.66                 0.00                                                       

                                       0.0125 %  0.000                  0.00              0                0.87    0.0900               259.21                 0.00                                                     

                      CARD VSP ELEC       2.30 % $ 0.10           4,011.49              9               93.16    0.0900               101.29                 0.00                                                       

                                       0.0125 %  0.000                  0.00              0                3.70    0.0900               636.21                 0.00                                                     

                      CARD COMM STND      2.70 % $ 0.10              42.13              2                1.33    0.0900                 1.60                 0.00                                                       

                                       0.0125 %  0.000                  0.00              0                0.03    0.0900                14.65                 0.00                                                     

                      CARD COM ELEC C     2.20 % $ 0.10           4,445.96              8               98.60    0.0900               107.44                 0.00                                                       

                                       0.0125 %  0.000                  0.00              0                4.11    0.0900               229.69                 0.00                                                     

                      CARD COM ELEC B     2.40 % $ 0.10           5,448.81             17              132.43    0.0900               143.94                 0.00                                                       

                                       0.0125 %  0.000                  0.00              0                4.98    0.0900               813.16                 0.00                                                     

                      CARD COM ELEC P     2.45 % $ 0.10             285.10              2                7.18    0.0900                 7.88                 0.00                                                       

                                       0.0125 %  0.000                  0.00              0                0.26    0.0900               699.45                 0.00                                                     

                      ABC  CORP T&E I     2.35 % $ 0.00              64.33              4                1.49    0.0900                 1.99                 0.00                                                       

                                       0.01450 %  0.000                  0.00              0                0.05    0.0900                37.64                 0.00                                                     

                      ABC  CORP T&E 2     2.20 % $ 0.10           1,299.38              6               29.14    0.0900                32.13                 0.00                                                       

                                       0.01450 %  0.000                  0.00              0                1.20    0.0900               632.17                 0.00                                                     

                      ABC  CARDS I        1.89 % $ 0.10           4,660.68             11               89.14    0.0900                98.80                 0.00                                                       

                                       0.01450 %  0.000                  0.00              0                4.38    0.0900             1,101.52                 0.00                                                     

                      ABC  CARDS III      1.58 % $ 0.10           1,532.82              6               24.80    0.0900                28.20                 0.00                                                       

                                       0.01450 %  0.000                  0.00              0                1.42    0.0900               205.97                 0.00                                                     

                      ABC  INTL STND      2.44 % $ 0.10             827.33              1               20.28    0.0900                21.91                 0.00                                                       

                                       0.01450 %  0.000                  0.00              0                0.78    0.0900                64.57                 0.00                                                     

                      ABC  INTL ELEC      1.91 % $ 0.00           1,057.74              2               20.19    0.0900                22.33                 0.00                                                       

                                       0.01450 %  0.000                  0.00              0                1.00    0.0900                53.51                 0.00                                                     

                      ABC  CORP INTL      2.60 % $ 0.00               0.00              0                0.00    0.0900                 0.00                 0.00                                                       

                                       0.01450 %  0.000                  0.00              0                0.00    0.0900                26.94                 0.00                                                     

                      ABC  MC REF G3D     1.40 % $ 0.00               0.00              0                4.09-   0.0900                 4.27-                0.00                                                       

                                       0.0000 %  0.000                292.83              1                0.00    0.0900                26.88-                0.00                                                     

                      ABC  MC REFCON1     2.42 % $ 0.00               0.00              0                0.00    0.0900                 0.00                 0.00                                                       

                                       0.0000 %  0.000                  0.00              0                0.00    0.0900                75.39-                0.00                                                     

                      ABC  MC REFCON5     1.73 % $ 0.00               0.00              0                3.23-   0.0900                 3.31-                0.00                                                       

                                       0.0000 %  0.000                186.75              1                0.00    0.0900               117.12-                0.00                                                     

                      ABC  MC REFCRP2     2.30 % $ 0.00               0.00              0                0.00    0.0900                 0.00                 0.00                                                       

                                       0.0000 %  0.000                  0.00              0                0.00    0.0900                22.26-                0.00                                                     

                      ABC  MCW T&E        2.30 % $ 0.10          11,845.46             32              275.56    0.0900               300.44                 0.00                                                       

                                       0.01450 %  0.000                  0.00              0               11.15    0.0900             1,493.67                 0.00                                                     

                      ABC  MWE T&E        2.75 % $ 0.10               0.00              0                0.00    0.0900                 0.00                 0.00                                                       

                                       0.01450 %  0.000                  0.00              0                0.00    0.0900                 6.00                 0.00                                                                               

                      PAGE     3 FOR LVL: 98765 MYSTUFF                                                                               

                      ABC   X123X                           GIVE ME THE MONEY NOW AND DETAIL REPORT                   AS OF: 09/30/2008  PAGE:  13892                                                              

                      JOB: PRINT321  PGM: ABC321                                                                             RUN: 10/01/2008  07:04:22                                                                               

                      01 LVL: 00321 MEMINE             02 LVL: 12345                 03 LVL: 54321                   04 LVL: 12345 MY ACCOUNTS                                                                  

                      05 LVL: 54321                       06 LVL: 43212 MYDIREC ACCOUNTS    07 LVL: 98765 MYSTUFF                                                                               

                      PRT: N                                                                               

                      -


                        LIQUORED FEES -


                                                                                                       

                      INTERCH COST/      $ DEBITS/    ITEMS DB/    INTERCHANGE FEE/    MISCOUNT RATE/      CUSTOMER FEE CTD    CLIENT DIST CTD                                                    

                      PLAN DESCRIPTION        OURTAX COST        $ CREDITS    ITEMS CR     ASSESSMENT FEE      PER ITEM COST       CUSTOMER FEE YTD    CLIENT DIST YTD                                                  

                      -


                                                                

                      ABC  CARDS 1  D     1.64 % $ 0.16           3,438.38             13               58.40    0.0900                66.00                 0.00                                                       

                                       0.01450 %  0.000                  0.00              0                3.20    0.0900               772.79                 0.00                                                     

                      ABC  CARDS 3  D     1.05 % $ 0.15           1,962.08              7               21.63    0.0900                25.91                 0.00                                                       

                                       0.01450 %  0.000                  0.00              0                1.83    0.0900               140.08                 0.00                                                     

                      ABC  JHG CARDSI     2.04 % $ 0.10           5,259.41             17              108.95    0.0900               120.25                 0.00                                                       

                                       0.01450 %  0.000                  0.00              0                4.94    0.0900             1,834.23                 0.00                                                     

                      ABC  JHG MER 3      1.73 % $ 0.10           1,740.79              6               30.69    0.0900                34.48                 0.00                                                       

                                       0.01450 %  0.000                  0.00              0                1.63    0.0900               274.62                 0.00                                                     

                      MISC MISC HOCR      1.71 % $ 0.10           4,734.08             13               82.20    0.0900                92.06                 0.00                                                       

                                       0.0125 %  0.000                  0.00              0                4.35    0.0900               409.41                 0.00                                                     

                      MISC MISCCOMELC     2.30 % $ 0.10           4,781.57             14              111.33    0.0900               121.36                 0.00                                                       

                                       0.0125 %  0.000                  0.00              0                4.37    0.0900               196.52                 0.00                                                     

                      MISC MISCCOADJ3     1.75 % $ 0.00               0.00              0                3.77-   0.0900                 3.87-                0.00                                                       

                                       0.0125 %  0.000                215.48              1                0.00    0.0900                 6.00-                0.00                                                     

                      MISC MISCHOCR P     2.30 % $ 0.10             308.30              1                7.19    0.0900                 7.85                 0.00                                                       

                                       0.0125 %  0.000                  0.00              0                0.28    0.0900                35.93                 0.00                                                     

                      MISC MISCCADJ3P     1.75 % $ 0.00               0.00              0                6.09-   0.0900                 6.31-                0.00                                                       

                                       0.0125 %  0.000                348.08              1                0.00    0.0900                 6.31-                0.00                                                     

                      -


                                                                

                           TOTAL BEER                           123,082.03            340            2,358.65                       2,613.14                 0.00                                                                               

                      3,949.81             11              113.63                      17,482.48                 0.00                                                                               

                      FOOD NON-STL        0.00 % $ 0.00          15,710.89             47                0.00    0.0000                 0.00                 0.00                                                       

                                       0.0000 %  0.000              1,077.79              4                0.00    0.0000                 0.00                 0.00                                                     

                      BEVG NON-STL        0.00 % $ 0.00               0.00              0                0.00    0.0000                 0.00                 0.00                                                       

                                       0.0000 %  0.000                  0.00              0                0.00    0.0000                 0.00                 0.00                                                     

                      MISC SOME FEES      0.40 % $ 0.00           1,240.25              4                4.95    0.0000                 0.00                 0.00                                                       

                                       0.0000 %  0.000                  0.00              0                0.00    0.0000                 0.00                 0.00                                                     

                      BTCH BATCH HDR      0.00 % $ 0.00               0.00             31                0.00    0.0000                 0.00                 0.00                                                       

                                       0.0000 %  0.000                  0.00              0                0.00    0.0000                 0.00                 0.00                                                     

                      -


                                                                

                           TOTAL NON-BEER                        16,951.14             82                4.95                           0.00                 0.00                                                                               

                      1,077.79              4                0.00                           0.00                 0.00                                                                               

                      TOTAL LIQUORED                       140,033.17            422            2,363.60                       2,613.14                 0.00                                                                               

                      5,027.60             15              113.63                      17,482.48                 0.00                                                     

                      -


                                                                                                       

                      -


                      ACTIVITY FEES -


                                                                                                       

                      PER ITEM  COST    COST              -


                      CUSTOMER FEE -


                                 -


                      CLIENT DISTRIBUTION -


                                                                

                      DESCRIPTION      ITEMS              RATE    PI      AMOUNT                             CTD                 YTD                 CTD                 YTD                                            

                      -


                                                                

                      CARD-STUF LOCAL       4               0.00  0.0000    0.000                                  0.00               0.00               0.00               0.00                                        

                      CARD-STUF WATS      260               0.00  0.0000    0.000                                  0.00               0.00               0.00               0.00                                        

                      ABC -STUF WATS      181               0.00  0.0000    0.000                                  0.00               0.00               0.00               0.00                                        

                      MISC-STUF WATS       47               0.12  0.0000    0.000                                  5.64              17.64               0.00               0.00                                        

                      UNKN-AUTH FEES       72               0.00  0.0000    0.000                                  0.00               0.00               0.00               0.00                                        

                      FOOD-STUF LOCAL       0               0.00  0.0000    0.000                                  0.00               0.36               0.00               0.00                                                                               

                      PAGE     4 FOR      LVL: 98765 MYSTUFF                                                                               

                      ABC   X123X                           GIVE ME THE MONEY NOW AND DETAIL REPORT                   AS OF: 09/30/2008  PAGE:  13893                                                              

                      JOB: PRINT321  PGM: ABC321                                                                             RUN: 10/01/2008  07:04:22                                                                               

                      01 LVL: 00321 MEMINE             02 LVL: 12345                 03 LVL: 54321                   04 LVL: 12345 MY ACCOUNTS                                                                  

                      05 LVL: 54321                       06 LVL: 43212 MYDIREC ACCOUNTS    07 LVL: 98765 MYSTUFF                                                                               

                      PRT: N                                                                               

                      -


                      ACTIVITY FEES -


                                                                                                       

                      PER ITEM  COST    COST              -


                      CUSTOMER FEE -


                                 -


                      CLIENT DISTRIBUTION -


                                                                

                      DESCRIPTION      ITEMS              RATE    PI      AMOUNT                             CTD                 YTD                 CTD                 YTD                                            

                      -


                                                                

                      FOOD-STUF WATS       64               0.12  0.0000    0.000                                  7.68              78.00               0.00               0.00                                        

                      BEVG-STUF WATS        0               0.00  0.0000    0.000                                  0.00              17.10               0.00               0.00                                        

                      BBB -STUF LOCAL       0               0.00  0.0000    0.000                                  0.00               0.10               0.00               0.00                                        

                      -


                                                                

                      TOTAL ACTIVITY      628                               0.000                                 13.32             113.20               0.00               0.00                                        

                      -


                                                                                                       

                      TOTAL BILLING FOR          2,626.46    TOTAL DISTRIBUTION FOR   98765                                                                               

                      TO ACCT #  1234567                             0.00                                                                    

                                                                                                                                                                                                                                                                                                                                        •                                                                                 

                      /code

                        • Two line trap that occasionally Spans two pages
                          Grant Perkins

                          The first Page header is different to the rest as you are aware but then the data on the first page is also different so whilst working with field from the page header area would be, at the very least, a pain, the body with your two line details looks more consistent - at least in the sample.

                           

                          A 13 line[/B] Page Header template trapping on the word Page over to the left of the third line[/B] worked on the sample.

                           

                          1st line is the blank line[/B] and last line the dashed line[/B] above the first detail line.

                           

                          That template eliminates the 13 lines and allows capture of the overlapping second line of the detail.

                           

                          However, from your earlier comments, if you tell us that there are other pages in the body of the report for which the template does not work I would not be surprised! 

                           

                          BTW your detail trap line looks very comprehensive. No problem with that but unless you are doing it that way specifically to exclude other almost but not quite identical lines elsewhere in the report you successfully could get away with a lot less. One or two of the decimal points on the first of the double row detail lines should be enough. Might save a little time.

                           

                           

                          HTH.

                           

                           

                          Grant

                            • Two line trap that occasionally Spans two pages
                              CapQ _

                              Grant:

                               

                              The first page is a header for the report and I should have left it off to simplify.

                               

                              All of the records have the same sub headings.  I can trap the the Orphaned line, my problem is appending it to the 1st half of the record on the previous page.  If I make it a header then it is appended to every detail line when I only want it appended to the detail of the previous page.

                               

                              It would be great if I could have a formula where when line 2 of the detail is null move down x number of lines to capture it.

                                • Two line trap that occasionally Spans two pages
                                  Grant Perkins

                                  CapQ,

                                   

                                  I had discounted the report banner page and was thinking of the

                                   

                                  PAGE 1 FOR LVL: 98765

                                   

                                   

                                  page as the anomaly since the notional header detail ahead of the Customer Profile section is different to the page headers that follow for

                                   

                                  PAGE 2 FOR LVL: 98765 , PAGE 3 FOR LVL: 98765 and so on.

                                   

                                  At least they are in the sample.

                                   

                                  So if you use the 13 header lines for for the "PAGE 1 FOR LVL: 98765" page, starting on the blank just above the first line of the printed header and ending by including the dashed line you will make those 13 lines 'invisible' to the Detail Template parsing process.

                                   

                                  blank line here

                                  PAGE 2 FOR LVL: 98765 MYSTUFF

                                  ABC X123X GIVE ME THE MONEY NOW AND DETAIL REPORT AS OF: 09/30/2008 PAGE: 13891

                                  JOB: PRINT321 PGM: ABC321 RUN: 10/01/2008 07:04:22

                                   

                                  01 LVL: 00321 MEMINE 02 LVL: 12345 03 LVL: 54321 04 LVL: 12345 MY ACCOUNTS

                                  05 LVL: 54321 06 LVL: 43212 MYDIREC ACCOUNTS 07 LVL: 98765 MYSTUFF

                                   

                                  PRT: N

                                  -


                                  LIQUORED FEES -


                                   

                                  INTERCH COST/ $ DEBITS/ ITEMS DB/ INTERCHANGE FEE/ MISCOUNT RATE/ CUSTOMER FEE CTD CLIENT DIST CTD

                                  PLAN DESCRIPTION OURTAX COST $ CREDITS ITEMS CR ASSESSMENT FEE PER ITEM COST CUSTOMER FEE YTD CLIENT DIST YTD

                                  -


                                  [/code]

                                   

                                   

                                  I've lost the formatting in the cut and paste but you should get the idea.

                                   

                                  Your 2 line DETAIL TEMPLATE, trapped on the first line, will then work just fine if the second line of a record falls the other side of a page break. No orphaned line. And of course this would also be true if the detail template was more than 2 lines and could split anywhere within the block.

                                   

                                   

                                  HTH.

                                   

                                   

                                  Grant