Cross-Tab Grade book
Posted: Wed Feb 10, 2016 1:11 pm
What I'm trying to get done;
So I have to make a grade book that contains a list of students in one column, the grades for each class in their own columns and absence for the whole semester in one last column.
My simplified data structure
I got 3 relational data sources
- student with studentid and student name
- grades with studentid, grade, and subject name
- absence with studentid and hours missed
Where I am
I'm able to get students and the grades into a crosstab, but I am unable to find a good solution to get a last column in that shows the absence.
Anyone know how I could get this to work? Right now I'll either place two Cross-Tabs reeeealy close together or hack the model so absence becomes a grade...
So I have to make a grade book that contains a list of students in one column, the grades for each class in their own columns and absence for the whole semester in one last column.
My simplified data structure
I got 3 relational data sources
- student with studentid and student name
- grades with studentid, grade, and subject name
- absence with studentid and hours missed
Where I am
I'm able to get students and the grades into a crosstab, but I am unable to find a good solution to get a last column in that shows the absence.
Anyone know how I could get this to work? Right now I'll either place two Cross-Tabs reeeealy close together or hack the model so absence becomes a grade...