9 Replies Latest reply: May 15, 2014 10:08 AM by Olly Bond RSS

    Complex Report

    Kristie _

      Hi,

      I have this report (below) that has three columns of data but each account can have more or less transaction entries than the others.  I am not even sure where to start on this but is there a way to include all of the entries in each of the three columns to the previous account number until it comes across a new account number?

      Thanks in advance for any help.

      /999999/ XXXXXXX XXXX                        XXX TRANSACTION JOURNAL               XX-02   XXXXXXXXX   07/02/10         PAGE   1

       

       

       

        ACCT #     TC      AMOUNT      SEQ          ACCT #     TC      AMOUNT      SEQ          ACCT #     TC      AMOUNT      SEQ

       

      000000011111 60        1.00 00000000000000  000000022222 19       34.14 00000051041230  000000033333 15         .62 00000000007266

                   60       52.40 00000000000000  000000033334 19       60.00 75972178150712             RUS TRANSFER TO ACCT

                   13       32.00 00000000038200             THRIV    FINANCL CHEC            000000044444 60       46.00 00000000000000

                 PUR FAMILY EXPRESS 16            000000055555 17      750.00 00000027132110               60      137.47 00000000000000

      000000066666 19       69.21 42000013658264  000000077777 60        1.00 00000000000000               42      199.01 00000027132000

                 TARGET T1286 PURCHASE                         60       27.50 00000000000000               13        6.41 00000000027115

      000000088888 19     1334.89 31000030877569               42       28.88 83962000194648             PUR WALGREEN COMPANY

                 MORTGAGE SERV CT MTG                        VSA RTN ALOHA-2 VALPA                         19       57.25 75000054520984 /code

        • Complex Report
          Olly Bond

          Hello Kristie,

           

          You can do this with the field properties. If you double click on the field, there's a radio button on the dialog which says "Empty cells: ( ) leave blank ( ) copy from previous record". Click on the "copy from" option and you should be fine. To see an example in action, open Classic.prn and Lesson11.xmod from the sample files and look at the Media field.

           

          This will give you one line of data in the table for each line that corresponds to an account number. If you then need to collate the data for each account you'll be able to do that with a summary.

           

          HTH,

           

          Olly

            • Complex Report
              Data Kruncher

              Kristie,

               

              Are you comfortable with creating the multi-column region template for your report?

                • Complex Report
                  Kristie _

                  Hi,

                  I will check out the sample files.  I have read a bit about the multi column region templates so I will give it a try.  If I can't get both methods together in the same template I will report back.   Thanks so much for the speedy replies!

                    • Complex Report
                      Data Kruncher

                      I defined the MCR having three columns, the left position of one, and the width of 44.

                       

                      I built the detail template trap with the two numeric traps for the TC number.

                       

                      Set the Account number to copy the value from the previous record.

                       

                      Finally, if you want to extract the notes/comments, build a footer template to pick them up.

                       

                      HTH,

                      Kruncher

                        • Complex Report
                          Kristie _

                          That helps greatly!  Thanks again!

                            • Complex Report
                              Kristie _

                              Hi, I am back to this again.  It seems that if the account number doesn't make it to the top of the second or third column then it copies the first account number on the page.  For example, if 22222 was missing because 22222 started at the bottom of column 1 and wrapped up then it would copy 11111 as the account number on the transaction at the top of column two.   Does that make sense?

                              Thanks in advance for your help.

                                • Complex Report
                                  Olly Bond

                                  Hello Kristie,

                                   

                                  That's a known bug in v10 that I think is fixed in 11.5. One workaround I've used is to define a few extra columns, more than I need, and filter the unnecessary records out of the table. Feel free to email me the model and report.

                                   

                                  Best wishes,

                                   

                                  Olly

                                    • Complex Report
                                      Kristie _

                                      Thank you, I sent it over, please let me know if you did not receive it.

                                        • Complex Report
                                          Olly Bond

                                          Hello Kristie,

                                           

                                          Got it safely. Nothing seems amiss with what you've sent me, in 11.5, the copy value from previous record picks up correctly from the bottom of the previous column.

                                           

                                          60     1     000000011111     001.007.001

                                          60     52.4     000000011111     001.008.001

                                          13     32     000000011111     001.009.001

                                          19     69.21     000000022222     001.011.001

                                          19     1334.89     000000033333     001.013.001

                                          19     34.14     000000033333     001.007.002

                                          19     60     000000044444     001.008.002

                                          17     750     000000055555     001.010.002

                                          60     1     000000077777     001.011.002

                                          60     27.5     000000077777     001.012.002

                                          42     28.88     000000077777     001.013.002

                                          15     0.62     000000088888     001.007.003

                                          60     46     000000099999     001.009.003

                                          60     137.47     000000099999     001.010.003

                                          42     199.01     000000099999     001.011.003

                                          13     6.41     000000099999     001.012.003

                                          19     57.25     000000099999     001.014.003[/CODE]

                                           

                                          The last field is just str(Page();3;0;"0")"."str(Line();3;0;"0")"."str(Column();3;0;"0") - it's a handy way to see what's going on in the table.

                                           

                                          Best wishes,

                                           

                                          Olly