Counting rows in rtf template
I'm developing an RTF template which will have two groupings - BUSINESS_UNIT and then ACTION_REASON within that.
I need to get a count of each possible value of ACTION_REASON for each business unit, including for those that don't have any rows, because I need to be able to display "no records found" for each ACTION_REASON value not present for that business unit.
Can this be done within the RTF template? I can think of other ways to do it outside of the template, but I'd prefer to do it there if I can.