I have a student Attendance table which Stores Student Record only if Student is absent.
Now i wish this data to be displayed in a RDLC Report by automatically adding columns for all days of month and Status of All Students in a class.
Asked
Active
Viewed 721 times
0
-
You need to use `PIVOT`. There are lot of questions and answer about it. Just search and you will be able to find an answer for your problem. For example https://stackoverflow.com/questions/27422109/how-to-pivot-dynamically-with-date-as-column – AB_87 Oct 08 '17 at 07:02
-
You need to supply the data for each data of the month. This would be the only reasonable approach. Once you have source data - then you need to use Matrix Table. – InitK Oct 10 '17 at 14:34