The following can be viewed by anyone with an account.  If you do not have an account, you can apply for a free account via the Account Application page under the Login menu.

  How to Import a sqlReports Report - how to import a report from this site, or a text file, into sqlReports
  sqlReports v. 11 FAQ - frequently asked questions regarding sqlReports v. 11
  Basic Reports Troubleshooting - tips on things to try if you're getting a blank report
  Basic Troubleshooting - sqlReports v. 11 and HTML - tips on things to try if you're getting a partial report
  Basic Troubleshooting - Cross-Site Scripting Errors - information regarding the error
  Basic Troubleshooting - Importing Reports - cross-site errors when importing or blank imports
  sqlReports Version History - a history of changes dating all the way back to the original version

The following are available to those with an active sqlReports Subscription:

sqlReports Troubleshooting

  Basic Troubleshooting - General Use - troubleshooting some general things with sqlReports
  Basic Troubleshooting - 50,000 Rows Max in sqlReports - information regarding a change as of SIS v. 12.0.4
  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
  Using sqlReports in the Teacher Portal - explains how to set up sqlReports reports to work in the teacher portal


Basic How To's for sqlReports

  Create Drop-Down Menus - a guide on how to create your own drop-down menus
  How sqlReports Lists Work - information on how it works, plus important information regarding how it's use of prefs can affect users of the List Students or List Staff group functions
  Miscellaneous Tips and Tricks for sqlReports - various tips and tricks, such as system variables (curschoolid, etc.) and district vs school coding
  Use Saved Params Data in a Report - how to use the data from the Saved Params add-on in a report
  Use the Current Selection in a sqlReports Report - how to use the current selection of students in a report
  Using Code Set Menus in sqlReports - how to use the code set menus in sqlReports
  Using HTML Coding in sqlReports - how to add links and images, change colors, add progress bars, and center data


Learning and Using SQL

  SIS 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
   
  Common ORA Errors and What They Mean - what certain Oracle errors mean and how to fix them
  Use Custom Fields in SQL - how to add either legacy or extended custom fields to your SQL
  Useful Joins on SIS Tables - when to use studentid vs studentdcid and other useful joins
  Useful SQL for Teacher Reports in sqlReports - SQL to use for class rosters or teacher specific reports


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 DataTables Coding on Custom Pages - how to make custom pages with HTML tables act like sqlReports

 

 

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