Articles

Customizing PowerSchool

If you're new to customizing PowerSchool, the following should help you get started and make it easier for you to load customizations from this site:

  Customizing PS 101 - basic information on customizing as well as helpful hints and tips
  Using Custom Page Manager (CPM) - basic instructions for working with customizations using the Custom Page Manager.
  Using Custom Web Root - basic instructions for working with customizations using the custom web root area of the server.
  Using Plugins - an overview of plugins and the basics of using them



SQL Related

The following articles should help you become more familiar with SQL (Structured Query Language).  SQL is used extensively with sqlReports and becoming familiar with it will help you create reports or understand and be able to edit other's reports.  These articles are unique in that they use PowerSchool as a reference, which should make it easier to understand and relate to compared to generic SQL sites that are online.

  Basic SQL - if you're not familiar with SQL or just want a refresher on the basics, start here. 
  Intermediate SQL - once you know the basics, move on to some more powerful commands.
  Advanced SQL - how to use pivot tables and create derived tables with joins or withs.
  PS Custom Fields and SQL - this article covers how to access data in custom fields using either the custom field api approach or database extensions.
  Useful Joins on PS Tables - common joins to pull data from various PS tables

 

Basic How To's for sqlReports

The following articles cover basic how-to's for sqlReports and most of the information is also in the user guide.

  Change Grading Terms in Pivot Reports - a guide on how to change from quarters to trimesters or add semesters
  Create Drop-Down Menus - a guide on how to create your own drop-down menus
  Fix Double sqlReports Tabs - this should help if you have two sqlReports tabs show up
  Import a sqlReports Report - be sure to read this if you're new to sqlReports or have never imported a report from this site
  Make sqlReports Available to Teachers - be sure to read this before using sqlReports - Teachers
  Use the Current Selection in a sqlReports Report - how to use the current selection of students in a report
  Use Various Commands in the Report Header - information on various commands available and when to use them



sqlReports Tips and Tricks

The following articles have some tips and tricks for sqlReports, plus they can come in handy for troubleshooting.

  Basic sqlReports Troubleshooting - tips on things to try if you're getting a blank report
  Basic Troubleshooting - General Use - troubleshooting non-report issues
  Changing Colors on the Output Page of sqlReports - how to change the colors of various rows
  Dates and Times in sqlReports - date formatting in sql is tricky when it comes to sqlReports and this should help
  Handy SQL for Teacher Reports in sqlReports - sql to use for class rosters or teacher specific reports
  It Works in Developer but not sqlReports - the main reasons why sql works in a client but not in sqlReports
  Miscellaneous Tips and Tricks for sqlReports - various other tips and tricks, such as system variables (curschoolid, etc.) and district vs school coding
  Using HTML Coding in sqlReports - how to add links and images, change colors, add progress bars, and center data