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
FinalLanguage Arts 88
93 Math 92
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
91Language Arts 93
Many thanks, I appreciate your suggestions.