duplicated name plz help 1

[fsreport]

Hello All
cr 9.0
ms sql
i have a report and it shows duplicated name contact
group on

here is my formula

fsreport

 

[synapsevampire]

Uuuh, might wanna check your posts...

So group on the ID of the contact, and place the names in the group footer and suppress the details.

-k

 

[fsreport]

Hi All
sorry for not completing my post the computer crash before i sent it
i have there group on my report

here is the case.
in my contact field i have someting like this
gr1 uu_ref (wholesaler)
gr2 schend (endate date)
gr3 schref (reference)
gr4 schunque(activity unique key)
group4 has these field in it
{Wholesaler},{Endate},{Contact_Name},
detail a formula @contact
note: there are 1 to many names could be assing to 1 activity.
***************************
heres my formula
@contact
if previous({CALSCHED.SCHUNQUE}) = {CALSCHED.SCHUNQUE} then
{CONTACT.C_NAME}+","+chr(13)+previous({CONTACT.C_NAME})
else
{CONTACT.C_NAME}
**********************************
in the common tab of the formula under suppress x2 i have this
isnull({CONTACT.C_NAME}) or {CONTACT.C_NAME} = ""

and check suppress if duplicated.

in my table under the contact name for each activity
look like this
some activity has 1 name assign and some multiple
exf my formula return value in the detail section
each line represent 1 string in my contact field table
Bruce/Frank Moskowitz/Voli Collie/llynch,
Bruce/Frank Moskowitz/Voli
David Jensen,
Collie/llynch
David/Craig Elias/Mayfield,
David Jensen
David/Leigh Elias/Lewis,
David/Mem Elias/Weeb Jr,
David/Leigh Elias/Lewis
David/Paul Elias/Zukerman,
David/Mem Elias/Webb Jr

note the ',' from my formula where it place it
i need to supress duplicated name
is there a way to do this.
I ask the if i could remove the / from the contact table
the replied was no this is how they enter the contact name whos assigned for each activity involve in it

Please help to resolve this issue

thanks



fsreport

 

[lbass]

How would you want the above sample records to display?

-LB

 

[fsreport]

hi
thanks for the replied.
i want it to display like above but no duplicated name
if the string has same name supress duplicated
David/Leigh Elias/Lewis,
David/Leigh Elias/Lewis
David Jensen,
David Jensen
are duplicating and one has a , and the other none
base from my formula
{CONTACT.C_NAME}+","+chr(13)+previous({CONTACT.C_NAME})




thanks



fsreport

 

[lbass]

Please show exactly how you would like your earlier example to display--since I don't see any duplication of entire lines.

-LB