I need to create a course report with the following fields: Student Full Name, Activities, Grade (for each activity), Final Grade and Course Short Name.
The default report in course grades allows to export all this information except Course Short Name (only in the file name). I also configured a custom report with custom SQL. This contains all the fields that I need except Final Grade. Anyway, it is shown in a way that isn't the most suitable for me, because it creates a new row for each activity (I prefer this to be displayed in the table header).
Thanks! I hope you can help me.