This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
reports_sql_custom_report [2017/02/03 07:58]
reports_sql_custom_report [2017/02/03 07:58] (current)
Line 1: Line 1:
 +====== How do I use SQL to make a custom report? ======
 +<wrap em>Super Administrators only</​wrap>​
 +===== To create or edit a report through the "Write SQL statement"​ interface: =====
 +<WRAP right round tip 40%>
 +The options for "All districts",​ "All schools"​ and "All teachers"​ will only be available if the "​student"​ table is present in your SQL statement.
 +  - Navigate to the "​Reporting"​ menu.
 +  - 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.
 +  - You can change the "​Report name" or the wording of the SQL statement (knowledge of SQL is required).
 +  - 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"​.
 +<WRAP center round info 60%>
 +Be sure to click on the "​Save"​ button when you are finished making changes.
 +<WRAP right round box 48%>
 +{{ :​custom_report_sql.jpg?​nolink |}}
reports_sql_custom_report.txt · Last modified: 2017/02/03 07:58 (external edit)
CC Attribution-Noncommercial 4.0 International
www.chimeric.de Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0