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 |