3 Replies Latest reply: May 15, 2014 9:52 AM by Grant Perkins RSS

    Trap carried over Page Break

    Glen Nickerson

      I have a report where elements of a detail trap may be reprinted after a page break to continue with a description field. Is there a way to ignore the continuing key elements and have the description attached to the actual start of the detail trap? The model has a detail template (trap on the Item#), Append to pick up the description fields, and Header template to bypass all of the header text and keep the append going. Any help would be appreciated.

       

      [font="courier"]  252888       0         0VENDOR               0SLEEVE         ?                                                                               

      WOODS-TB 8H, 1 PIECE                                                                               

      .                                     HYTREL                 

                                                      WOODS 8H  , HYTREL, 1-PIECE,                                                                               

      FOR WOODS COUPLING.                                                                               

      ªNOT STOCKED IN STORES. A DISBURSEMENT WILL                  

                                                      ªGENERATE AN ORDER.                                          

        252889       1         0  2580604            0PULLEY         ?VARI-SPEED                                                                               

      REEVES   H95505                                              

      1 PAGE                                                                               

      STORES    ITEMS BY CAPTION                                                                               

      QTY     QTY. DISB          RECEIPTS                                                                  

      ITEM    ON HAND LST YR    LOCATION LST YR       DESCRIPTION                                                  

      -


          -


      -


      -


      -


           -


                                                          

        252889       1         0  2580604            07/8" BORE                                                                               

      WITH LICKING COLLAR, SIZE 7202.                              

        252890       1         0  1600231            0SHEAVE         ?V-BELT, 2-GROOVE                             

                                                      WOODS-TB 2B TYPE E1                                                                               

      WOODS 3.8X2B-SH, 3.8" OD,                                    

        /font[/quote]

        • Trap carried over Page Break
          Glen Nickerson

          I have a report where elements of a detail trap may be reprinted after a page break to continue with a description field. Is there a way to ignore the continuing key elements and have the description attached to the actual start of the detail trap? The model has a detail template (trap on the Item#), Append to pick up the description fields, and Header template to bypass all of the header text and keep the append going. Any help would be appreciated.

           

          [font="courier"]  252888       0         0VENDOR               0SLEEVE         ?                                                                               

          WOODS-TB 8H, 1 PIECE                                                                               

          .                                     HYTREL                 

                                                          WOODS 8H  , HYTREL, 1-PIECE,                                                                               

          FOR WOODS COUPLING.                                                                               

          ªNOT STOCKED IN STORES. A DISBURSEMENT WILL                  

                                                          ªGENERATE AN ORDER.                                          

            252889       1         0  2580604            0PULLEY         ?VARI-SPEED                                                                               

          REEVES   H95505                                              

          1 PAGE                                                                               

          STORES    ITEMS BY CAPTION                                                                               

          QTY     QTY. DISB          RECEIPTS                                                                  

          ITEM    ON HAND LST YR    LOCATION LST YR       DESCRIPTION                                                  

          -


              -


          -


          -


          -


               -


                                                              

            252889       1         0  2580604            07/8" BORE                                                                               

          WITH LICKING COLLAR, SIZE 7202.                              

            252890       1         0  1600231            0SHEAVE         ?V-BELT, 2-GROOVE                             

                                                          WOODS-TB 2B TYPE E1                                                                               

          WOODS 3.8X2B-SH, 3.8" OD,                                    

            /font[/quote]

          • Trap carried over Page Break
            Grant Perkins

            Glen,

             

            Warning flags waving but here is a suggestion that might work depending on how variable the number of lines in a 'detail' record might be or perhaps how consistent the programmer has been when repeating across the page change.

             

            If you take your sample (with a page header added at the top!), trap on the Item code as you did and make the template Sample Data 3 lines long the detail record SHOULD jump the Page Header template and continue to the first row of the repeat.

             

            Now, it you only have fields painted on row 1 except for your description rows (are these extracted as a multi-row field?)the last row (IN THIS PARTICULAR EXAMPLE!) will be the first row after the page header. So the repeat data will not be 'seen' as the first line of a new record and a multiline Description extract would continue until you reach the next (in this case genuine) record.

             

            Up to a point you can vary the number of rows in the sample to suit the output from the report. HOWEVER be aware that any record SHORTER than the number of lines in the Template Sample will extract the start of the decription from the record after them AND that this means at least one record would be missed completely.

             

            If you take this route I recommend extreme care, built in checking and frequent use of Verify!

             

            I hope this leads to a solution that works.

             

            Plan C says we consider modifying the report first to get rid of duplicates and then run a model on the output ...

             

            Anyone got a plan B?

             

            Grant

             

            Originally posted by Glen Nickerson:

            I have a report where elements of a detail trap may be reprinted after a page break to continue with a description field. Is there a way to ignore the continuing key elements and have the description attached to the actual start of the detail trap? The model has a detail template (trap on the Item#), Append to pick up the description fields, and Header template to bypass all of the header text and keep the append going. Any help would be appreciated.

             

            [font="courier"]  252888       0         0VENDOR               0SLEEVE         ?                                                                               

            WOODS-TB 8H, 1 PIECE                                                                               

            .                                     HYTREL                 

                                                            WOODS 8H  , HYTREL, 1-PIECE,                                                                               

            FOR WOODS COUPLING.                                                                               

            ªNOT STOCKED IN STORES. A DISBURSEMENT WILL                  

                                                            ªGENERATE AN ORDER.                                          

              252889       1         0  2580604            0PULLEY         ?VARI-SPEED                                                                               

            REEVES   H95505                                              

            1 PAGE                                                                               

            STORES    ITEMS BY CAPTION                                                                               

            QTY     QTY. DISB          RECEIPTS                                                                  

            ITEM    ON HAND LST YR    LOCATION LST YR       DESCRIPTION                                                  

            -


                -


            -


            -


            -


                 -


                                                                

              252889       1         0  2580604            07/8" BORE                                                                               

            WITH LICKING COLLAR, SIZE 7202.                              

              252890       1         0  1600231            0SHEAVE         ?V-BELT, 2-GROOVE                             

                                                            WOODS-TB 2B TYPE E1                                                                               

            WOODS 3.8X2B-SH, 3.8" OD,                                    

              /font[/quote][/b][/quote]

            • Trap carried over Page Break
              Grant Perkins

              Glen,

               

              Warning flags waving but here is a suggestion that might work depending on how variable the number of lines in a 'detail' record might be or perhaps how consistent the programmer has been when repeating across the page change.

               

              If you take your sample (with a page header added at the top!), trap on the Item code as you did and make the template Sample Data 3 lines long the detail record SHOULD jump the Page Header template and continue to the first row of the repeat.

               

              Now, it you only have fields painted on row 1 except for your description rows (are these extracted as a multi-row field?)the last row (IN THIS PARTICULAR EXAMPLE!) will be the first row after the page header. So the repeat data will not be 'seen' as the first line of a new record and a multiline Description extract would continue until you reach the next (in this case genuine) record.

               

              Up to a point you can vary the number of rows in the sample to suit the output from the report. HOWEVER be aware that any record SHORTER than the number of lines in the Template Sample will extract the start of the decription from the record after them AND that this means at least one record would be missed completely.

               

              If you take this route I recommend extreme care, built in checking and frequent use of Verify!

               

              I hope this leads to a solution that works.

               

              Plan C says we consider modifying the report first to get rid of duplicates and then run a model on the output ...

               

              Anyone got a plan B?

               

              Grant

               

              Originally posted by Glen Nickerson:

              I have a report where elements of a detail trap may be reprinted after a page break to continue with a description field. Is there a way to ignore the continuing key elements and have the description attached to the actual start of the detail trap? The model has a detail template (trap on the Item#), Append to pick up the description fields, and Header template to bypass all of the header text and keep the append going. Any help would be appreciated.

               

              [font="courier"]  252888       0         0VENDOR               0SLEEVE         ?                                                                               

              WOODS-TB 8H, 1 PIECE                                                                               

              .                                     HYTREL                 

                                                              WOODS 8H  , HYTREL, 1-PIECE,                                                                               

              FOR WOODS COUPLING.                                                                               

              ªNOT STOCKED IN STORES. A DISBURSEMENT WILL                  

                                                              ªGENERATE AN ORDER.                                          

                252889       1         0  2580604            0PULLEY         ?VARI-SPEED                                                                               

              REEVES   H95505                                              

              1 PAGE                                                                               

              STORES    ITEMS BY CAPTION                                                                               

              QTY     QTY. DISB          RECEIPTS                                                                  

              ITEM    ON HAND LST YR    LOCATION LST YR       DESCRIPTION                                                  

              -


                  -


              -


              -


              -


                   -


                                                                  

                252889       1         0  2580604            07/8" BORE                                                                               

              WITH LICKING COLLAR, SIZE 7202.                              

                252890       1         0  1600231            0SHEAVE         ?V-BELT, 2-GROOVE                             

                                                              WOODS-TB 2B TYPE E1                                                                               

              WOODS 3.8X2B-SH, 3.8" OD,                                    

                /font[/quote][/b][/quote]