crystal report single display

[gerchi152]

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 :)

[M.Waqas Aslam]

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 ?

[gerchi152]

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

[M.Waqas Aslam]

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

[M.Waqas Aslam]

http://www.codeproject.com/Articles/142064/Step-by-Step-Creation-of-Crystal-Report-using-its please check this out for use of groups.

[gerchi152]

thanks so much, waqasaslammmeo... :)