2 Replies Latest reply: May 15, 2014 9:56 AM by Grant Perkins RSS

    Append Trap without Detail

    alexcn _

      I have a correctly working template bringing in subtotals before and after the detail records as append/footer traps respectively.  However some pages have no detail records but I still want the append values to be returned.

       

      Since there is no detail record association, Monarch is simply skipping the link.

       

      Does anyone have any ideas how to resolve this?

       

      Many thanks,

       

      Alex

        • Append Trap without Detail
          Data Kruncher

          Hi Alex,

           

          This sort of situation is often resolved by creating a Page Headers template, with the appropriate trap set, but don't define any fields in the template.

           

          Does this help with your report?

           

          Kruncher

          • Append Trap without Detail
            Grant Perkins

            Hi Alex,

             

            Having a detail record returned, even if it is trapped but empty, is the basis of Monarch output.

             

            As far as I can imagine you have two options.

             

            1. Have the detail template trap something in the records without detail even though the result will be blank fields. To be able to do this would be unusual in my experience.

             

            2. Find a way to may the key fields from the append (or possibly footer but that is less likely) part of the detail record.

             

            A third alternative would be to create a model that extracts and exports the required 'Append' records without concern for any other data.

             

            A second process woudl extract the detail as you have it defined.

             

            You then runs a third process, using the first extraction as the base file and the 'detailed' second extraction as a lookup table, to generate the file you really need. It will have all of the records and some extra detail for thos records for which it was available.

             

            It's not as complex as it probably sounds if you use scripts and batch files.

             

            HTH.

             

            Grant