Printing Student Name Labels

Re: Printing Student Name Labels

by Martin Greenaway -
Number of replies: 0

You could do this in a two step process - first by running the report to generate a spreadsheet, and then using that spreadsheet to do a mail-merge into the appropriate document template in Word, for example.

Your report to get *all* names would presumably only need to be something simple like the following, in the configurable reports plugin (other reports plugins are available!):

SELECT DISTINCT
  concat(firstname, ' ', lastname)
FROM
  prefix_user
WHERE 
  id > 2 AND deleted = 0 AND suspended = 0

(including the id > 2 restriction will exclude the admin and guest accounts, and the other two restrictions will exclude any deleted or suspended accounts)

Of course, if you're looking to restrict by course enrolment, group/cohort membership, face-to-face sign up or whatever, then that query would get a fair bit more complicated.  

In CR, you can select the type of export file you want, e.g. XLSX. Once you have the list of names you can easily use a mail merge to get that into the appropriate Word template.  If you're not familiar, there's a guide here.