4 Replies Latest reply: May 15, 2014 10:01 AM by clinlab _ RSS

    help for trapping memo type data

    clinlab _

      Hi, i am having problems i can not solve so I come for help. PLEASE!

      I hope I can explain this adequately.

      Report structure:

       

                     

                            header ( header trap explicit)

                  address

                  address

       

      REQ: info1 (append trapped explicit REQ)

      infor2

       

      -


      col1                col2              col3

      -


      data       ^      data       ^    data                (append trapp detail)

      data       ^      data       ^    data       

      data       ^      data       ^    data       

      data       ^      data       ^    data       

       

       

      -


       

                            header

                  address

                  address

      Sec:infotype3 (append trap 'Sec')

      infotype4

      -


      special Information                                      (append trap "special')

      -


      This is a lot of                                             (memo field...)

      descriptive text

      that is variable length

      etc.....

       

      -


       

       

       

      Then the report might go back to the first page styling

      I have several traps set up for the report heading, report

      header info and the report detail. basically as noted.

       

      I can get the append traps to work great for pages that have the

      multiple line data seperated by the ^'s. however when I make

      an append to get the memo type data as an example on the

      second page, Then the memodata goes on EVERY record of the

      table view From the first to the last. I would think it would pick it up in order

      processed, but it goes on every record. I must be doing something wrong or

      is there a way to make it process in a certain order? i read the entire book

      and just can not find an answer. Please help. Thanks!

        • help for trapping memo type data
          Grant Perkins

          Hello clinlab and welcome to the forum.

           

          Your outline description reminds me of some reports that have been presented in the past for treatment as one large and long record.

           

          However from your description do I understand correctly that you are using the 3 columns of information in the second section as you detail records with each 'data' (as shown in your illustration) being a separate detail record?

           

          If so and if all the other sections are appends, headers or footers you will indeed see them attached to many detail records  - possibly not the correct records either based on your outline and my reading of it, but that is for a separate discussion.

           

          Bear in mind that if during the course of analysis you were to filter out some of the detail records you may still need the append information for your report, though of course large amounts of free text might always be of dubious value at that level. It might be worth thinking about different models for different purposes if you have conflicting analysis needs.

           

          Subject to your answers to the above I will see if I can find something from the 'archives' that might give us a handle on the solution you need.

           

           

          HTH.

           

           

          Grant

            • help for trapping memo type data
              clinlab _

              Thanks

              I will need to to another model and run

              monarch twice. Once for each model.

               

              I can do that. It's just a lot of extra work.

               

              I still have a weird problem though

              I set two different traps for headers. the detail

              data being the same trap. Each header trap has

              different fields, however when they get to the table

              the trap data from the previous trap runs through the

              data from the current trap. So its impossible

              to tell which heading the detail belongs to. I

              guess I could the multiple run thing, but I

              was hoping to avoid it.

               

              Any ideas why it just keeps duplcating? Flag or something

              to set?

               

              Thanks

                • help for trapping memo type data
                  Grant Perkins

                  Hi,

                   

                  Creating a second model should not be too difficult and you could consider creating a batch file to run both of them at the same time if that is what you need to do.

                   

                  For some of the other sort of similar examples back in time there was a way to extract most of the data as detail in a single pass but it could be that the reports are different enough to make that non viable.

                   

                  I'm not sure I understand your duplicated data/traps problem. Each model can only produce the data fields defined in its templates. Are you then exporting the resulting tables?

                   

                  Does the Model Info give any assistance to discovering where the fields come from? The Field List will certainly tell you the source template for each field.

                   

                  HTH.

                   

                   

                  Grant

                    • help for trapping memo type data
                      clinlab _

                      Thanks for the help.

                      The only way i could show you is to post

                      the report file and resultant data.

                       

                      Is there any way you know that I could post this on here

                      that would make sense to you? i could email it to you.

                      my email is (awilson25 at cfl.rr.com) i put it like that

                      to stop the web bots from grabbing it and adding me to the

                      spam world.

                       

                       

                      Thanks

                      Allen