16 Replies Latest reply: May 15, 2014 10:03 AM by Data Kruncher RSS

    Newbie question on multiple line record

    drobert _

      This is a newbie question, although I have been using Monarch for quite some time, but very sporadically. Also I should note that we are using Standard Version 6.01 :o (Yes, I know that it's an old version, but I have been trying to convince my boss in getting a newer version, but he is in the opinion that if it works, why replace it).[/FONT]

       

      The trouble I am having is that for the most part the report is fairly straightforward but what complicated things (for me anyways) is that this one sometimes contains information that continues on the second line. What I am trying to accomplish is to add the additional message (the one that may appear on the second line) to the record.

       

      I tried reading the documentation on multiple line field, but was not able to get it to work completely. As soon as I define the detail line as being two lines and define the AddtlMsg field (on the second line) with Start Field On[/B] defined using Preceding String[/B] = 100 blanks and End Field On[/B] defined using Minimum action only[/B] (or any other option, they seem to give me the same result). This only gives me records if the detail line falls on odd number line and every even number line is ignored.

       

      Can anyone give some pointers as how to get this to work, even though we are lagging behind in version?

       

      Below is a snippet of the report (some data has been scrambled to protect the innocent):

      SHIP TO  : XXXXXXXX CU                                 XXXXXXXX CREDIT UNION                    PAGE:    1

      RUN      : 06FEB09 07:10                   SYSTEM CLEARINGS - DEBITS AND CREDITS COMBINED        FOR: 05FEB09 00:00 TO 05FEB09 23:59

      REPORT # :  103                                                                               BRANCH: XXXXXXXX CU         001

       

      ACCOUNT MICR ACCT EFFDATE SC REV        AMOUNT    SERIAL NO. TRACE NO. RET.REF#

      ACCT    MEMB                  IT

      -


      -


      -


      -- ---        -


          -


      -


      -


       

      0000      0 C  0 05FEB09 CK            783.31-        19148  25090045         MEMBER   NOT ON FILE REJECTED TO GL 9912 DP000 BR  1

      B0010     42 C  0 05FEB09 CK          8,200.00-         4200  68600060         (DR) CLEARING POSTED

      B0017     42 C  7 05FEB09 CK             95.68-         1084  67880600         (DR) CLEARING POSTED

      0010     59 C  0 05FEB09 CK             67.83-          534  20780490         (DR) CLEARING POSTED STOP ENCOUNTERED

      0010    145 C  0 05FEB09 CK            986.27-          159  29040100         (DR) CLEARING POSTED

      B0010    240 C  0 05FEB09 CK            935.00-          907  67880935         (DR) CLEARING POSTED  2 SIGNATURES REQ'D

      0010    396 C  0 05FEB09 CK  IT        995.76-          579  79706919         (DR) CLEARING POSTED

      0010    396 C  0 05FEB09 CK             60.00-          577  60778805         (DR) CLEARING POSTED

      0010   1094 C  0 05FEB09 CK  IT         50.00-          328  79785058         (DR) CLEARING POSTED

      0010   1845 C  0 05FEB09 CK          9,562.08-          420  20530645         (DR) CLEARING POSTED

      0010   2385 C  0 05FEB09 CK             78.00-          655  67880645         (DR) CLEARING POSTED

      0010   2668 C  0 05FEB09 CK  IT         69.00-          647  79796988         (DR) CLEARING POSTED

      0010   2668 C  0 05FEB09 CK            989.60-          646  27900495         (DR) CLEARING POSTED

      0070   3055 G  0 05FEB09 CK          9,767.02-            1  80080530         OFFICE CHEQUE POSTED

      0070   3054 G  0 05FEB09 CK          9,609.06-            1  86070660         OFFICE CHEQUE POSTED

      0010   3835 C  0 05FEB09 CK             75.00-          389  67880710         (DR) CLEARING POSTED

      0010   4653 C  0 05FEB09 CK            629.27-          197  69500845         (DR) CLEARING POSTED

      0010   4653 C  0 05FEB09 CK            976.85-          193  67540655         (DR) CLEARING POSTED

      0010   4653 C  0 05FEB09 CK            800.00-           42  20630220         (DR) CLEARING POSTED

      0010   4653 C  0 05FEB09 CK            939.60-          194  29970035         (DR) CLEARING POSTED

      0010   4653 C  0 05FEB09 CK             75.36-          199  25990420         (DR) CLEARING POSTED

      B0010   5555 C  0 05FEB09 CK  IT        968.08-          765  37955136         (DR) CLEARING POSTED

      0010   5695 C  0 05FEB09 CK  IT         70.91-          119  79790986         (DR) CLEARING POSTED

      0010   5695 C  0 05FEB09 CK             85.00-          121  68720225         (DR) CLEARING POSTED

      0010   5894 C  0 05FEB09 CK             95.00-          373  20640790         (DR) CLEARING POSTED

      0010   6343 C  0 05FEB09 CK             50.00-          279  67880680         (DR) CLEARING POSTED

      0010   6949 C  0 05FEB09 CK  IT         90.00-          440  79798804         (DR) CLEARING POSTED

      0010   7609 C  0 05FEB09 CK  IT        726.03-          231  98827478         (DR) CLEARING POSTED

      0010   7996 C  0 05FEB09 CK  IT        950.00-          487  98827339         (DR) CLEARING POSTED

      0010   8058 C  0 05FEB09 CK  IT         76.69-          297  98812632         (DR) CLEARING POSTED

      B0010   8855 C  0 05FEB09 CK            920.00-          903  67880930         (DR) CLEARING POSTED

      B0010   8855 C  0 05FEB09 CK            956.35-          906  67880725         (DR) CLEARING POSTED

      0010   8865 C  0 05FEB09 CK          9,500.00-          824  26760610         WILL OVERDRAFT ACCOUNT

                                                                                      REJECTED TO GL 9912 DP000 BR  1

      0010   8865 C  0 05FEB09 CK            500.00-          825  25010305         (DR) CLEARING POSTED

      B0010   9826 C  0 05FEB09 CK  IT        597.00-         1198  79798025         (DR) CLEARING POSTED

      B0010   9826 C  0 05FEB09 CK            959.00-         1197  26850865         (DR) CLEARING POSTED

      0010   9899 C  0 05FEB09 CK             36.21-          726  26750050         (DR) CLEARING POSTED

      0010   9904 C  0 05FEB09 CK             65.00-          845  20510605         (DR) CLEARING POSTED

      0010   9930 C  0 05FEB09 CK             85.00-           71  26920600         (DR) CLEARING POSTED

      0010   9943 C  0 05FEB09 CK  IT        700.00-            8  79811462         (DR) CLEARING POSTED

      B0000  10055 C  0 05FEB09 CK            706.05-         3150  26010775         (DR) CLEARING POSTED

                                                                                     ZERO ACCOUNT MICR DEFAULTED TO   1

      B0010  20994 C  0 05FEB09 CK          8,500.00-          339  68070055         (DR) CLEARING POSTED

      B0010  20994 C  0 05FEB09 CK          8,500.00-          338  68070020         (DR) CLEARING POSTED

      B0010  20994 C  0 05FEB09 CK             87.16-          361  67540940         (DR) CLEARING POSTED

      B0010  31435 C  0 05FEB09 CK             47.00-         3465  34734520         WILL OVERDRAFT ACCOUNT

                                                                                      REJECTED TO GL 9912 DP000 BR  1

      B0010  31435 C  0 05FEB09 CK          6,334.74-         3462  61223423         WILL OVERDRAFT ACCOUNT

                                                                                      REJECTED TO GL 9912 DP000 BR  1

      B0010  32657 C  0 05FEB09 CK            634.21-         3463  62311221         WILL OVERDRAFT ACCOUNT

                                                                                      REJECTED TO GL 9912 DP000 BR  1

      0010  37535 C  0 05FEB09 CK            423.12-           76  74523431         (DR) CLEARING POSTED[/code]

       

       

      Thanks,

      Daniel

        • Newbie question on multiple line record
          Data Kruncher

          Hi Daniel, and welcome to the forum.

           

          I've not used v6, and rather than search past forum posts, I thought that I'd just ask: does v6 offer an option on the Advanced field settings for starting the field "After last defined field in template"?

           

          We can work around it if v6 doesn't offer that, but your solution will be simpler with it.

            • Newbie question on multiple line record
              drobert _

              Yes is does.  I forgot to mention that I also tried to use that option and it yielded the same result (skiping report lines) as using the Preceding string[/B] option.

                • Newbie question on multiple line record
                  Data Kruncher

                  Excellent.

                   

                  I trapped your details using the decimal point and two Ns for the amounts.

                   

                  Now build an append template using the same trap, and paint your additional notes starting at position 80, specifiying the "After last defined" Advanced option.

                   

                  You might want to build a calculated field with the Trim function to clean up the note a little.

                   

                  HTH,

                  Kruncher

                    • Newbie question on multiple line record
                      drobert _

                      Ok, let's see if I got this straight:

                      I select a single line to create the detail and identify my fields

                      I create an append with two lines (the first line like the detail and the additional line) and use the same trap, but paint the field from the second line and use the option After last fedined field in template[/B].

                      /LISTIs that correct?

                        • Newbie question on multiple line record
                          Nick Osdale-Popa

                          Not exactly, Kruncher is explaining the "Guru Trap".

                           

                          You'll define your append trap exactly as you defined your detail trap. Single line, trap on the decimal. But what you'll trap is at position 80 (highlighting what ever the sample line is displaying) and in the Advanced Tab, select "After last defined field in template."

                           

                          That should get you what you need.

                            • Newbie question on multiple line record
                              drobert _

                              That was exacly what I wanted!!!:D

                              Thanks a million!!!

                               

                              I guess I did not understand the explaination in the Help.  I really did not know that you can use a trap for a line that did not contain the data that you are actully trapping (very interesting!)... that really threw me off.

                               

                              Now that I know how to do it, I will certainly be able to use it on other comlpex reports that I have been avoiding for a long time now.  You learn something new everyday.

                               

                              Thanks again, Data Kruncher and Nick Osdale-Popa for you help.

                                • Newbie question on multiple line record
                                  Grant Perkins

                                  Daniel,

                                   

                                  The trap concept (in effect forcing an APPEND type transaction but commonly for data AFTER the DETAIL line(s) can also be used effectively with preceding string conditions. In extreme situations a string of blanks maybe be used.

                                   

                                  Just thought I would add a few suggestions while you are mulling over the newly identified potential solutions to your other reports. 

                                   

                                  In which respect ...

                                   

                                  while V6 was (and is) a fine product the much greater potential of V10 and especially the productivity gains that MAY be possible from the PRO version could offer you - and your boss - tremendous benefits in these tricky times.

                                   

                                  Obviously I can't be sure of that - it depends on what your needs are - but if you would like some strongly persuasive ideas just share with us where your most diffucult and most time consuming problems lie and I'm sure the members here will provide some cost effective and rapid ROI suggestions that would help bring your options up to date.

                                   

                                  Have fun.

                                   

                                   

                                  Grant

                                    • Newbie question on multiple line record
                                      drobert _

                                      I will certainly have other examples of difficult extracts, and any help to prove that a newer version can make life easier, and would be a feather in my cap.

                                        • Newbie question on multiple line record
                                          Data Kruncher

                                          Thanks for helping out in my absence gents. Glad to see that you've resolved your issue Daniel.

                                           

                                           

                                          Think about your reports and business issues as you review just some of the upgrades made to Monarch since v6:

                                          Using Monarch on PDF files,

                                          improvements to revising templates if the report layout changes,

                                          exporting summaries with Excel's outlines and formulas in place,

                                          many new functions,

                                          the ability to import objects (like filters and calculated fields, etc.) that you've already built in other models into the current model,

                                          faster exporting,

                                          /LISTClearly there are many more, including [URL="http://********************/tips/new-year-new-features"]the new features added to v10[/URL].

                                            • Newbie question on multiple line record
                                              Data Kruncher

                                              After some deliberation, I offer that, just as we now commonly refer to a particular template/trapping technique by the user-friendly "guru trap" name, we now refer to this variation[/I] which employs the "After last defined field" advanced option as the ...

                                               

                                              "Dogbert trap".

                                               

                                              All in favour?

                                                • Newbie question on multiple line record
                                                  drobert _

                                                  Hum... is that some kind of initiation? ;)[/FONT]

                                                  [/FONT]

                                                  I definitely did not invent that scenario as it is clearly shown in the help, but just not explained very well. At any rate, if others think that it is an appropriate name for it and makes it easier to identify the scenario, I am all for it.[/FONT]

                                                    • Newbie question on multiple line record
                                                      Data Kruncher

                                                      Initiation? Nope, just introducing some levity on the forum.

                                                       

                                                      And as you say, naming a technique seems to help identify it (see [URL="http://www.monarchforums.com/tags.php"]the tag cloud[/URL]).

                                                       

                                                      Can't hurt, right?

                                                        • Newbie question on multiple line record
                                                          Grant Perkins

                                                          You know Daniel the 'After Last Define Field in Template' option is, I suspect, an advanced setting that very often gets overlooked in favour of more complex (and unnecessary in many cases) possibilities.

                                                           

                                                          It's a feature, as Mike Urbonas might observe, 'Hidden in Plain view'.

                                                           

                                                          It deserves more exposure and credit for what it is. The timing of your question was right for this and naming may help people to recall the potential.

                                                           

                                                          It just seems right to give an oft forgotten but very useful feature a memorable name that seems to fit the circumstances rather well.

                                                           

                                                          IMO.

                                                           

                                                          This could catch on. Perhaps we people could claim naming rights for worthy solutions ...

                                                           

                                                           

                                                           

                                                           

                                                           

                                                          Grant

                                                      • Newbie question on multiple line record
                                                        Nick Osdale-Popa

                                                        I guess I did not understand the explaination in the Help.  I really did not know that you can use a trap for a line that did not contain the data that you are actully trapping (very interesting!)... that really threw me off.[/QUOTE]

                                                         

                                                        The thing about the text in the trap line is that it's just a sample representation of the text you want to trap. It helps you identify where you need to highlight the text to trap. So, you could in fact trap a completely blank line, make it trap on a decimal character at position 80, and highlight some blank area in the sample area and it will correctly find the right traps within the report. To sum up, the sample line is just that, it really has no bearing on what's actually happening in the report.

                                                         

                                                        After some deliberation, I offer that, just as we now commonly refer to a particular template/trapping technique by the user-friendly "guru trap" name, we now refer to this variation[/I] which employs the "After last defined field" advanced option as the ...

                                                         

                                                        "Dogbert trap".

                                                         

                                                        All in favour?[/QUOTE]

                                                         

                                                        I was just getting used to calling it the Guru Trap! Isn't this the same thing, just with different Advanced options? Or am I missing something?

                                                          • Newbie question on multiple line record
                                                            Grant Perkins

                                                            The thing about the text in the trap line is that it's just a sample representation of the text you want to trap. It helps you identify where you need to highlight the text to trap. So, you could in fact trap a completely blank line, make it trap on a decimal character at position 80, and highlight some blank area in the sample area and it will correctly find the right traps within the report. To sum up, the sample line is just that, it really has no bearing on what's actually happening in the report.[/quote]

                                                             

                                                            Absolutely correct with one notable exception that I can think of - the Floating Trap.

                                                             

                                                            When using the Floating Trap the data sample is absolutely key for getting things to work as they need to.

                                                             

                                                             

                                                            Grant

                                                            • Newbie question on multiple line record
                                                              Data Kruncher

                                                              I was just getting used to calling it the Guru Trap! Isn't this the same thing, just with different Advanced options? Or am I missing something?[/quote]

                                                               

                                                              You're probably right; this is bound to get confusing for us, let alone new visitors. Never mind. Let's leave well enough alone with the "guru trap".

                                                               

                                                              OK?