my report show this way:

surname 1 firstname1 middlename1
surname 1 firstname1 middlename1
surname 1 firstname1 middlename1
surname 1 firstname1 middlename1
surname 1 firstname1 middlename1
surname 2 firstname2 middlename2
surname 2 firstname2 middlename2


i want to display my those records this way

surname 1 firstname1 middlename1
surname 2 firstname2 middlename2

since the 5 surname 1 firstname1 middlename1 have different values in other columns (and so as the surname 2 firstname2 middlename2)... in my crystal report I want to display only the surname, firstname, and middlename...

how can I display the records the way I want?
any help is appreciated... thanks :)

surname 1 firstname1 middlename1
surname 1 firstname1 middlename1
surname 1 firstname1 middlename1
surname 1 firstname1 middlename1
surname 1 firstname1 middlename1
all these fields having same data ?

same surname firstname middlename but have different data in other columns...

ok but you want to show just surname middlename and firstname in your report , if yes , then please group on surname middlename and firstname .then in your report only one record will show . and if you are using query and generating your report programmetically then use group by clause in your query .

Regards

This question has already been answered. Start a new discussion instead.