1 Reply Latest reply: May 15, 2014 9:58 AM by Mike Urbonas RSS

    Trapping Rows with Different Spacing

    Jason _

      I need help trapping a sub-total when there are a different number of rows from each title.  The file looks like this:

       

      There are several different sections with varying distances between value in each section.

      [font="courier"]1S Purchases

        Direct Purchases

       

        ARA Div Purchases

       

              Sub-total

       

      1S Purchases

        Fiduciary Contribution

       

        Asset Transfer

       

        NSCC

       

              Sub-total

       

      1S Direct Payment

       

              Sub-total[/font][/quote]

       

      [size="1"][ June 09, 2003, 02:26 PM: Message edited by: Mike Urbonas ][/size]

        • Trapping Rows with Different Spacing
          Mike Urbonas

          You can trap your data (Direct Purchases, etc.) using a Detail template, then trap the Sub-totals separately using a Footer template. 

           

          You could also choose not to trap the Sub-total lines from your report at all, and instead let Monarch recalculate them for you in the Summary window.

           

          Mike

           

          [size="1"][ June 09, 2003, 02:31 PM: Message edited by: Mike Urbonas ][/size]