Cross-Tab Grade book

[GeorgeCrane]

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...

[HighAley]

Hello.

We need to see structure of your data.
Please, send us your report template with sample data.
Also, we would like to see screenshots of your report with remarks about things that you need to change.

Thank you.

[GeorgeCrane]

Here you go
- a sample report with data
- 2 screenshots, one of what I got and one with the view I wish to achieve

[Alex K.]

Hello,

We need some additional time for check the issue.

Thank you.