Crystal - Format with Multiple Columns
I've tried so many ways to make this work. I'm creating a 'Courses with Grades' Crystal report
(v11.5) using 'Format with Multiple Columns', but I can't align the columns. There are large gaps in between each column because the 'course' is repeated between the grade columns (but hidden). I want the 3 grades more right justified and the course name (column) left justified. I've adjusted the column widths many ways.
Also, the data is being ordered numerically. That's not the order that the grades were earned.
Course Name Semester 1 Semester 2
Final
Language Arts 88 91
93
Math 92 94
96
Science 96 97
98
I tried creating formulas for the grades, in order to get them in the correct chronological order earned, but the grades are staggered in 3 different rows.
Course Name Sem 1 Sem 2
Final
Language Arts 89
Language Arts 91
Language Arts 93
Many thanks, I appreciate your suggestions.