I have a simple main report that returns customer contact detail info with a count of those customer contacts. The report is grouped by “Mailing Type” of which there are 5 for this particular process. After each group, I have a sub report returning contact detail but this time for prospects associated to the same mailing type, thus resulting in 2 different counts of contacts for each mailing type, one for customer and one for prospect contacts.
I want to create a “running total” that will show the total number of contacts for each mailing type
So, if there are 10 customer contacts and 2 for prospects associated to type 1, I want to show 10 at the end of the customer group, then 12 at the end of the prospect sub reprort, then accumulate the next set of customer contacts and then the next set of prospect contacts thru to completion, all the while having the total grow, not reset.
I’ve setup shared variable for totalcustomercontact and prospectcontact counts, but these variables seem to reset in each group as opposed to accumulate, so I’m certainly doing something wrong.
Seems like a common need that I’m just run across for the first time, so I would appreciate any assistance.