Articles


Articles with a  greencheck are available for free.  All others require a site subscription to view.

sqlReports Troubleshooting

 greencheck Basic sqlReports Troubleshooting - tips on things to try if you're getting a blank report
 greencheck Basic Troubleshooting - Cross-Site Scripting Errors - information regarding a change in PS as of PS 11.0.4
  Basic Troubleshooting - General Use - troubleshooting some general things with sqlReports
  Basic Troubleshooting - 50,000 Rows Max in sqlReports - information regarding a change in PS as of PS 12.0.4
  Common ORA Errors and What They Mean - what certain Oracle errors mean and how to fix them
  Dates and Times in sqlReports - date formatting in SQL is tricky when it comes to sqlReports and this should help
  It Works in Developer but not sqlReports - the main reasons why SQL works in a client but not in sqlReports


Basic How To's for sqlReports

  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
 greencheck Import a sqlReports Report - be sure to read this if you're new to sqlReports or have never imported a report from this site
 greencheck Make sqlReports Available to Teachers - be sure to read this before using sqlReports - Teachers
  Miscellaneous Tips and Tricks for sqlReports - various other tips and tricks, such as system variables (curschoolid, etc.) and district vs school coding
  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
  Using HTML Coding in sqlReports - how to add links and images, change colors, add progress bars, and center data


Learning and Using SQL

 greencheck 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
   
  Handy SQL for Teacher Reports in sqlReports - sql to use for class rosters or teacher specific reports
  Use PS Custom Fields in SQL - how to add either legacy or extended PS custom fields to your SQL
  Useful Joins on PS Tables - when to use studentid vs studentdcid and other useful joins


Oracle SQL Developer

  Getting Started and Running Queries - how to setup Oracle SQL Developer and run a query 
  Tables and Views - how to view the Tables and Views that are part of the database
  Tips and Tricks - some tips and tricks regarding joins, query builder, autocomplete, and preferences

Terms of Use

By downloading any files or reports from this site, you agree to this site's Terms Of Use.