database report - do not repeat fields

database report - do not repeat fields

by Jon Scherbatskoy -
Number of replies: 0

we have using Moodle 2.5 on a hosted site, so we do not have reall access to the backend for php changes. Is there a way to create a SQL report so I get the "course full name” once each time it changes, then the "user first name” "user last name” once each time it changes, etc? I have looked at "templates" but can;t figure it out.

 EXAMPLE:

201405_NR510_nursing

                                             Jon S

                                                            Assign#1 - grade

                                                            Assign#2 - grade

                                             Tom P

                                                            Assign#1 - grade

201405_NR520_next_nursing


thank you

Jon Scherbatskoy - Instructional Developer

Norwich University, Northfield, VT

802-485-2392 - scherbaj@norwich.edu

Average of ratings: -