No prob.
Here is what we are doing if it helps.
Creating a group on the name so we can get unique numbers per person.
Then we are going to count all of the rows that appear under the that name...
Count(numberfield,name)
Place it in group footer1 to see the value and make sure it works
Then we want to see the sum of the number value in each row for each person
SUM(numberfield,name)
You can also place this on the group footer to make it works.
Next we want to use this information in a logical way to see who only has the value of 1 on every row.
Logically, since every row must have a value of 1 or more, the only way a person can have a 1 on every row is for the SUM of the value to be the same as the count of the rows (1:1). As soon as a value is more than 1 on any row your SUM will always be more than your COUNT.
In Crystal you can use the select expert group select criteria to select groups of data based on these types of summary values.
So we can use or logic to only select rows where the two summarized values match...
SUM(numberfield,name field)=Count(numberfield, name field)
If for some reason a row can have a zero or NULL value in the number field we need to tweak this to make it work which is easy but I hope this makes the concept of the logic clearer.
Edited by DBlank - 14 Sep 2010 at 6:58am
IP Logged
