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

    vertical, multiline report

    Manda516 _

      Hello!

       

      I searched this website all day yesterday and while I did learn some pretty cool things, I don't know if there was anything out relating to my problem, at least that I saw.

       

      I have been working with Monarch for a while now, but usually only used the Report part to create templates to export the data into some kind of delimitted text. And Usually the data was all on one line across the top.

       

      The issue I'm running into now, is that I have a report that runs vertically instead of horizontally. On top of that the there may be multiple lines for certain fields. If anyone has any insight, can you please let me know what I need to do. My head is starting to hurt!

       

      Here is an example but this is only a quarter of the report. There is more info that is to the right of this and more info below it. Also, the formatting below doesn't seem to come out exactly right. For the most part all the fields line up after the "......".

       

      Again any help is GREATLY appreciated!

       

                  PATIENT     xxxxxxx DOE, WILLIAM C

      -


                          

          • PATIENT INFORMATION ***

      -


        NAME....................   DOE, WILLIAM C

        ADDRESS................. 931 W.LAKESIDE  PL

                                      #2

                                      CHICAGO              IL  60640

        TELEPHONE............... 773 334-xxxx

        SOCIAL SECURITY NUMBER   xxx-xx-xxxx

        OCCUPATION..............

        DATE EMPLOYED...........  0/00/00

        EMPLOYER................  4192 RETIRED

        EMPLOYER TELEPHONE......

        SEX..................... M

        DATE OF BIRTH...........  3/27/1930

        MARITAL STATUS.......... D                                  

        PREVIOUS NAME...........                                    

        BIRTHPLACE..............                                    

        E G C................... W                                  

        RELIGION CODE........... CAT                                

        CHURCH CODE.............                                    

      -


                           

          • SPOUSE INFORMATION ***                

      -


        REFERENCE NUMBER........   xxxxxxx                          

        NAME.................... WINCHESTER, LIZ                    

        ADDRESS................. 931 W.LAKE SIDE PL #2              

                                 CHICAGO              IL 60640      

        TELEPHONE............... 773 334-xxxx                       

        RELATION TO PATIENT..... DAUGHTER                           

      -


       

       

                  PATIENT     xxxxxxx DOE, GERALD R                 

      -


                          

          • PATIENT INFORMATION ***                

      -


        NAME.................... DOE, GERALD R                      

        ADDRESS................. 8953 S. BENNETT                    

                                 CHICAGO              IL  60617     

        TELEPHONE............... 773 978-xxxx                       

        SOCIAL SECURITY NUMBER   xxx-xx-xxxx                        

        OCCUPATION..............                                    

        DATE EMPLOYED...........  0/00/00                           

        EMPLOYER................ 41693 NORTHERN TRUST COMPANY       

                                 CHICAGO              IL 6000       

        EMPLOYER TELEPHONE...... 312 557-xxxx                       

        SEX..................... M                                  

        DATE OF BIRTH...........  1/10/1952                         

        MARITAL STATUS.......... M                                  

        PREVIOUS NAME...........                                    

        BIRTHPLACE..............                                    

        E G C................... B                                  

        RELIGION CODE........... OTH                                

        CHURCH CODE.............                                    

      -


                           

          • SPOUSE INFORMATION ***                

      -


        REFERENCE NUMBER........                                    

        NAME....................  NO SPOUSE INDICATED               

      -


       

        • vertical, multiline report
          Grant Perkins

          Manda,

           

          Is this close to the layout?

           

          Some fields look a little out of position still - should they all line up?

           

           

          PATIENT xxxxxxx DOE, WILLIAM C

          -


              • PATIENT INFORMATION ***

          -


          NAME.................... DOE, WILLIAM C

          ADDRESS................. 931 W.LAKESIDE PL

          #2

          CHICAGO IL 60640

          TELEPHONE............... 773 334-xxxx

          SOCIAL SECURITY NUMBER xxx-xx-xxxx

          OCCUPATION..............

          DATE EMPLOYED........... 0/00/00

          EMPLOYER................ 4192 RETIRED

          EMPLOYER TELEPHONE......

          SEX..................... M

          DATE OF BIRTH........... 3/27/1930

          MARITAL STATUS.......... D

          PREVIOUS NAME...........

          BIRTHPLACE..............

          E G C................... W

          RELIGION CODE........... CAT

          CHURCH CODE.............

          -


              • SPOUSE INFORMATION ***

          -


          REFERENCE NUMBER........ xxxxxxx

          NAME.................... WINCHESTER, LIZ

          ADDRESS................. 931 W.LAKE SIDE PL #2

          CHICAGO IL 60640

          TELEPHONE............... 773 334-xxxx

          RELATION TO PATIENT..... DAUGHTER

          -


           

           

          PATIENT xxxxxxx DOE, GERALD R

          -


              • PATIENT INFORMATION ***

          -


          NAME.................... DOE, GERALD R

          ADDRESS................. 8953 S. BENNETT

          CHICAGO IL 60617

          TELEPHONE............... 773 978-xxxx

          SOCIAL SECURITY NUMBER xxx-xx-xxxx

          OCCUPATION..............

          DATE EMPLOYED........... 0/00/00

          EMPLOYER................ 41693 NORTHERN TRUST COMPANY

          CHICAGO IL 6000

          EMPLOYER TELEPHONE...... 312 557-xxxx

          SEX..................... M

          DATE OF BIRTH........... 1/10/1952

          MARITAL STATUS.......... M

          PREVIOUS NAME...........

          BIRTHPLACE..............

          E G C................... B

          RELIGION CODE........... OTH

          CHURCH CODE.............

          -


              • SPOUSE INFORMATION ***

          -


          REFERENCE NUMBER........

          NAME.................... NO SPOUSE INDICATED

          -


          /code[/quote]

           

          Can you ever have more than one SPOUSE INFORMATION section? (And I assume it is really reporting 'Relative' rather than spouse?)

           

          At first sight I think you need to set up a DETAIL template for all the lines in the section with rows realting to the PATIENT and probably a FOOTER template for the rows relating to the SPOUSE section.

           

          In both cases the number of rows in the SAMPLEs for the template must not be bigger than the number of rows in the smallest record. So you need to find out how few rows a record can have.

           

          If you do that and then provide the answers for the other questions above we can give you some quite precise guidance here. The methods you need to use are advanced but not individually difficult. However it is usually much easier to introduce them to people with specific instructions rather than general guidance. That is why I asked the questions and suggested you should work out the smallest numbers of rows. (Rows meaning all rows in a block of the report that would represent a record - the dashed lines above can be used if we need them to make as many rows as possibkle in the record.)

           

          I'll check back later to see if you have had a chance to find the answers.

           

           

          HTH.

           

           

          Grant

           

          PS: Just checked and noticed you have V5. There have been a large number of advances since V5 and to be honest I can't remember exactly what V5 offered and I don't currently have a running version. I think we will be OK but some of the things we might suggest may not work as described first time in V5. I don't suppose you have any later version of Monarch in your organisation do you, just in case we need them?

            • vertical, multiline report
              Manda516 _

              Hi Grant,

               

              Would it be possible for me to send you the file to look at somehow? It might be easier if you could see the whole file then just a part.

                • vertical, multiline report
                  Grant Perkins

                  Manda,

                   

                  I will send you a PM with an email address. I assume the file will be small enough (especially if zipped) to attach to a mail?

                   

                  I would still need you to confirm whether the numbers of lines reported in each section does show the the minimum possible in at least one of the records. The smallest example of each section could be in different records.

                   

                  I may have a problem sending a working model - I don't think I have a working machine left that has a version of Monarch capable of saving a .mod file for V5. However it would still be useful to see the file.

                   

                   

                  Grant