16 Replies Latest reply: May 15, 2014 10:08 AM by Bill Watson RSS

    Need help!

    su-san _

      Good morning everyone,

       

      1. Is it possible to create a model for this report?

      2. Can someone help me create a model for this report?

       

      I'm having trouble excluding total and subtotal lines because they match up with other data/traps.

       

        PROPERTY: 110398    WELL: 3506 ZACHRY HB C 2                                                                             

      G    05/10 1179475  18524         2930.60   4.82     14,117.29 ST           958.86      13,158.43 0.00222139         29.23 

                                                                     OFC                                                                               

      L    05/10 1179476  30677         2921.59   1.03      3,007.13 ST           229.59       2,777.54 0.00222139          6.17 

                                                                     OFC                                                                               

      PROPERTY: 110429    WELL: 4638 RANCHO BLANCO 29                                                                          

      G    05/10 1179563  19172         2161.60   4.82     10,423.07 ST           296.11      10,126.96 0.00540340         54.72 

                                                                     OFC                                                                               

      L    05/10 1179564  30678         2154.20   1.03      2,218.97 ST            72.18       2,146.79 0.00540340         11.60 

                                                                     OFC                                                                               

      PROPERTY: 110430    WELL: 6178 RANCHO BLANCO 30                                                                          

      G    05/10 1179565  19704         2962.62   4.82     14,275.51 ST           209.45      14,066.06 0.00429687         60.44 

                                                                     OFC                                                                               

      L    05/10 1179585  31449         2950.99   1.03      3,039.42 ST            48.87       2,990.55 0.00429687         12.85 

                                                                     OFC                                                                               

      PURCHASER TOTAL      G           23595.86   4.81    113,516.33 ST         6,481.65     107,034.68                   460.49 

                           L           22968.26   1.03     23,641.85 ST         1,511.55      22,130.30                    95.29                                                                               

      TOTAL                          137,158.18 ST         7,993.20     129,164.98                   555.78 

      /code

       

      Thanks!

        • Need help!
          Joe Berry

          Hi Su-san,

           

          I would trap using an alpha character and a blank starting in the column position that has the G or L in the first position.  Using an alpha and a blank trap excludes the totals lines.  I am making an assumption that you want the G and L lines.

           

          You can then add the Property information using an append template.

           

          Let me know if there are more questions.

            • Need help!
              su-san _

              I also need to capture the lines with OFC and ST because on other reports there are usually costs on the same row. For this particular report there isn't.

                • Need help!
                  Data Kruncher

                  Initially I'd developed the same solution that Joe recommended.

                   

                  Resolving your additional need to pick up the OFC records separately would be easy to trap using a NOT trap, but I don't believe that you have that option with v7.

                   

                  Instead, here's my approach.

                   

                  I built the detail template with a B blank trap in position 63, followed by two A alpha traps.

                   

                  Not knowing what the field names are, I named the field with the values of 18524, 30677 and 30678 as SpecialNumber. I made this a Character field.

                   

                  Then a filter named Ignore Totals with this expression removed the extra rows:

                   

                  Substr(,2,1) .NotIn. ("G","L","T")[/code]But again, I'm not certain that you have a .NotIn. operator in v7, so this would be an equivalent:

                   

                  Substr(,2,1) <> "G" .And.

                  Substr(,2,1) <> "L" .And.

                  Substr(,2,1) <> "T" /codeHow does that work for you?

                    • Need help!
                      su-san _

                      Holy Moley! I don't understand anything you just said. I'm still using Monarch at a very basic level.

                        • Need help!
                          Data Kruncher

                          No problem at all. We all started in the same novice position.

                           

                          Let's go a step at a time then, OK?

                           

                          Can you build the detail template and get 15 records from your sample?

                            • Need help!
                              su-san _

                              Okay, I think I'm there.

                                • Need help!
                                  Data Kruncher

                                  Good, now in the Table window use the menu item Data -> Filters. In the dialog that opens, click New.

                                   

                                  Supply "Ignore Totals" as the Filter Name. In the Expression box, paste in this text:

                                  Substr(,2,1) <> "G" .And.

                                  Substr(,2,1) <> "L" .And.

                                  Substr(,2,1) <> "T" /CODE

                                   

                                  Change the name of the SpecialNumber field to match whatever you used for that field.

                                   

                                  Click OK to save your new filter, and click the other OK in the Filters dialog.

                                   

                                  Still with me?

                                    • Need help!
                                      su-san _

                                      Here's what I'm running into. I don't know how to single out the data. The "Property" Rows will be my headers/append. I need all values under each property without capturing the totals.

                                       

                                            SALE  GSL      DIV                                                     COMPT           NET                    AMOUNT         

                                      PROD  DATE  NO.     ORDER        QUANTITY  PRICE        GROSS  CPT          AMOUNT         AMOUNT   RECV INT         RCVD   QUAL                                                                               

                                      BATCH: 83964    07/10 RV Deep Pseudo Unit     CK#: 0710 CP  DATE: 08/23/10     AMT:  0.00                                                                               

                                      PURCHASER: 91704 CALPINE ENERGY SERVICES LP                                                                               

                                      PROPERTY: 3999    WELL: 3999 DROUIN 8                                                                               

                                      G    07/10 1183540  18752          101.45-  2.47        251.03-                            251.03-1.00000000        251.03-                                                                               

                                      PROPERTY: 4093    WELL: 4093 DROUIN 13 1                                                                               

                                      G    07/10 1183531  18747          325.82-  2.47        806.22-                            806.22-1.00000000        806.22-                                                                               

                                      PROPERTY: 5371    WELL: 5371 DROUIN 15                                                                               

                                      G    07/10 1183524  18750          548.22-  2.47      1,356.54-                          1,356.54-1.00000000      1,356.54-                                                                               

                                      PROPERTY: 5902    WELL: 5902 RIO VISTA DEEP PSEUDO UNIT                                                                          

                                      G    07/10 1183563  18745         8305.15   2.47     20,550.51                          20,550.51 1.00000000     20,550.51                                                                               

                                      PROPERTY: 6070    WELL: 6070 DETERDING 2                                                                               

                                      G    07/10 1183522  18892         2028.43-  2.47      5,019.21-                          5,019.21-1.00000000      5,019.21-                                                                               

                                      PROPERTY: 7239    WELL: 7239 DETERDING 7                                                                               

                                      G    07/10 1183523  25050          730.25-  2.47      1,806.94-                          1,806.94-1.00000000      1,806.94-                                                                               

                                      PROPERTY: 7426    WELL: 7426 PERRY ANDERSON 10                                                                               

                                      G    07/10 1183530  25228          382.24-  2.47        945.83-                            945.83-1.00000000        945.83-                                                                               

                                      PURCHASER TOTAL      G               0.00   0.00          0.01-                              0.01-                    0.01-                                                                               

                                      PURCHASER: 98365 PLAINS MARKETING LP                                                                               

                                      PROPERTY: 1770    WELL: 1770 MCCORMICK M 6 1U                                                                               

                                      O    07/10 1183547  19360            1.68- 61.05        102.56-ST             0.00         102.56-1.00000000        102.56-        

                                                                                                     OTH            0.00                                                                               

                                      DEHY           0.00                                                                               

                                      TRN            0.00                                                                               

                                      GMKT           0.00                                                                               

                                      PROPERTY: 1771    WELL: 1771 EMIGH 12 3U                                                                               

                                      O    07/10 1183556  18768            0.31- 61.77         19.15-ST             0.00          19.15-1.00000000         19.15-        

                                                                                                     OTH            0.00                                                                               

                                      DEHY           0.00                                                                               

                                      TRN            0.00                                                                               

                                      GMKT           0.00                                                 

                                      /code

                                       

                                      ...and

                                       

                                             SALE  GSL      DIV                                                     COMPT           NET                    AMOUNT         

                                      PROD  DATE  NO.     ORDER        QUANTITY  PRICE        GROSS  CPT          AMOUNT         AMOUNT   RECV INT         RCVD   QUAL                                                                               

                                      PROPERTY: 8982    WELL: 8982 RVS 26                                                                               

                                      G    07/10 1183165  27346          885.00   4.30      3,805.30 ADV            0.00       3,805.30 1.00000000      3,805.30 0.974   

                                                                                                     CP             0.00                                                                               

                                      GATH           0.00                                                                               

                                      BATCH: 83954    07312010 CA                   CK#: 07312010 DATE: 08/15/10     AMT:  0.00                                                                               

                                      PURCHASER: 91704 CALPINE ENERGY SERVICES LP                                                                               

                                      PROPERTY: 9015    WELL: 9015 JORDAN 9                                                                               

                                      G    07/10 1183202  29873         7398.00   4.63     34,252.05 ADV            0.00      33,209.59 1.00000000     34,252.05 1.049   

                                                                                                     CP         1,042.46                                                                               

                                      GATH           0.00                                                                               

                                      PROPERTY: 9043    WELL: 9043 WILCOX 19                                                                               

                                      G    07/10 1183219  27321       152573.00   4.70    716,625.08 ADV            0.00     714,051.66 1.00000000    716,625.08 1.064   

                                                                                                     CP         2,573.42                                                                               

                                      GATH           0.00                                                                               

                                      PROPERTY: 9083    WELL: 9083 RVS 28                                                                               

                                      G    07/10 1183179  30091         3241.00   4.73     15,318.53 ADV            0.00      14,613.10 1.00000000     15,318.53 1.071   

                                                                                                     CP           705.43                                                                               

                                      GATH           0.00                                                                               

                                      PROPERTY: 9284    WELL: 9284 RVS 027ST1                                                                               

                                      G    07/10 1183212  28069        14015.00   4.32     60,534.51 ADV            0.00      59,544.86 1.00000000     60,534.51 0.979   

                                                                                                     CP           989.65                                                                               

                                      GATH           0.00                                                                               

                                      PROPERTY: 9348    WELL: 9348 TWITCHELL 9                                                                               

                                      G    07/10 1183207  28998        10270.00   4.68     48,090.53 ADV            0.00      46,133.40 1.00000000     48,090.53 1.061   

                                                                                                     CP         1,957.13                                                                               

                                      GATH           0.00                                                                               

                                      PROPERTY: 9845    WELL: 9845 JORDAN 8L                                                                               

                                      G    07/10 1183211  29872        13728.00   4.68     64,218.86 ADV            0.00      61,670.13 1.00000000     64,218.86 1.060   

                                                                                                     CP         2,548.73                                                                               

                                      GATH           0.00                                                                               

                                      PURCHASER TOTAL      G         1107396.56   4.62  5,111,999.97 CP       151,262.42   4,959,253.17             4,894,976.84         

                                                                                                     COMP       1,484.38                                                                               

                                      BATCH TOTAL          G         1107396.56   4.62  5,111,999.97 CP       151,262.42   4,959,253.17             4,894,976.84         

                                                                                                     COMP       1,484.38                                                 

                                      /code

                                        • Need help!
                                          warlok

                                          Did you ever find a solution to your issue, out of curiosity?

                                            • Need help!
                                              Olly Bond

                                              Hello Su-San,

                                               

                                              PURCHASER: 98365 PLAINS MARKETING LP                                                                               

                                              PROPERTY: 1770    WELL: 1770 MCCORMICK M 6 1U                                                                               

                                              O    07/10 1183547  19360            1.68- 61.05        102.56-ST             0.00         102.56-1.00000000        102.56-        

                                                                                                             OTH            0.00                                                                               

                                              DEHY           0.00                                                                               

                                              TRN            0.00                                                                               

                                              GMKT           0.00                                                  /CODE

                                               

                                              For this fragment of data, do you want five records in your table, or one record with the ST, OTH, DEHY, TRN, GMKT... categories as columns?

                                               

                                              Best wishes,

                                               

                                              Olly

                                                • Need help!
                                                  su-san _

                                                  Hello Su-San,

                                                   

                                                  PURCHASER: 98365 PLAINS MARKETING LP                                                                               

                                                  PROPERTY: 1770    WELL: 1770 MCCORMICK M 6 1U                                                                               

                                                  O    07/10 1183547  19360            1.68- 61.05        102.56-ST             0.00         102.56-1.00000000        102.56-        

                                                                                                                 OTH            0.00                                                                               

                                                  DEHY           0.00                                                                               

                                                  TRN            0.00                                                                               

                                                  GMKT           0.00                                                  /CODE

                                                   

                                                  For this fragment of data, do you want five records in your table, or one record with the ST, OTH, DEHY, TRN, GMKT... categories as columns?

                                                   

                                                  Best wishes,

                                                   

                                                  Olly[/QUOTE]

                                                   

                                                  Anyway to where the numbers match the subtotals and grand totals. Thanks for asking.

                                                    • Need help!
                                                      Bill Watson

                                                      Ok I had a play about with this in some downtime and here is what I came up with

                                                       

                                                      Note in the templates below all the numeric fields start one character to the right of the last decimal place so as to pick up the signage (-).

                                                       

                                                      Templates:

                                                       

                                                      Detail:

                                                         Trap Lines = 1 

                                                         Trap = Ãß  (Alpha then Blank)

                                                         Sample Line =

                                                      G 07/10 1183165 27346 885.00 4.30 3,805.30 ADV 0.00 3,805.30 1.00000000 3,805.30 0.974  /code

                                                       

                                                      Fields =

                                                      Name            Type       Data Length Display Length       Decimals  Alignment Formula

                                                       

                                                      PROD            Characte              1              5                Left

                                                      SALE_DATE       Characte              5             10                Left

                                                      GSL_NO          Characte              7              7                Left

                                                      DIV_ORDER       Characte              5             10                Left

                                                      QUANTITY        Numeric              18             16              2 Right

                                                      PRICE           Numeric              18              7              2 Right

                                                      GROSS           Numeric              18             14              2 Right

                                                      CPT_ALL         Memo                 20             73                Left      Note This field is set to run on till "End of Left Justification"

                                                      NET_AMOUNT      Numeric              18             15              2 Right

                                                      RECV_INT        Numeric              18             11              8 Right

                                                      AMOUNT_RCVD     Numeric              18             14              2 Right

                                                      QUAL            Numeric              18              5              3 Right

                                                      /code

                                                       

                                                       

                                                      Append 1:

                                                         Trap Lines = 1

                                                         Trap = PROPERTY 

                                                         Sample Line =

                                                      PROPERTY: 3999 WELL: 3999 DROUIN 8  /code

                                                       

                                                      Fields =

                                                      Name            Type       Data Length Display Length       Decimals  Alignment Formula

                                                       

                                                      PROPERTY        Characte              4              9                Left

                                                      WELL            Characte             35             30                Left

                                                      /code

                                                       

                                                       

                                                      Append 2:

                                                         Trap Lines =  1

                                                         Trap = PURCHASER: 

                                                         Sample Line =

                                                      PURCHASER: 91704 CALPINE ENERGY SERVICES LP  /code

                                                       

                                                      Fields =

                                                      Name            Type       Data Length Display Length       Decimals  Alignment Formula

                                                       

                                                      PURCHASER       Characte              5             10                Left

                                                      PURCHASER_NAME  Characte             35             26                Left

                                                      /code

                                                       

                                                       

                                                      Append 3:

                                                         Trap Lines = 1

                                                         Trap = BATCH: 

                                                         Sample Line =

                                                      BATCH: 83964 07/10 RV Deep Pseudo Unit CK#: 0710 CP DATE: 08/23/10 AMT: 0.00  /code

                                                       

                                                      Fields =

                                                      Name            Type       Data Length Display Length       Decimals  Alignment Formula

                                                       

                                                      BATCH           Characte              5              6                Left

                                                      BATCH_DESC      Characte             29             29                Left

                                                      CK_NO           Characte              8              8                Left

                                                      BATCH_DATE      Characte              8             11                Left

                                                      BATCH_AMT       Numeric              18             18              2 Right

                                                      /code

                                                       

                                                       

                                                      Footer 4:

                                                         Trap Lines = 1

                                                         Trap = PURCHASERß  (PURCHASER then Blank)

                                                         Sample Line =

                                                      PURCHASER TOTAL G 1107396.56 4.62 5,111,999.97 CP 151,262.42 4,959,253.17 4,894,976.84  /code

                                                       

                                                      Fields =

                                                      Name            Type       Data Length Display Length       Decimals  Alignment Formula

                                                       

                                                      PURCH_PROD      Characte              1             12                Left

                                                      PURCH_QUANTITY  Numeric              18             16              2 Right

                                                      PURCH_PRICE     Numeric              18             12              2 Right

                                                      PURCH_GROSS     Numeric              18             13              2 Right

                                                      PURCH_CPT_ALL   Memo                 20             32                Left      Note This field is set to run on till "End of Left Justification"

                                                      PURCH_NET_AMT   Numeric              18             15              2 Right

                                                      PURCH_AMT_RCVD  Numeric              18             16              2 Right

                                                      /code

                                                       

                                                       

                                                      Footer 5:

                                                         Trap Lines = 1

                                                         Trap = BATCHß (BATCH then BLANK)

                                                         Sample Line =

                                                      BATCH TOTAL G 1107396.56 4.62 5,111,999.97 CP 151,262.42 4,959,253.17 4,894,976.84  /code

                                                       

                                                      Fields =

                                                      Name            Type       Data Length Display Length       Decimals  Alignment Formula

                                                       

                                                      BATCH_PROD      Characte              1             12                Left

                                                      BATCH_QUANTITY  Numeric              18             16              2 Right

                                                      BATCH_PRICE     Numeric              18             12              2 Right

                                                      BATCH_GROSS     Numeric              18             13              2 Right

                                                      BATCH_CPT_ALL   Memo                 20             32                Left      Note This field is set to run on till "End of Left Justification"

                                                      BATCH_NET_AMT   Numeric              18             15              2 Right

                                                      BATCH_AMT_RCVD  Numeric              18             16              2 Right

                                                      /code

                                                       

                                                      Note the CPT_ALL, PURCH_CPT_ALL and BATCH_CPT_ALL fields above currently contain any component records for each detail record. These can be split into seperate columns for further calculations using the TEXTLINE() function.

                                                       

                                                      In order to output something usable here on the forums I added the following calculated fields to remove commas from the CPT_ALL, PURCH_CPT_ALL and BATCH_CPT_ALL.

                                                      These can be skipped if the intention is to view in Excel.

                                                       

                                                      Fields =

                                                      Name            Type       Data Length Display Length       Decimals  Alignment Formula

                                                       

                                                      CPT_CLEAN       Memo                 10             73                Left      replacE(CPT_ALL,',','')

                                                      PURCH_CPT_CLEAN Memo                 10             31                Left      replacE(,',','')

                                                      BATCH_CPT_CLEAN Memo                 10             31                Left      replacE(,',','')

                                                      /code

                                                       

                                                       

                                                      This gives the following output

                                                       

                                                      BATCH,BATCH_DESC,CK_NO,BATCH_DATE,BATCH_AMT,PURCHASER,PURCHASER_NAME,PROPERTY,WELL,PROD,SALE_DATE,GSL_NO,DIV_ORDER,QUANTITY,PRICE,GROSS,CPT_CLEAN,NET_AMOUNT,RECV_INT,AMOUNT_RCVD,QUAL,PURCH_PROD,PURCH_QUANTITY,PURCH_PRICE,PURCH_GROSS,PURCH_CPT_CLEAN,PURCH_NET_AMT,PURCH_AMT_RCVD,BATCH_PROD,BATCH_QUANTITY,BATCH_PRICE,BATCH_GROSS,BATCH_CPT_CLEAN,BATCH_NET_AMT,BATCH_AMT_RCVD

                                                      83964,07/10 RV Deep Pseudo Unit,0710 CP,08/23/10,0,91704,CALPINE ENERGY SERVICES LP,3999,3999 DROUIN 8,G,07/10,1183540,18752,-101.45,2.47,-251.03,,-251.03,1,-251.03,,G,0,0,-0.01,,-0.01,-0.01,G,1107396.56,4.62,5111999.97,CP       151262.42 COMP       1484.38,4959253.17,4894976.84

                                                      83964,07/10 RV Deep Pseudo Unit,0710 CP,08/23/10,0,91704,CALPINE ENERGY SERVICES LP,4093,4093 DROUIN 13 1,G,07/10,1183531,18747,-325.82,2.47,-806.22,,-806.22,1,-806.22,,G,0,0,-0.01,,-0.01,-0.01,G,1107396.56,4.62,5111999.97,CP       151262.42 COMP       1484.38,4959253.17,4894976.84

                                                      83964,07/10 RV Deep Pseudo Unit,0710 CP,08/23/10,0,91704,CALPINE ENERGY SERVICES LP,5371,5371 DROUIN 15,G,07/10,1183524,18750,-548.22,2.47,-1356.54,,-1356.54,1,-1356.54,,G,0,0,-0.01,,-0.01,-0.01,G,1107396.56,4.62,5111999.97,CP       151262.42 COMP       1484.38,4959253.17,4894976.84

                                                      83964,07/10 RV Deep Pseudo Unit,0710 CP,08/23/10,0,91704,CALPINE ENERGY SERVICES LP,5902,5902 RIO VISTA DEEP PSEUDO UNIT,G,07/10,1183563,18745,8305.15,2.47,20550.51,,20550.51,1,20550.51,,G,0,0,-0.01,,-0.01,-0.01,G,1107396.56,4.62,5111999.97,CP       151262.42 COMP       1484.38,4959253.17,4894976.84

                                                      83964,07/10 RV Deep Pseudo Unit,0710 CP,08/23/10,0,91704,CALPINE ENERGY SERVICES LP,6070,6070 DETERDING 2,G,07/10,1183522,18892,-2028.43,2.47,-5019.21,,-5019.21,1,-5019.21,,G,0,0,-0.01,,-0.01,-0.01,G,1107396.56,4.62,5111999.97,CP       151262.42 COMP       1484.38,4959253.17,4894976.84

                                                      83964,07/10 RV Deep Pseudo Unit,0710 CP,08/23/10,0,91704,CALPINE ENERGY SERVICES LP,7239,7239 DETERDING 7,G,07/10,1183523,25050,-730.25,2.47,-1806.94,,-1806.94,1,-1806.94,,G,0,0,-0.01,,-0.01,-0.01,G,1107396.56,4.62,5111999.97,CP       151262.42 COMP       1484.38,4959253.17,4894976.84

                                                      83964,07/10 RV Deep Pseudo Unit,0710 CP,08/23/10,0,91704,CALPINE ENERGY SERVICES LP,7426,7426 PERRY ANDERSON 10,G,07/10,1183530,25228,-382.24,2.47,-945.83,,-945.83,1,-945.83,,G,0,0,-0.01,,-0.01,-0.01,G,1107396.56,4.62,5111999.97,CP       151262.42 COMP       1484.38,4959253.17,4894976.84

                                                      83964,07/10 RV Deep Pseudo Unit,0710 CP,08/23/10,0,98365,PLAINS MARKETING LP,1770,1770 MCCORMICK M 6 1U,O,07/10,1183547,19360,-1.68,61.05,-102.56,ST             0.00 OTH            0.00 DEHY           0.00 TRN            0.00 GMKT           0.00,-102.56,1,-102.56,,G,0,0,-0.01,,-0.01,-0.01,G,1107396.56,4.62,5111999.97,CP       151262.42 COMP       1484.38,4959253.17,4894976.84

                                                      83964,07/10 RV Deep Pseudo Unit,0710 CP,08/23/10,0,98365,PLAINS MARKETING LP,1771,1771 EMIGH 12 3U,O,07/10,1183556,18768,-0.31,61.77,-19.15,ST             0.00 OTH            0.00 DEHY           0.00 TRN            0.00 GMKT           0.00,-19.15,1,-19.15,,G,0,0,-0.01,,-0.01,-0.01,G,1107396.56,4.62,5111999.97,CP       151262.42 COMP       1484.38,4959253.17,4894976.84

                                                      83964,07/10 RV Deep Pseudo Unit,0710 CP,08/23/10,0,98365,PLAINS MARKETING LP,8982,8982 RVS 26,G,07/10,1183165,27346,885,4.3,3805.3,ADV            0.00 CP             0.00 GATH           0.00,3805.3,1,3805.3,0.974,G,0,0,-0.01,,-0.01,-0.01,G,1107396.56,4.62,5111999.97,CP       151262.42 COMP       1484.38,4959253.17,4894976.84

                                                      83954,07312010 CA,07312010,08/15/10,0,91704,CALPINE ENERGY SERVICES LP,9015,9015 JORDAN 9,G,07/10,1183202,29873,7398,4.63,34252.05,ADV            0.00 CP         1042.46 GATH           0.00,33209.59,1,34252.05,1.049,G,1107396.56,4.62,5111999.97,CP       151262.42 COMP       1484.38,4959253.17,4894976.84,G,1107396.56,4.62,5111999.97,CP       151262.42 COMP       1484.38,4959253.17,4894976.84

                                                      83954,07312010 CA,07312010,08/15/10,0,91704,CALPINE ENERGY SERVICES LP,9043,9043 WILCOX 19,G,07/10,1183219,27321,152573,4.7,716625.08,ADV            0.00 CP         2573.42 GATH           0.00,714051.66,1,716625.08,1.064,G,1107396.56,4.62,5111999.97,CP       151262.42 COMP       1484.38,4959253.17,4894976.84,G,1107396.56,4.62,5111999.97,CP       151262.42 COMP       1484.38,4959253.17,4894976.84

                                                      83954,07312010 CA,07312010,08/15/10,0,91704,CALPINE ENERGY SERVICES LP,9083,9083 RVS 28,G,07/10,1183179,30091,3241,4.73,15318.53,ADV            0.00 CP           705.43 GATH           0.00,14613.1,1,15318.53,1.071,G,1107396.56,4.62,5111999.97,CP       151262.42 COMP       1484.38,4959253.17,4894976.84,G,1107396.56,4.62,5111999.97,CP       151262.42 COMP       1484.38,4959253.17,4894976.84

                                                      83954,07312010 CA,07312010,08/15/10,0,91704,CALPINE ENERGY SERVICES LP,9284,9284 RVS 027ST1,G,07/10,1183212,28069,14015,4.32,60534.51,ADV            0.00 CP           989.65 GATH           0.00,59544.86,1,60534.51,0.979,G,1107396.56,4.62,5111999.97,CP       151262.42 COMP       1484.38,4959253.17,4894976.84,G,1107396.56,4.62,5111999.97,CP       151262.42 COMP       1484.38,4959253.17,4894976.84

                                                      83954,07312010 CA,07312010,08/15/10,0,91704,CALPINE ENERGY SERVICES LP,9348,9348 TWITCHELL 9,G,07/10,1183207,28998,10270,4.68,48090.53,ADV            0.00 CP         1957.13 GATH           0.00,46133.4,1,48090.53,1.061,G,1107396.56,4.62,5111999.97,CP       151262.42 COMP       1484.38,4959253.17,4894976.84,G,1107396.56,4.62,5111999.97,CP       151262.42 COMP       1484.38,4959253.17,4894976.84

                                                      83954,07312010 CA,07312010,08/15/10,0,91704,CALPINE ENERGY SERVICES LP,9845,9845 JORDAN 8L,G,07/10,1183211,29872,13728,4.68,64218.86,ADV            0.00 CP         2548.73 GATH           0.00,61670.13,1,64218.86,1.06,G,1107396.56,4.62,5111999.97,CP       151262.42 COMP       1484.38,4959253.17,4894976.84,G,1107396.56,4.62,5111999.97,CP       151262.42 COMP       1484.38,4959253.17,4894976.84

                                                      /code

                                                       

                                                      I wasn't sure what summaries you needed but this should get you on the right track I hope.

                                                        • Need help!
                                                          su-san _

                                                          Bill, thank you for taking time on this. I will try it out this afternoon and get back to you. -Thanks again!

                                                            • Need help!
                                                              su-san _

                                                              Thanks Bill! Seemed to work great.

                                                                • Need help!
                                                                  Bill Watson

                                                                  Glad to help. Good to hear you were able to use it.

                                                                   

                                                                  When you are just getting started with Monarch, the flexibility which is monarchs strength can also be a stumbling block - knowing which set of data to use as your details/headers/appends etc can take a bit of trial and error at first. But the way I see it every report is a challenge which teaches something that can be used in the future.

                                                        • Need help!
                                                          su-san _

                                                          Did you ever find a solution to your issue, out of curiosity?[/QUOTE]

                                                           

                                                          Thanks for the ^bump. No I have not, but looks like this topic is hot again.