SqlReports

sqlReports is a free customization with a premium option that allows you to create sql-based reports and/or charts in the admin portal. As a reporting tool you can create reports that do not exist in PS and make them interactive by asking admins for input. As an export tool you can build simple or complex reports and users can save the information in comma or tab format. No need to use DDE, quick export, or report templates - admins can run reports you create and export the results on the screen or filter the results before exporting. You can also build student based reports that have a 'Make Current Selection' button to easily use the results of the report as the current selection.

• https://sqlreports.net/ - sqlReports Website

sqlExports and sql Exports Lite

sqlExports is a powerful way to get your data out of PowerSchool. With it you can export almost any data you need out of PS and export from tables you see in DDE and tables you don't see in DDE, such as health, incidents, extended tables, and more. You can query the database first before doing an export and either do a one-time export or schedule it to run hourly, daily, or weekly. There are also a wide range of output methods - the export can be just to the report queue, it can be saved to a local or network drive on your PS server, it can be FTP'd to a server, or included in an email.

sqlExports Lite is a free and more limited version of the full sqlExports.

• https://sqlreports.net/downloads/sqlexports - sqlExports Lite link

SQL Topics

• Avuhsd sql.zip - Resources from the SQL presentation at the January 20, 2012 Meeting at Antelope Valley UHSD in Palmdale.
• Using Oracle SQL Developer.pdf - Using Oracle SQL Developer - presentation by Matt Freund
• Basic SQL.pdf - Basic SQL Presentation by Dean Dahlvang at PSUG Las Vegas

sqlReports Examples

These can be "imported" by unzipping the download, opening the text file and pasting the contents into the "import" feature in sqlReports. These reports may need modification to work on your server and are shared "as is".

• AP Class Sizes - Written to report on class sizes for 2nd semester. It helps the AP test coordinator with ordering the tests. The "WHERE" clause should be easily modifiable to suit your environment. Assumes:
  • That all AP course names start with "AP...."
  • That the semester 2 termid ends in "02"
• Course Roster - Provides a roster of students, course number and term, based on user supplied Course Number. It should work "as is".
• Health Immunizations-All Active Students - All immunization records for all active students
• Health Immunizations-by Grade Level - Immunization records for active students based on grade-level selected.
• Health Immunizations-Measles Records for All Active Students - Shows Measles record for All Active Students
• Health Immunizations-TDAP Records All Active Students by Grade-Level - TDAP records for all active students by grade level selected.
• Health Immunizations-TDAP Missing - Returns a list of students for the current school whose Health screen does not have a TDAP date recorded.
• Schedule Gaps and Double Bookings - Reports students who are double booked for a period or who have a non-scheduled period. You must choose a date when class is in session. (i.e. - picking a Saturday won't work). Designed for a 1 day 8 period schedule.
• No SSO Accounts - Lists and makes current selection students who do not have an SSO account. This means parents have not signed up. The report is limited to students who have "AllowWebAccess" checked for a parent.
• Parent Email Finder for SSO - Enter all or part of a guardian email address to find where that email address exists in Parent SSO accounts. It could be the main account address or additional notifications the guardian has setup. The report searches both areas.