(The documention related to installation and user guides for various products is now under the Downloads menu.)

The following can be viewed without an account:

How to Import a sqlReports Report - how to import a report from this site, or a text file, into sqlReports

Basic sqlReports Troubleshooting - tips on things to try if you're getting a blank report


The following can only be viewed by those with an active site subscription account:

sqlReports Troubleshooting

  Basic Troubleshooting - General Use - troubleshooting some general things with sqlReports
  Basic Troubleshooting - Cross-Site Scripting Errors - information regarding a change in PS as of PS 11.0.4
  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

  Create Drop-Down Menus - a guide on how to create your own drop-down menus
  Make sqlReports Available to Teachers - be sure to read this before using sqlReports - Teachers
  Handy SQL for Teacher Reports in sqlReports - SQL to use for class rosters or teacher specific reports
  Miscellaneous Tips and Tricks for sqlReports - various 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
  Using Code Set Menus - how to use the code set menus
  Using HTML Coding in sqlReports - how to add links and images, change colors, add progress bars, and center data


Learning and Using SQL

  PS Database Vocabulary - common terms with regards to the database
  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
   
  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


Customization Related

  Using Custom Page Manager (PS 12.1+) - basic instructions for Custom Page Manager (CPM)
  Using Custom Page Manager (Pre PS 12.1) - basic instructions for Custom Page Manager (CPM)
   
  Adding Dynamic Elements to Pages - system variables, if statement, gpv commands, and drop-down menus
  How to Use SQL with Custom Pages - how to use tlist_sql in a custom page or in a json file
  Adding Single Series Charts to Pages - how to add a simple chart using the FusionCharts files that come with PS
  Using DataTables Coding on Custom Pages - how to make custom pages with HTML tables act like sqlReports

 

 

© 2013 - present, All Rights Reserved - Matt Freund and Freund Resources