I have a fairly simple report, that I need to complicate. [IMG]smileys/smiley5.gif" align="middle" />   It's for our payroll department, and she wants to show duplicate ACH accounts, for employees. She's checking for data entry errors.

Report uses 2 tables, employee and bank account, and I'm printing rows for any bank account that has at least 2 employees with that same account. (This is normally a couple that is using the same bank account - we are a school division so lots of married employees.) So usually there will be a group header (bank acct# and the count of duplicates), and 2 detail rows (emp#, name, bank account). There are a few groups that have 3 rows (I guess 2 parents and a child).

I have this in the group selection formula: Count ({EMACHDEPST.EBNK_ACCT_NBR}, {EMACHDEPST.EBNK_ACCT_NBR}) > 1

And honestly - I don't even know why/ that^^ works, but it does. (If anyone wants to explain that to me, please feel free! Yes I wrote the report but I can't remember how I came up with that!)

I then have this in the "suppress drill down" formula, in the Group Header:
If Count({EMACHDEPST.EBNK_ACCT_NBR}) < 2 then TRUE

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? And if there are 3 records, and one is different...I might need to
also look at the home address and suppress on that as well.
Appreciate your help!!


Edited by wanttoknowmore - 21 Nov 2016 at 3:42am

look at your grouping and start using comparatives of counts vs. distinct counts at that group level until you get all criteria you want.
I am not entirely following all the criteria so here is an example of one possible criteria...

Count(lastname,EMACHDEPST.EBNK_ACCT_NBR) <> DISTINCTCOUNT(lastname,EMACHDEPST.EBNK_ACCT_NBR)

Edited by DBlank - 21 Nov 2016 at 3:08am

so if the count of the last name in that group = distinct count of last names in that group all of the people in that group have a unique last name. if not, at least two people share a name. Use that logic for the show/suppress

Edited by DBlank - 22 Nov 2016 at 2:40am

You can completely exclude groups using the group select or you can suppress sections using it.
I don't know what your preference is nor where you are currently using the condition of
Count ({EMACHDEPST.EBNK_ACCT_NBR}, {EMACHDEPST.EBNK_ACCT_NBR}) > 1

You would keep your existing condition and append the rest to it with an "AND ..."

Still hoping for some guidance here. I have removed the stuff that I had added to get back to a working report. I'm hoping that if I present a clearer picture of what I have, someone can help. (FWIW, our Crystal report "guru" here is also stumped by this!!















[IMG">http://i297.photobucket.com/albums/mm235/chesapeakemom/Crystal/crystalGFsuppress_zpsmi21qo84.jpg" />


So those are all the "pieces" I have in the report, right now. And for just printing the employees that have the same accounts, it works. I've not been able to figure out how to suppress the groups where the last names match. I only want to print a group, if the last names are different.










Edited by wanttoknowmore - 23 Nov 2016 at 6:16am