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

Resources from the SQL presentation at the January 20, 2012 Meeting at Antelope Valley UHSD in Palmdale.