I have duplicate names in my report so to get rid of them, i grouped by Name, and then put a formula that looks like that in the details
if not isnull({people.ssn}) then
1
else
0
then in the group footer i sum up the formula and in group selection formula i put this
Count ({@SSN}, {@Group}) = 1
Now this gets rids of all the duplicates and the report looks great, but it also gets rid of all the customers that had duplicates. But i need one copy of it to show on the report. Is it somehow possible for the Group Selection to Select only those groups where the Sum of the formula was Less then 2?
Count ({@SSN}, {@Group}) < 2
doesnt seem to work?
Hope this makes sense, thanks!
if not isnull({people.ssn}) then
1
else
0
then in the group footer i sum up the formula and in group selection formula i put this
Count ({@SSN}, {@Group}) = 1
Now this gets rids of all the duplicates and the report looks great, but it also gets rid of all the customers that had duplicates. But i need one copy of it to show on the report. Is it somehow possible for the Group Selection to Select only those groups where the Sum of the formula was Less then 2?
Count ({@SSN}, {@Group}) < 2
doesnt seem to work?
Hope this makes sense, thanks!