How do I use SQL to make a custom report?

Super Administrators only

To create or edit a report through the "Write SQL statement" interface:

The options for “All districts”, “All schools” and “All teachers” will only be available if the “student” table is present in your SQL statement.

  1. Navigate to the “Reporting” menu.
  2. Under “Custom”, click the “Write SQL statement” link to create a new report, or click on the “Edit SQL” link next to the report you want to edit.
  3. You can change the “Report name” or the wording of the SQL statement (knowledge of SQL is required).
  4. Optional settings can be chosen to provide access (to this report) to specific groups of administrative users. To allow all teachers to view this custom report from their “Reports” menu, put a check in the checkbox next to “All teachers”.

Be sure to click on the “Save” button when you are finished making changes.

reports_sql_custom_report.txt · Last modified: 2021/03/03 11:36 by
CC Attribution-Noncommercial 4.0 International Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0