2 Replies Latest reply: May 15, 2014 10:13 AM by Nick Osdale-Popa RSS

    MCR not trapping data across pages

    Nick Osdale-Popa

      Hello All! I know I haven't been on here in, well, quite some time. Hope everyone is doing well. I have a report where I'm using an MCR on the six columns in the below report (LABOR thru CO EQUIP). I also need the TOTAL: line as part of the MCR too.

      2 Appends, one for Proposal number (BR#001) and one for  Job Number (though this can be moved to the page header if need be)

      Everything traps fine, except the MCR quits when it spans over the page and I only get column 1 (Labor), none of the other columns are trapped.

       

      RUN DATE 06/11/12 13:33:44                                                                     JOB STATUS MODULE                                                                    PAGE     8

      NAMEOF COMPANY                                                                                CHANGE REPORT (DETAIL)

                                                                                      BY PROPOSAL NUMBER

                                                                                      THROUGH PERIOD ENDING:  06/30/12

                                                                                      STARTING PROPOSED DATE:

                                                                                      ENDING PROPOSED DATE:   12/31/19

                                                                                      STARTING APPROVED DATE:

                                                                                      ENDING APPROVED DATE:   12/31/19

                                                                                      STARTING TRANSACTION DATE:

                                                                                      ENDING TRANSACTION DATE:   12/31/19

       

      JOB:  XXX.XXX         JOB NAME

       

      PROPOSAL    CUST C/O NO.   REASON                             REV TYPE/  STATUS    CONTRACT/ PRO DATE      CONTRACT/     REV BUD/                                             RMAC            EMAC

                   CUST P/O                                          COST TYPE            RRM       APP DATE          NTEA     INC COSTS            ECAC            PTCV            RMAC%           EMAC%

       

      BR#001                     P.M. REVISION                      RB         OTHER-NO            02/15/12        50,573        43,879

                                                                     PMR                  POCM      02/15/12

       

                 PHASE COST CODE   QUANTITY       HOURS        LABOR     MATERIAL   SUBCONTRAC    EQUIPMENT        OTHER    C.O.EQUIP

                 01    BGST           80.00        80        5200.00          .00          .00          .00          .00          .00

                       COST CODE DESCRIPTION

                 01    DEMO           40.00        40        2600.00          .00          .00          .00          .00          .00

                       COST CODE DESCRIPTION

                 01    XCAV          230.00       230       14950.00          .00          .00          .00          .00          .00

                       COST CODE DESCRIPTION

                 02    HALPSTMC      376.00       376       24427.00          .00          .00          .00          .00          .00

                       COST CODE DESCRIPTION

                 02    STMC           80.00        80        5200.00          .00          .00          .00          .00          .00

                       COST CODE DESCRIPTION

                 02    WELD           16.00        16        1040.00          .00          .00          .00          .00          .00

                       COST CODE DESCRIPTION

                 GC    OTCN            0.00        00      -13020.00          .00          .00          .00          .00          .00

                       COST CODE DESCRIPTION

                 MA    9513            0.00        00            .00      2116.00          .00          .00          .00          .00

                       COST CODE DESCRIPTION

                 MA    9521            0.00        00            .00      4640.00          .00          .00          .00          .00

                       COST CODE DESCRIPTION

                 MA    9524            0.00        00            .00       255.00          .00          .00          .00          .00

                       COST CODE DESCRIPTION

                 MA    9526            0.00        00            .00       455.00          .00          .00          .00          .00

                       COST CODE DESCRIPTION

                 MA    9531            0.00        00            .00       500.00          .00          .00          .00          .00

                       COST CODE DESCRIPTION

                 MA    9532            0.00        00            .00       600.00          .00          .00          .00          .00

                       COST CODE DESCRIPTION

                 MA    9533            0.00        00            .00    -15000.00          .00          .00          .00          .00

                       COST CODE DESCRIPTION

                 MA    9646            0.00        00            .00      4000.00          .00          .00          .00          .00

                       COST CODE DESCRIPTION

                 MA    9647            0.00        00            .00          .00          .00          .00       600.00          .00

                       COST CODE DESCRIPTION

                 MA    9740            0.00        00            .00          .00          .00          .00       336.00          .00

                       COST CODE DESCRIPTION

      RUN DATE 06/11/12 13:33:44                                                                     JOB STATUS MODULE                                                                    PAGE     9

      NAMEOF COMPANY                                                                                CHANGE REPORT (DETAIL)

                                                                                      BY PROPOSAL NUMBER

                                                                                      THROUGH PERIOD ENDING:  06/30/12

                                                                                      STARTING PROPOSED DATE:

                                                                                      ENDING PROPOSED DATE:   12/31/19

                                                                                      STARTING APPROVED DATE:

                                                                                      ENDING APPROVED DATE:   12/31/19

                                                                                      STARTING TRANSACTION DATE:

                                                                                      ENDING TRANSACTION DATE:   12/31/19

       

      JOB:  XXX.XXX         JOB NAME

       

      PROPOSAL    CUST C/O NO.   REASON                             REV TYPE/  STATUS    CONTRACT/ PRO DATE      CONTRACT/     REV BUD/                                             RMAC            EMAC

                   CUST P/O                                          COST TYPE            RRM       APP DATE          NTEA     INC COSTS            ECAC            PTCV            RMAC%           EMAC%

       

                 PHASE COST CODE   QUANTITY       HOURS        LABOR     MATERIAL   SUBCONTRAC    EQUIPMENT        OTHER    C.O.EQUIP

                 MA    9801            0.00        00            .00          .00      4980.00          .00          .00          .00

                       COST CODE DESCRIPTION

                         TOTAL:      822.00       822       40397.00     -2434.00      4980.00          .00       936.00          .00

       

       

      /CODE

        • MCR not trapping data across pages
          Olly Bond

          Hello Nick,

           

          Welcome back! If you drop me a line with the model file I'll gladly fix it. There's two tricks - you might need both - that are worth trying. There's a mini-bug where an MCR runs to the end of a page and the bottom entries of the last two columns are mislabelled - in v10.0 which is fixed in 11.2. I've not seen it drop four columns like you're reporting, but you can avoid this.

           

          You can work around this by tweaking the page breaks, and sometimes by adding two additional columns to your region and filtering out the null values. Sometimes, it helps to create a dummy footer template to end the MCR on, rather than running up to a page break. This can sometimes be achieved with a first pass model that outputs a fixed text summary with well behaved data.

           

          Best wishes,

           

          Olly