SqlReports

sqlReports is a free customization 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"