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.

Show what you have done so far, even if it's wrong.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.