Issue in consolidation data in crystal report

Last Reply one month ago By dharmendr

Posted 2 months ago

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

Required Output
1st Term Exam 2nd Term Exam Final Term Exam
Sr. No Subject Obtain Total Subject Obtain Total Subject Obtain Total
1 Urdu 15 25 Urdu 25 50 Urdu 15 25
2 English 18 25 English 38 50 English 18 25
3 Math 19 25 Math 29 50 Math 19 25
Marks: _______ Grade: _________ Marks: ___ Grade: _____ Marks: ___ Grade: ___

You are viewing reply posted by: dharmendr one month ago.
Posted one month ago

Hi smile,

You need to use sql pivot query to get the result.

Then use the result to display in crystal report.

Refer below link. 

https://www.codeproject.com/Questions/579926/howplustoplusdisplayplusdataplusonpluscrystalplusr

Or you may try wioth Cross Tab Report. Refer below link.

https://www.c-sharpcorner.com/UploadFile/ansh06031982/create-cross-tab-report-using-report-using-rdlc-and-crystal/