May 6, 2011 at 9:19 am
I'm attempting to build a report showing each 'grade' (i.e. freshman, sophomore, junior, senior) in rows with the GPA and hours of each semester (fall, spring, summer) in columns.
The problem occurring is that rows where data is not present for a student cause that row to be absent in the report. The same applies in a matrix for semesters/columns.
For example, a sophomore would have no junior of senior hours or GPA, but the client would like to see the junior and senior rows with [either a dash or a zero] in the cell.
As well, if a student takes no summer classes, the summer semester column does not show up in the matrix. The output should show the Summer header column with a zero or dash in each cell.
Thanks in advance.
May 6, 2011 at 9:26 am
You might want to use outer joins between semester, grade and students table.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply