3 Replies Latest reply: May 15, 2014 10:01 AM by Data Kruncher RSS

    Export to multiple lines?

    AmyNRA _

      Is it possible to, instead of putting fields on one line, put them into two lines in table veiw?

       

      I kind of wish I could have two detail traps. 

       

      I have one very wide comment line that I need to have output on two lines.

       

      Right now I am running two models, appending the second export to that of the first.

        • Export to multiple lines?
          Data Kruncher

          Hi Amy,

           

          I think that you might be able to do this with a project export.

           

          It would help if you could post a sample of the report.

           

          Kruncher

            • Export to multiple lines?
              AmyNRA _

              The parts I'm dealing with here are the lines for insurance.  The left side with the ins. co. name and the right side with their address.  I want to produce as many lines as it takes with the detail that belongs to this one account.  Each line is to have the account number (so it links in our system to the account) and up to 80 characters of text.  It's easy enough to make each line be a line in table view, but I would like to make the address appear in a line below the ins. co. name.

               

              [FONT="Courier New"]                                                                               

              [;48 G23:34:30  05 Jun 2008                  C O L L E C T O R   W R I T E - O F F   R E P O R T          PAGE 1                    

                                                                   SMITHVILLE RADIOLOGY P C                                                                               

              3272177*1      ANNE N SMITH                      SS#   - 000-00-0000             ********** EMPLOYER **********                     

                             20 WATER ST                       BIRTH - 06/16/50 SEX- F         ST JOSEPH                                                                               

              PHONE - 6104669034              20 SHORT ST                                      

                             SMITHVILLE, PA 19000              GUARA -                         SMITHVILLE, PA 19000                              

              SITE - SMITHVILLE REG HOSP IP         PT TYPE - I   ADMIT - 08/22/07    DISCHG - 08/26/07                                          

              DIAGNOSIS CODES    1. 536.10  2.         3.         4.                                                                               

              -


              POLICY # -


              GROUP # -


              INSURANCE ADDRESS -


                  

              INS 1 - 0400 BLUE SHIELD PENNSYLV18356460303     390580     : PO BOX 890062//CAMP HILL, PA 17089-0062                               

              INS 2 - 0845 KEYSTONE MERCY HLTH YXM50064185                : CLAIMS PROCESSING DEPT/PO BOX 7115/LONDON, KY 40742                   

              INS 3 - 0501 MEDICAL ASSIST OF PA3001260532                 : DEPT PUBLIC WELFARE/PO BOX 8194/HARRISBURG, PA 17105                  

              -


              DR QTY----


              C O M M E N T S -


              08/25/07  76775  ECHOSCAN RETROPERITONEAL  53  1      85.00 : 01/23/08  KRS Payclass Change to 0400-INS INFO FROM PROMISE           

              08/22/07  74160  CT ABDOMEN ENHANCED       01  1     186.00 : 02/11/08  SYS REJECTED-PAYCLASS CHANGED TO 0495                       

              08/22/07  72193  CT PELVIS ENHANCED        01  1     170.00 : 02/11/08  JMG Payclass Change to 0100-PT NEEDS TO CALL WITH CORRECT IN

              10/15/07  0899   REJECTION BY HMO/PPO          1       0.00 : 02/11/08  JMG FROM ABOVE COMENT PROMISE WAS ALREADY CHECKED.          

              02/04/08  0499   REJECTION BY BLUE SHIELD      1       0.00 :                                                                               

              -


                                                                                         

              BALANCE                                              441.00                                                                         

              REFERRING DR/UPIN - RONALD EVERETT                 M68644                                                                           

              -


                                                                     

              03/26/08  1       Lett-   We previously sent you an itemized          441.00                                                        

              02/11/08  1       Stmt-This bill is your responsibility.              441.00                                                        

              01/23/08  1       Ins Claim-0400-BLUE SHIELD PENNSYLVANIA             441.00                                                        

              11/30/07  1       Lett-   We previously sent you an itemized          441.00                                                        

              10/17/07  1       Stmt-YOUR INSURANCE PLAN HAS REFUSED TO PAY         441.00                                                        

              09/20/07  1       Ins Claim-0845-KEYSTONE MERCY HLTH PLAN             441.00    /FONT[/CODE]

               

               

              [SIZE="1"](The names et al. have been changed to protect the innocent.)[/SIZE]

                • Export to multiple lines?
                  Data Kruncher

                  Something like this then?

                   

                  Account  Data                                                

                  3272177*1INS 1 - 0400 BLUE SHIELD PENNSYLV18356460303        

                  3272177*1PO BOX 890062//CAMP HILL, PA 17089-0062             

                  3272177*1INS 2 - 0845 KEYSTONE MERCY HLTH YXM50064185        

                  3272177*1CLAIMS PROCESSING DEPT/PO BOX 7115/LONDON, KY 40742 

                  3272177*1INS 3 - 0501 MEDICAL ASSIST OF PA3001260532         

                  3272177*1DEPT PUBLIC WELFARE/PO BOX 8194/HARRISBURG, PA 17105

                  /code