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**
------开发者_StackOverflow社区----------------Student 3 Name ---this would be the heading
Class| section| Course| DOB**
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
精彩评论