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
Featured Replies
  • 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 … Read More

  • [URL="http://www.codeproject.com/Articles/142064/Step-by-Step-Creation-of-Crystal-Report-using-its"]http://www.codeproject.com/Articles/142064/Step-by-Step-Creation-of-Crystal-Report-using-its[/URL] please check this out for use of groups. Read More

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.