Questions related to the Traps

Manan Nisar

I have 1 unstructured report with a lot of details. I have attached one sample of the report with the discussion post. So whenever I create the trap to get all the details depending on the "Amount" Column. My requirements are that I want just the "Total:  and Amount" or the field rows for the Customer with the word Total in it and definitely the Amount associated with the customer. When I place the trap, the first 2 customers who does not have the total section should be blank on the table but it does happen that the First 2 rows of customers in the table view gets filled with "107.54" instead of being blank. How to setup a trap and how to rectify it with specific values. IS there a way to do some conditional formatting that whenever the system see total: with the amount, it should take up the amount and display it for that specific customers. Thank you for your help in advance. Really appreciate it!

 

 

Brianne Freeman

You could trap the total as a Group Footer, and then use a clearing template so the total populates only the one time, and not for each row. Hope this helps:
https://help.altair.com/2021/monarch/help/desktop/Clearing_Template.htm?rhsearch=clearing template&rhsyns=

CPorthouse

I would agree with @Brianne Freeman suggestion.  I don't want to assume the entire report layout based on the example, but you could add an append template possibly based on trapping the customer name and then clear your group footer by that append template.  Append templates are typically positioned above a detail, but they can occur on the same line as a detail template as well.  You would need that additional append template because if you use the detail template as the clearing template, the total would only apply to the first detail the group footer came across.