18 Replies Latest reply: May 15, 2014 10:07 AM by Ziggy _ RSS

    MultilineTrap Pagebreak splitting line

    Ziggy _

      Hi,

       

      I have a Multiline Trap, but sometimes the Page break splits the trap line and I lose the second line?  Any way to get around this?

       

       

       

      HANDLING CHARGES  - XXXX      09       21.00     6.96     PLT          146.16      

      Receipt: 4656945 Reference: 4654504524                                                                               

      HANDLING CHARGES  - XXX      09       21.00     6.96     PLT          146.16      

      -


                                                                                       

      Receipt: 478963 Reference: 4488956522     /B                                                                               

      HANDLING CHARGES  - XXXX      09       21.00     6.96     PLT          146.16      

      Receipt: 456874 Reference: 4189746923                                              

      /QUOTE

       

       

       

      the line is...

       

      -


       

       

       

      Note:  my Trap criteria is on the first line, but even if it were on the second line I don't think it can capture it?

       

       

      Also the second line is not consistent....

       

      CASE PICK SURCHARGE           CAS      90.00     0.20     EA            18.08    

      BOL: 456845 Reference: 46461335256     Order name                 

       

      I use ...  trim(extract(Extract(Description,"Reference",),":"))  to break it up.

        • MultilineTrap Pagebreak splitting line
          Grant Perkins

          Ziggy,

           

          The normal approach would be to create a Page Header type Append template to define the page break line(s).

           

          Sometimes this is not easily possible. You report might be such a case as your sample shows no page header type information.

           

          Plan B would be to try to control the number of lines per page (Monarch allows this) so that the page break does not split a record. It's not clear if that would work for you here but it's worth considering.

           

          PLan C is to set  a suitable page break point but then also set a value for the Page Break Lookahead parameter. There is some information on the help file for that setting. It's intenet is to allow you to set a nominal number of lines per page but then for Monarch to assess what it finds in a way that allows it so set a variable value for number of lines per page that will always mean the page break occurs on a blank line  - hopefully a blank line that appears between two records!

           

          HTH.

           

          Let us know where you get to with those suggestions.

           

           

          Grant

            • MultilineTrap Pagebreak splitting line
              Grant Perkins

              Ziggy,

               

              With regard to your inconsistent line - it looks like the sample line works with a single Extract based on using "Reference:" as a single string rather than "Reference" and then ":" . Are there other circumstances where a single Extract does not work?

               

              If the line ALWAYS  ENDS with Reference: xxxxxxxxxxxx  xx xx x  x then you could just use a RSPLIT() function acting on the colon.

               

              If there might be some other unrequired (in terms of the details being extracted fo the Reference field) characters at the end of the line a slightly more selective approach would be necessary - but that seems true of the Extract approach as well.

               

              Either way what you have is neat enough and gets the result you need which is the main thing. I don't see that there would be much difference, for this example, in processing demands on the system for either the Extract of RSPLIT approaches (or indeed any others that one might try.)

               

              Good work.

               

               

              Grant

              • MultilineTrap Pagebreak splitting line
                Ziggy _

                Ziggy,

                 

                The normal approach would be to create a Page Header type Append template to define the page break line(s).

                 

                Sometimes this is not easily possible. You report might be such a case as your sample shows no page header type information.

                 

                Plan B would be to try to control the number of lines per page (Monarch allows this) so that the page break does not split a record. It's not clear if that would work for you here but it's worth considering.

                 

                PLan C is to set  a suitable page break point but then also set a value for the Page Break Lookahead parameter. There is some information on the help file for that setting. It's intenet is to allow you to set a nominal number of lines per page but then for Monarch to assess what it finds in a way that allows it so set a variable value for number of lines per page that will always mean the page break occurs on a blank line  - hopefully a blank line that appears between two records!

                 

                HTH.

                 

                Let us know where you get to with those suggestions.

                 

                 

                Grant[/QUOTE]

                 

                Thanks Grant,

                 

                I'm trying different things,  I haven't found the "lookahead setting though (in help)?

                  • MultilineTrap Pagebreak splitting line
                    Ziggy _

                    One thing is confusing me, and I don't know if I clicked something ( Maybe it's always been there).... But I have a dashed line across the page at certain intervals...as if maybe that is a Page break...other reports have it also...but it's not in the report when viewed in other programs..

                     

                      • like I said it might always be there and I'm just confusing myself?

                     

                    • MultilineTrap Pagebreak splitting line
                      Grant Perkins

                      Thanks Grant,

                       

                      I'm trying different things, I haven't found the "lookahead setting though (in help)?[/quote]

                       

                      Go into the Help.

                       

                      Search for Settings and open that page.

                       

                      Scroll down into the 'Hidden Settings' section.

                       

                      Scroll on until you come to the section (Aplhabetical order) entitled

                      [SIZE=2]ForcePageBreakLookAhead[/SIZE][/B]

                       

                      and take the description from there.

                       

                      It's a Windows Registry setting so not something to be messed with lightly and something of a last resort for sorting one-off problems. However, if a lot of the imputs you have to deal with suffer from the same sort of problems it makes some sense to spend time understanding its potential.

                       

                      To be honest I have never had to use it as far as I recall - but some day I might need it.

                       

                      HTH.

                       

                       

                      Grant

                        • MultilineTrap Pagebreak splitting line
                          Ziggy _

                          Hi Grant,

                           

                          Thanks for the replies, The Registry settings are good to know.

                           

                          I don't see this working because the line I'm trying to Trap on the page break varies...this is a bad report...it's technically not even a report...I call up a archive on a record by record basis and print to file...some just happen to be a lot of pages...there is no numbering, only the line...

                           

                          ----


                          [/QUOTE]

                           

                          The only thing I see consistent is when the line prints 3 blank lines follow it, if the trap gets split the line is immediately after the preceding data ( the first line of Multi line trap)... if there is no splitting there is a blank line and then the "Line"... I some how need to have the "line" and 3 following lines ignored?

                            • MultilineTrap Pagebreak splitting line
                              Grant Perkins

                              Ziggy,

                               

                              If you can post a sample of a set of records that may help. Some of these things only give out their clues to an approach when visualised.

                               

                              Basically you need to think in terms of generating your own rules for a virtual 'Page' break. If that happens to be 3 blank lines (for example) eveytimne there are 3 blank lines then so be it. The only limit is that Monarch has an internal limit of (iirc) 256 lines max per page and so will force a page break after 256 unbroken lines. i.e. about 4 typical printed pages using 66 lines per page.

                               

                              If a public sample is not possible would a private sample be OK? (via eMail).

                               

                              Sometimes the solution can be to make your own page break point identifiers in the input file. Forget about the concept of physical pages - logical pages are what matter here.

                               

                              Bear in mind all we are trying to do here (afaik) is stop Monarch inserting a page break that disrupts your template definition working. There is, as far as I have read, no implication for the recirds in that respect. (Unless some records are exceeding the mac number of lines allowed in a template.)

                               

                               

                              Grant

                                • MultilineTrap Pagebreak splitting line
                                  Ziggy _

                                  ok, here is more detail... I've dummed up the records.  I removed the header because I was experimenting with just starting at the first record since the header only shows up once.

                                   

                                   

                                  HANDLING CHARGES  - Acct      09       20.00     4.30     PLT          13.11

                                  Receipt: 110390 Reference: 4540104198

                                     

                                  HANDLING CHARGES  - Acct      09        1.00     4.30     PLT            4.30

                                  Receipt: 110391 Reference: 4540104

                                     

                                  HANDLING CHARGES - Acct2     09       35.00     2.35     PLT          221.55

                                  Receipt: 110391 Reference: 4540104

                                     

                                  HANDLING CHARGES - Acct2     09       22.00     2.35     PLT          139.26

                                  Receipt: 110392 Reference: 4540104324

                                     

                                  HANDLING CHARGES  - Acct      09       20.00     4.30     PLT          139.11

                                  Receipt: 110393 Reference: 4540104220

                                     

                                  HANDLING CHARGES  - Acct      09       26.00     4.30     PLT          139.11

                                  Receipt: 110394 Reference: 4540104206

                                     

                                  HANDLING CHARGES  - Acct      09       13.00     4.30     PLT          139.11

                                  Receipt: 110395 Reference: 4540104205

                                     

                                  HANDLING CHARGES  - Acct      09       28.00     4.30     PLT          194.88

                                  Receipt: 110396 Reference: 4540104055

                                     

                                  HANDLING CHARGES  - Acct      09       19.00     4.30     PLT          132.24

                                  Receipt: 110397 Reference: 4540104043

                                     

                                  HANDLING CHARGES  - Acct      09        5.00     4.30     PLT          139.11

                                  Receipt: 110398 Reference: 4540104207

                                     

                                  HANDLING CHARGES  - Acct      09       28.00     4.30     PLT          194.88

                                  Receipt: 110399 Reference: 4540104054

                                     

                                  HANDLING CHARGES  - Acct      09       20.00     4.30     PLT          139.11

                                  Receipt: 110400 Reference: 4540104210

                                     

                                  HANDLING CHARGES - Acct2     09       17.00     2.35     PLT          107.61

                                  Receipt: 110401 Reference: 4540104258

                                     

                                  HANDLING CHARGES  - Acct      09       20.00     4.30     PLT          139.11

                                  Receipt: 110402 Reference: 4540104219

                                     

                                  HANDLING CHARGES  - Acct      09       20.00     4.30     PLT          139.11

                                  Receipt: 110403 Reference: 4540104217

                                     

                                  CASE PICK SURCHARGE           CAS      32.00     0.11     EA             6.43

                                  BOL: D06958 Reference: 4000593879    

                                     

                                  -


                                   

                                   

                                   

                                  CASE PICK SURCHARGE           CAS      25.00     0.11     EA            43.19

                                  BOL: D06936 Reference: 4000588667    

                                     

                                  CASE PICK SURCHARGE           CAS      35.00     0.11     EA            32.55

                                  BOL: D06959 Reference: 4000599149    

                                     

                                  CASE PICK SURCHARGE           CAS     225.00     0.11     EA            79.36

                                  BOL: D06988 Reference: 4000599119    

                                     

                                  CASE PICK SURCHARGE           CAS      33.00     0.11     EA            11.25

                                  BOL: D06960 Reference: 4000599254    

                                     

                                  CASE PICK SURCHARGE           CAS     665.00     0.11     EA           133.60

                                  BOL: D06943 Reference: 4000588669   

                                     

                                  CASE PICK SURCHARGE           CAS     364.00     0.11     EA            732.35

                                  BOL: D06937 Reference: 4000593771    

                                     

                                  CASE PICK SURCHARGE           CAS      14.00     0.11     EA             2.81

                                  BOL: D06971 Reference: 4000599011    

                                     

                                  CASE PICK SURCHARGE           CAS     489.00     0.11     EA            75.74

                                  BOL: D06965 Reference: 4000593777    

                                     

                                  CASE PICK SURCHARGE           CAS      17.00     0.11     EA             1.41

                                  BOL: D06963 Reference: 4000593773    

                                     

                                  CASE PICK SURCHARGE           CAS     140.00     0.11     EA            282.35

                                  BOL: D06938 Reference: 4000588432    

                                     

                                  CASE PICK SURCHARGE           CAS      21.00     0.11     EA             4.22

                                  BOL: D06975 Reference: 4000599730    

                                     

                                  CASE PICK SURCHARGE           CAS     344.00     0.11     EA            69.11

                                  BOL: D06939 Reference: 4000599845    

                                     

                                  CASE PICK SURCHARGE           CAS     148.00     0.11     EA            29.73

                                  BOL: D06941 Reference: 4000599856    

                                     

                                  CASE PICK SURCHARGE           CAS     164.00     0.11     EA            32.95

                                  BOL: D06940 Reference: 4000599819    

                                     

                                  CASE PICK SURCHARGE           CAS     444.00     0.11     EA            89.11

                                  BOL: D06930 Reference: 4000593775    

                                     

                                  CASE PICK SURCHARGE           CAS     561.00     0.11     EA           112.70

                                  BOL: D06929 Reference: 4000588663    

                                     

                                  CASE PICK SURCHARGE           CAS     358.00     0.11     EA            71.92

                                  BOL: D06931 Reference: 4000599859    

                                     

                                  CASE PICK SURCHARGE           CAS      55.00     0.11     EA            11.05

                                  BOL: D06964 Reference: 4000599828    

                                     

                                  CASE PICK SURCHARGE           CAS     823.00     0.11     EA           165.34

                                  BOL: D06928 Reference: 4000599858    

                                     

                                  CASE PICK SURCHARGE           CAS     111.00     0.11     EA            22.30 /B

                                  -


                                   

                                   

                                   

                                  BOL: D06966 Reference: 4000599843     /B

                                     

                                  CASE PICK SURCHARGE           CAS      72.00     0.11     EA            14.46

                                  BOL: D06955 Reference: 4000600262    

                                     

                                  CASE PICK SURCHARGE           CAS     273.00     0.11     EA            54.85

                                  BOL: D06985 Reference: 4000599751     Store1

                                     

                                  CASE PICK SURCHARGE           CAS      36.00     0.11     EA             7.23

                                  BOL: D06987 Reference: 4000599869    

                                     

                                  CASE PICK SURCHARGE           CAS     366.00     0.11     EA            73.53

                                  BOL: D06986 Reference: 4000599877     

                                     

                                  CASE PICK SURCHARGE           CAS      85.00     0.11     EA            16.88

                                  BOL: D06981 Reference: 4000599106     S

                                     

                                  CASE PICK SURCHARGE           CAS      72.00     0.11     EA            14.46

                                  BOL: D06983 Reference: 4000599878    

                                     

                                  CASE PICK SURCHARGE           CAS     192.00     0.11     EA            38.57

                                  BOL: D06982 Reference: 4000600322     

                                     

                                  CASE PICK SURCHARGE           CAS    6180.00     0.11     EA           458.05

                                  BOL: D06989 Reference: 4000599120    

                                     

                                  CASE PICK SURCHARGE           CAS     862.00     0.11     EA           173.18

                                  BOL: D06999 Reference: 4000599448     

                                     

                                  CASE PICK SURCHARGE           CAS      79.00     0.11     EA            15.87

                                  BOL: D06997 Reference: 4000600387     

                                     

                                  CASE PICK SURCHARGE           CAS     134.00     0.11     EA            26.92

                                  BOL: D06998 Reference: 4000600302     

                                     

                                  HANDLING CHARGES  - Acct      09       28.00     4.30     PLT          194.88

                                  Receipt: 110409 Reference: 4540104058

                                     

                                  HANDLING CHARGES  - Acct      09       20.00     4.30     PLT          139.11

                                  Receipt: 110410 Reference: 4540104213

                                     

                                  HANDLING CHARGES - Acct2     09        8.00     2.35     PLT           50.64

                                  Receipt: 110411 Reference: 4540104346

                                     

                                  HANDLING CHARGES  - Acct      09       28.00     4.30     PLT          194.88

                                  Receipt: 110412 Reference: 4540104057

                                     

                                  HANDLING CHARGES  - Acct      09       28.00     4.30     PLT          194.88

                                  Receipt: 110413 Reference: 4540104056

                                     

                                  HANDLING CHARGES  - Acct      09        3.00     4.30     PLT           20.88

                                  Receipt: 110414 Reference: 0104268

                                     

                                  MINIMUM WAREHOUSE RECEIPT INV 09        1.00    35.00     INV           14.12

                                  Receipt: 110414 Reference: 0104268

                                     

                                  HANDLING CHARGES  - Acct      09       28.00     4.30     PLT          194.88

                                  Receipt: 110415 Reference: 4540104063

                                  -


                                   

                                   

                                   

                                  HANDLING CHARGES  - Acct      09       28.00     4.30     PLT          194.88

                                  Receipt: 110416 Reference: 4540104062

                                     

                                  HANDLING CHARGES  - Acct      09       23.00     4.30     PLT          160.08

                                  Receipt: 110417 Reference: 4540104491

                                     

                                  HANDLING CHARGES  - Acct      09       28.00     4.30     PLT          194.88

                                  Receipt: 110419 Reference: 4540104064

                                     

                                  HANDLING CHARGES  - Acct      09       20.00     4.30     PLT          139.11

                                  Receipt: 110420 Reference: 4540104214

                                     

                                  HANDLING CHARGES  - Acct      09       20.00     4.30     PLT          139.11

                                  Receipt: 110421 Reference: 4540104211

                                     

                                  HANDLING CHARGES  - Acct      09       28.00     4.30     PLT          194.88

                                  Receipt: 110422 Reference: 4540104060

                                     

                                  HANDLING CHARGES  - Acct      09       20.00     4.30     PLT          139.11

                                  Receipt: 110423 Reference: 4540104215

                                     

                                  HANDLING CHARGES  - Acct      09       20.00     4.30     PLT          139.11

                                  Receipt: 110424 Reference: 4540104216

                                     

                                  HANDLING CHARGES  - Acct      09       20.00     4.30     PLT          139.11

                                  Receipt: 110425 Reference: 4540104200

                                     

                                  HANDLING CHARGES  - Acct      09       47.00     4.30     PLT          327.12

                                  Receipt: 110427 Reference: 4540104293

                                     

                                  HANDLING CHARGES - Acct2     09        5.00     2.35     PLT           31.65

                                  Receipt: 110428 Reference: 4540104340

                                     

                                  MINIMUM WAREHOUSE RECEIPT INV 09        1.00    35.00     INV            3.35

                                  Receipt: 110428 Reference: 4540104340

                                     

                                  HANDLING CHARGES  - Acct      09       28.00     4.30     PLT          194.88

                                  Receipt: 110429 Reference: 4540104059

                                     

                                  HANDLING CHARGES  - Acct      09       20.00     4.30     PLT          139.11

                                  Receipt: 110430 Reference: 4540104163

                                     

                                  CASE PICK SURCHARGE           09      134.00     0.11     EA            26.80

                                  BOL: D06984 Reference: 4000599753

                                     

                                  CASE PICK SURCHARGE           CAS     107.00     0.11     EA            21.50

                                  BOL: D06994 Reference: 4000599313    

                                     

                                  CASE PICK SURCHARGE           CAS      53.00     0.11     EA            10.65

                                  BOL: D07008 Reference: 4000599732    

                                     

                                  CASE PICK SURCHARGE           CAS     101.00     0.11     EA            20.29

                                  BOL: D07003 Reference: 4000599884    

                                     

                                  CASE PICK SURCHARGE           CAS     601.00     0.11     EA           120.74

                                  BOL: D07006 Reference: 4000599445    

                                     

                                  CASE PICK SURCHARGE           CAS     278.00     0.11     EA            55.85 /B

                                  -


                                   

                                   

                                   

                                  BOL: D07000 Reference: 4000600392     /B

                                     

                                  CASE PICK SURCHARGE           CAS     472.00     0.11     EA            94.82

                                  BOL: D06993 Reference: 4000600393    

                                     

                                  CASE PICK SURCHARGE           CAS     789.00     0.11     EA           158.51

                                  BOL: D06990 Reference: 4000600395    

                                     

                                  CASE PICK SURCHARGE           CAS      52.00     0.11     EA            10.45

                                  BOL: D07004 Reference: 4000600321    

                                     

                                  CASE PICK SURCHARGE           CAS      20.00     0.11     EA             4.02

                                  BOL: D06991 Reference: 4000600159     A

                                     

                                  CASE PICK SURCHARGE           CAS      84.00     0.11     EA            16.88

                                  BOL: D07022 Reference: 4000600248    

                                     

                                  CASE PICK SURCHARGE           CAS     288.00     0.11     EA            57.86

                                  BOL: D07021 Reference: 4000600247

                                     

                                  CASE PICK SURCHARGE           CAS      30.00     0.11     EA             6.03

                                  BOL: D07010 Reference: 4000600650     W

                                     

                                  CASE PICK SURCHARGE           CAS      90.00     0.11     EA            18.08

                                  BOL: D07012 Reference: 4000600656     W

                                     

                                  CASE PICK SURCHARGE           CAS     466.00     0.11     EA            93.62

                                  BOL: D07001 Reference: 4000600653    

                                     

                                  HANDLING CHARGES - Acct2     09       36.00     2.35     PLT          227.88

                                  Receipt: 110436 Reference: D&D0104330

                                     

                                  HANDLING CHARGES  - Acct      09       23.00     4.30     PLT          160.08

                                  Receipt: 110439 Reference: 4540104498

                                     

                                  HANDLING CHARGES  - Acct      09       23.00     4.30     PLT          160.08

                                  Receipt: 110440 Reference: 4540104490

                                     

                                  HANDLING CHARGES  - Acct      09       23.00     4.30     PLT          160.08

                                  Receipt: 110441 Reference: 4540104488

                                     

                                  HANDLING CHARGES  - Acct      09       23.00     4.30     PLT          160.08

                                  Receipt: 110442 Reference: 4540104497

                                     

                                  HANDLING CHARGES  - Acct      09       20.00     4.30     PLT          139.11

                                  Receipt: 110443 Reference: 4540104212

                                     

                                  HANDLING CHARGES  - Acct      09       20.00     4.30     PLT          139.11

                                  Receipt: 110444 Reference: 4540104218

                                     

                                  HANDLING CHARGES  - Acct      09       23.00     4.30     PLT          160.08

                                  Receipt: 110445 Reference: 4540104496

                                     

                                  HANDLING CHARGES  - Acct      09       23.00     4.30     PLT          160.08

                                  Receipt: 110446 Reference: 4540104489

                                     

                                  HANDLING CHARGES  - Acct      09       20.00     4.30     PLT          139.11

                                  Receipt: 110447 Reference: 4540104208

                                  -


                                  /QUOTE

                                    • MultilineTrap Pagebreak splitting line
                                      Ziggy _

                                      Thanks for looking, I suspect you are always up for the Challenge... but don't kill yourself because if the solution is a lot of effort, I could easily spend that time in Excel VBA as I know that quite well.  I can make the code search for the line and 4 blank rows below and delete them.

                                        • MultilineTrap Pagebreak splitting line
                                          Grant Perkins

                                          Thanks for looking, I suspect you are always up for the Challenge... but don't kill yourself because if the solution is a lot of effort, I could easily spend that time in Excel VBA as I know that quite well. I can make the code search for the line and 4 blank rows below and delete them.[/quote]

                                           

                                          Ziggy,

                                           

                                          Yes you could do that and manipulating the file(s) is an option of course - the Monarch Utility provides a few tools for doing just that for certain types of file.

                                           

                                          However I think the issue here is a little simpler to resolve.

                                           

                                          There are 2 types of dashed line that indicate 'page breaks'.

                                           

                                          As I see it the shorter one is the page break indicator from your data grab process and is now embedded as text in the input file. Looks like it's about aevery 66 lines or so but I have not bothered to count them so far.

                                           

                                          The longer dashed line going tight across the page is Monarch's virtual page preak indicator.

                                           

                                          Create a new template using one of the SHORTER dashed lines and the 3 blank lines that follow it as the 4 line SAMPLE and trap on a long line of dashes. 9Enough to be sure you get the right line!). Make the template a Page Header template.

                                           

                                          Now Monarch should show a full width dashed line for every shorter dashed line. (It will look odd but no matter.). The Monarch Page Header template is 'invisible' when Monarch parses for the (2 line in this case) Detail template and you second lines should be always connected with the first line.

                                           

                                          You can check this by creating a detail template with 1 field for each line (NOT a multiline  field for this test) and you should see 2 fully populated columns when using your sample data as posted.

                                           

                                          Does that make sense as a description?

                                           

                                          Let me know how you get on.

                                           

                                           

                                          Grant

                                            • MultilineTrap Pagebreak splitting line
                                              Ziggy _

                                              I tried it quickly but I get some blank records (first 16 rows) for the d...I'll try again later...I'm logging off for the day right now...maybe I'll get some time over the weekend...

                                               

                                              I wonder if I'm taking the wrong approach, maybe it should be 2 single line, Detail/Append?

                                               

                                              Thanks

                                                • MultilineTrap Pagebreak splitting line
                                                  Grant Perkins

                                                  I tried it quickly but I get some blank records (first 16 rows) for the d...I'll try again later...I'm logging off for the day right now...maybe I'll get some time over the weekend...

                                                   

                                                  I wonder if I'm taking the wrong approach, maybe it should be 2 single line, Detail/Append?

                                                   

                                                  Thanks[/quote]

                                                   

                                                  Based on the sample and assuming it is representative of the entire input file, you only need a 2 line detail template and then the page header.

                                                   

                                                  Send me a PM with your email address and I'll forward the sample file and model I set up as an example.

                                                   

                                                   

                                                  Grant

                                                    • MultilineTrap Pagebreak splitting line
                                                      Olly Bond

                                                      Hello Ziggy,

                                                       

                                                      Just a thought - perhaps if you tell Monarch to treat every blank line as a Page Header (so you get thousands of pages, each one or two lines long) then you might get around it? Perhaps you might need to Prep to replace "-" followed by CR/LF with "-" followed by CR/LF/CR/LF.

                                                       

                                                      HTH,

                                                       

                                                      Olly

                                                        • MultilineTrap Pagebreak splitting line
                                                          Ziggy _

                                                          Hi Grant,

                                                           

                                                          I got off to a fresh start today, seems my frustration was clouding my thinking.  I did again what you mentioned in post 13, and made a 4 line trap on the dashed lines and made it a header.... then a 2 line trap for the "detail"...it looks like it is working.  I will try on a few more examples to make sure it isn't a fluke.

                                                           

                                                          Olly thanks for the reply, your suggestion sounds similar.

                                                            • MultilineTrap Pagebreak splitting line
                                                              Grant Perkins

                                                              Hi Grant,

                                                               

                                                              I got off to a fresh start today, seems my frustration was clouding my thinking.  I did again what you mentioned in post 13, and made a 4 line trap on the dashed lines and made it a header.... then a 2 line trap for the "detail"...it looks like it is working.  I will try on a few more examples to make sure it isn't a fluke.

                                                               

                                                              /quote

                                                               

                                                              Hi Ziggy,

                                                               

                                                              Glad you got a result. It's not uncommon to be really close to a solution but not quite in a position to see it. I wasted the best part of a day last week chasing around for a fast solution to a washing machine failure that was presenting itself as 'probably catastrophic and terminal' (just before a long holiday weekend here in the UK) when in fact I have missed the basic 'step one' analysis that would have suggested to me that the motor needed new electrical contact brushes. Something I read on a forum prompted me to think it through again and sure enough, just the brushes required, not a whole new machine.

                                                               

                                                              Of course the 'reason' I did not think about that for this machine (apart from the symptoms not being normal) is that it has never needed brushes in 11 years  .... so why would it need them now?  Doh!

                                                               

                                                              A wood hidden by its trees.

                                                               

                                                              Just be sure to check the consistency of the reports you will be analysing. Field widths need to be set to the maximum possible which may be different for the max in the samples/development reports you use. I would recommend the Verify feature for this.

                                                               

                                                              Also check that the 2 line detail is never compromised. A 1 line record might be OK if followed by a blank line but a 3+ line record would be a problem if not assessed some more.

                                                               

                                                              Have fun.

                                                               

                                                               

                                                              Grant