1 Reply Latest reply: May 15, 2014 10:02 AM by joey RSS

    Trap Assistance - Multiline

    pwoods4143 _

      Hi, I am new to the Monarch software. I am a  Version 7 User and need some insight as to how to trap a report I have. I thought it would be relatively simple but has turned out to be more complicated than expected.

      Here is a Report Sample:

      Management Unit:   1 CAD2 Store Services                                                                               

      Selected by: Agent Data: Sup Agent Data Value: SWP - Crayton                  

      Sorted by: Name                                                               

      Report Across Agent Moves: No  Report Agent Moves: No                                                                               

      660532 SWP Berhanemeskel, R                                                

      Date      Day  Start   Stop    Exception Code        Start   Stop             

      ________  ___  ______  ______  ___________________   ______  ______           

      08/10/08  Sun  11:30   20:00   New Hire Training     11:30   20:00            

      08/11/08  Mon  17:00   22:00   New Hire Training     17:00   22:00            

      08/12/08  Tue  17:00   22:00   New Hire Training     17:00   22:00            

      08/13/08  Wed  17:00   22:00   New Hire Training     17:00   22:00            

      08/14/08  Thu  17:00   22:00   New Hire Training     17:00   19:07            

                                     Break                 20:01   20:22            

                                     New Hire Training     20:42   22:00            

      08/15/08  Fri   OFF     OFF                                                   

      08/16/08  Sat   OFF     OFF                                                                               

      3579 SWP Davis, Margaret                                                 

      Date      Day  Start   Stop    Exception Code        Start   Stop             

      ________  ___  ______  ______  ___________________   ______  ______           

      08/10/08  Sun  14:30   18:00                                                  

      08/11/08  Mon   OFF     OFF                                                   

      08/12/08  Tue  18:00   21:30                                                  

      08/13/08  Wed  17:30   21:00                                                  

      08/14/08  Thu  17:30   21:00                                                  

      08/15/08  Fri   OFF     OFF                                                   

      08/16/08  Sat  17:00   22:00   Break                 19:20   19:35                                                                               

      3642 SWP Ford, Airyona                                                   

      Date      Day  Start   Stop    Exception Code        Start   Stop             

      ________  ___  ______  ______  ___________________   ______  ______           

      08/10/08  Sun  13:15   19:00   PTO Unscheduled       13:15   19:00            

      08/11/08  Mon  16:30   22:00   Break                 19:15   19:30            

      08/12/08  Tue  17:00   22:00   Additional Hours      17:00   18:30            

                                     Break                 19:15   19:30            

      08/13/08  Wed  16:30   22:00   Break                 19:15   19:30            

      08/14/08  Thu   OFF     OFF                                                   

      08/15/08  Fri   OFF     OFF                                                   

      08/16/08  Sat  12:00   16:00   Additional Hours      12:00   14:05            

                                     Break                 14:05   14:20            

                                     Additional Hours      14:20   16:00            

      /CODE                                                                               

      Now I can trap 100% of the data with no issues. The problem is that I only need the Data from the first 4 rows - "Date, Day, Start and Stop". Then just the Data from the "Exception Code, Start and Stop" side only if the "Exception Code" is "Lunch". And I need that Lunch data to corresponde with the Agent and the Workday. I have tried trapping the Lunch alone in every way I can consive of. But the results are always repeating values that to do not belong on that Date with that particular agent. Header or Footer traps have not been successful for me yet. Can anyone offer me some assist on what I might try next.

       

      Thanks for any assistance,

        • Trap Assistance - Multiline
          joey

          I dont' think your report sample has any lunch's on it does it? 

           

          But I see your problem.  There are several solutions, but the question becomes what do you want to do with the data? 

           

          One simple solution would be to trap everything as you have it. You would have 7 fields from the detail lines:

           

          DATE DAY START STOP  EXCP EXCP-START EXCP-STOP

           

           

          I would add two calculated fields to replace EXCP-START and EXCEP-STOP  These would check the value in EXCP to see if it is LUNCH.  IF so, they would carry the field value that you are replacing.  Otherwise, they would load a zero.