I need to make report there in crystal report there in crystal report. Let me make it clear to you. Listen I have a table called result ok? When user creates result for Tom it saves data in the table like that -
ID - Name - Subject - Oral mark - Written mark - Total mark
1 - Tom - English - 20 - 40 - 60
However after doing that table gets one row right? When user creates another result for another subject[for the same student] then it saves data in the table like that -
1 - Tom - Computer - 30 - 40 - 70
As a result table gets another row for it. So tables look like -
ID - Name - Subject - Oral mark - Written mark - Total mark
1 - Tom - English - 20 - 40 - 60
1 - Tom - Computer - 30 - 40 - 70
If user creates another result it will look like -
ID - Name - Subject - Oral mark - Written mark - Total mark
1 - Tom - English - 20 - 40 - 60
1 - Tom - Computer - 30 - 40 - 70
1 - Tom - Math - 25 - 55 - 80
Now if we normally create report it will be something like that
ID - Name - Subject - Oral mark - Written mark - Total mark
1 - Tom - English - 20 - 40 - 60
1 - Tom - Computer - 30 - 40 - 70
1 - Tom - Math - 25 - 55 - 80
That means though ID & Name is same it will show it again & again there in report [1 1 1 Tom Tom Tom]. I need to make a report where report will show ID & name for once & subjects will be perfect like that -
ID - 1 Name - Tom
Subject - Oral mark - Written mark - Total mark
English - 20 - 40 - 60
Computer - 30 - 40 - 70
Math - 25 - 55 - 80
Is it clear now? When user will save results for different subjects it will get same ID & Name again & again there in every row but it will not show it again & again when it will show report. Thats all I want to do. I have tried by grouping ID & Name but its not working because it shows ID & Name again & again there in report. Now would you please tell me how should I solve this problem? Please explain it to me properly or provide me tutorial because I am just a beginner.