Skip to Content
Former Member
Nov 21, 2016 at 09:15 PM

Suppress group on a second condition (duplicate last names in group)


I have a fairly simple report, that I need to complicate. The report currently shows employees that have duplicate bank acct numbers. Data is grouped by bank acct#, and I have this in the group-selection formula:


This checks for bank account groups that have more than a single entry.

Then I have this in the Group footer suppression:


And that suppresses the bank account group for those that have less than 2 entries.

Report uses 2 tables, employee and bank account. Just for background, generally these groups will be a couple that is using the same bank account - we are a school division so we have many married employees. So usually there will be a group header (bank acct# and the count of duplicates), and then the 2 detail rows (emp#, name, bank account). There are a few groups that have 3 rows (I guess 2 parents and a child).

So if there are 2 or more employees with the same bank account, they are printed.

THAT works.

Now the complication. User wants to suppress the group if the last name is the same. So say I have this...

12345 Jones Adam 1122334455
54321 Jones Mary 1122334455

Bank acct 1122334455 2

32156 Smith John 998877
5462 White Sara 998877

Bank acct 998877 2

So I would want to suppress the first group - the Jones - due to the duplicate name.

Racking my brain here but I'm stumped. How do I suppress the group for a duplicate name within the group?
Appreciate your help!!