Issue in consolidation data in crystal report

Hismile,

Will you please explain your issue in details?

i want to generate student result card in crystal report like that format

tblSetMarks Term       Exam      AdmissionNo   Subject   Obtain    Total T-1         1st         R-01   Urdu      15        25 T-1         1st         R-01   English   18    25 T-1         1st         R-01   Math      19     25 T-2         2nd        R-01   Urdu      25     50 T-2         2nd        R-01   English   38    50 T-2         2nd        R-01   Math       29   50 T-3         3rd         R-01   Urdu       15   25 T-3         3rd         R-01   English    18   25 T-3        3rd          R-01    Math      19   25

how to get the solution?

Please share valid screenshot.

i want the output in crystal report like the following format

First you need to get teh data from databas ein pivoted format.

Then design the Crystal Report according to the dataset column.

It is not possible to make sample at our end.