[C#] how do I make a date wise attendance crystal report?

See more:

C#

CrystalReports

Hi guys. How do I make an attendance crystal report that would look like this:

Name | Degree | Year | 03/21 | 03/22 | ...
Jefferson Samson BSIT 4 P P
Rime Enriquez BSIT 4 A P


Thanks and more power. XD

What I have tried:

SQL Pivoting but it only shows the date that I have added in the report. XD