1 Reply Latest reply: May 15, 2014 10:08 AM by Olly Bond RSS

    How to attack problem report

    spudmcc _

      I am having lots of trouble handling the report below.  Each record needs to include the route, each of the dates listed below the dashes, ed code (04) and the returns.  Problem is that there is an inconsistent number of dates in each record.  Ideally I would like to have the route, the day, edition and returns on just one line per record.  The example below would have 7 records for BN4256. 

       

      Any help or guidance would be greatly appreciated.  I am rather new to Monarch so I ask you to please "Keep it Simple".

       

      ===========================================================

       

       

       

       

      ROUTE: BN4256        RECORD #:    1            FIRST DATE: 06/22/10       LAST DATE: 06/28/10                                   

      EDITION: 04        CASH IN DATE: 07/02/10           CARRIER: ACCT #  168441       EDDIES HERO WORLD                               

       

         DATE    ED RETURNS            DATE    ED RETURNS            DATE    ED RETURNS            DATE    ED RETURNS                   

      -


        -- -


                -


        -- -


                -


        -- -


                -


        -- -


                           

      06/22/10  04      6            06/23/10  04      8           06/24/10  04  7           06/25/10  04      8            06/26/10  04      5           06/27/10  04  3           06/28/10  04      9                                                  

       

      -


      BATCH #:  15004    CONTROL DATE: 07/02/10   *RECORD IS UN-POSTED*   TOTAL RETURNS:       21   TOTAL $     9.38                  

       

        ROUTE: BN5246        RECORD #:    1            FIRST DATE: 06/17/10       LAST DATE: 06/30/10                                   

      EDITION: 04        CASH IN DATE: 07/02/10           CARRIER: ACCT #  187634       DNJ FOOD CORP.                                  

       

         DATE    ED RETURNS            DATE    ED RETURNS            DATE    ED RETURNS            DATE    ED RETURNS                   

      -


        -- -


                -


        -- -


                -


        -- -


                -


        -- -


                           

      06/17/10  04      1     06/23/10  04      1      06/24/10  04 3                                                                                /SIZE

        • How to attack problem report
          Olly Bond

          Hello Spudmcc, and welcome,

           

          You've got a classic variable width multicolumn region by the looks of things, but don't worry, you can do this in one model easily as long as... and this is the key, the maximum number of (Date/Edition/Return) sets one any one line is no greater than 40. If your data behaves safely within that limit, it should be easy. If not, there are workarounds but I can't promise that we'll be able to "keep it simple"

           

          Best wishes,

           

          Olly