0

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

2
Contributors
5
Replies
10
Views
5 Years
Discussion Span
Last Post by gerchi152
0

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 ?

0

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

1

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.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.