CODEWITHSUNDEEP
c#.netsql-server-2005crystal-reports
sqlchild
sqlchild

Reputation: 9084

crystal report showing duplicate records

i have a student table , i want to show the Student Name as a heading , and then his/her details in a whole row, but the report is showing every student record twice. how to do this? i have added the Student Name and all the columns in the Detail Section.

These are the columns from the Student table:

StudentName | Class| section| Course| DOB

I want that the display is like this:

----------------------Student1 Name ---this would be the heading

Class| section| Course| DOB**

----------------------Student 2 Name ---this would be the heading

Class| section| Course| DOB**

----------------------Student 3 Name ---this would be the heading

Class| section| Course| DOB**

Upvotes: 0

Views: 2603

Answers (1)

Philippe Grondier
Philippe Grondier

Reputation: 11148

You should use the "group by" option (Menu Insert\Group), choose studentName field as group by field. Delete the studentName field from your detail\header lines, and it will then appear as requested

Upvotes: 2

Related Questions