I have a stored procedure which is able to generate a pivoted DataTable that results in
|
Stud-ID
|
NAME
|
ASSEMENT
|
ENGLISH
|
MATHS
|
OVERALL TOTAL
|
|
1
|
STUDENT-1
|
TEST
|
20
|
12
|
92
|
|
1
|
STUDENT-1
|
EXAM
|
40
|
20
|
92
|
|
1
|
STUDENT-1
|
TOTAL
|
60
|
32
|
92
|
|
2
|
STUDENT-2
|
TEST
|
30
|
25
|
150
|
|
2
|
STUDENT-2
|
EXAM
|
50
|
45
|
150
|
|
2
|
STUDENT-2
|
TOTAL
|
80
|
70
|
150
|
|
3
|
STUDENT-3
|
TEST
|
15
|
14
|
143
|
|
3
|
STUDENT-3
|
EXAM
|
50
|
64
|
143
|
|
3
|
STUDENT-3
|
TOTAL
|
65
|
78
|
143
|
I am able to export to Excel and manipulate the sheet to give me
|
Stud-ID
|
NAME
|
ASSEMENT
|
ENGLISH
|
MATHS
|
OVERALL TOTAL
|
|
1
|
STUDENT-1
|
TEST
|
20
|
12
|
92
|
|
EXAM
|
40
|
20
|
|
TOTAL
|
60
|
32
|
|
2
|
STUDENT-2
|
TEST
|
30
|
25
|
150
|
|
EXAM
|
50
|
45
|
|
TOTAL
|
80
|
70
|
|
3
|
STUDENT-3
|
TEST
|
15
|
14
|
143
|
|
EXAM
|
50
|
64
|
|
TOTAL
|
65
|
78
|
I need my data presented in this manner
|
Stud-ID
|
NAME
|
ENGLISH
|
MATHS
|
OVERALL TOTAL
|
|
|
|
TEST
|
EXAM
|
TOTAL
|
TEST
|
EXAM
|
TOTAL
|
|
|
1
|
STUDENT-1
|
20
|
40
|
60
|
12
|
20
|
32
|
92
|
|
2
|
STUDENT-2
|
30
|
50
|
80
|
25
|
45
|
70
|
150
|
|
3
|
STUDENT-3
|
15
|
50
|
65
|
14
|
64
|
78
|
143
|
ANY IDEA AS TO HOW TO PIVOT MY DATA TO ACHIEVE THE LAST TABLE?
- Maybe in Excel
- Or using any UI Tool (possibly free
I AM USING ASP.NET WEBFORMS
