About sqlReports.net

(FYI - links in the paragraphs below are to external sites and will open in new windows.  Most of the links are to archived copies of former web sites via the Wayback Machine at web.archive.org.)

• In 2005, PowerSchool was a small company owned by Apple and the main product was called PowerSchool Pro.  Apple was contacting education agencies across the USA to help train new customers of PowerSchool.  In the spring of 2005, the education service center where Matt worked sent him to the PowerSchool headquarters in Folsom, California, to become a certified initial product trainer.
• In the summer of 2005, Matt started training new users of PowerSchool onsite and also started offering workshops on PowerSchool at the education service center.  He also taught various sessions on PowerSchool at the state user conference, something which expanded over the years to presenting at other state, regional, and national conferences.   
• Matt started a web site to host the reports and customizations he covered in his trainings and workshops.  At the time, PowerSchool Pro used a non-SQL database from 4D and customizations were done via the custom web root and the only way to build reports that pulled information from multiple tables was to use the built-in reporting engine.  Matt's web site became well-known for the various customizations and reporting engine reports on it, mainly because he was an active participant on PSUG at Yahoo Groups and shared his site and it's content with the user group.
• In 2005, Apple released PowerSchool Premier, which was based on the Sybase SQL database.  In 2006, Apple sold PowerSchool to Pearson Education, and in 2008, Pearson released an Oracle SQL database version of PowerSchool Premier.  The move to the SQL databases brought about big changes in customizations with the introduction of the tlist_sql code for use with PowerSchool pages.  
• In 2008, Matt started his own company and moved his web site to sisresources.com and added a section on SQL.  Matt recreated his reporting engine reports as SQL-based custom pages and added new customizations to the site.  Some of the custom pages Matt created became part of the original Custom Reports Bundle and the popular Enhanced Parent Portal customization.   
• In 2009, the sqlReports customization was created and released by Dean Dahlvang.  Matt added a section on how to use sqlReports to the sisresources.com web site and created sqlReports versions of his custom pages and reporting engine reports.
• In 2013, the school district Dean worked at switched from PowerSchool to another SIS.  Dean and Matt had become friends over the years and Dean emailed Matt a copy of a new version of sqlReports that he was working on that used DataTables, as well as a reporting engine add-on that would export the results of a report.  Bob McGregor, another friend of Dean and Matt, helped update the files from Dean and sqlReports 4 was released in the fall of 2013 via the sqlReports4.com web site.  In 2014, the reporting engine add-on was released as sqlExports. 
• In 2014, Matt was training users on sqlReports at a summer conference and showing them how to import reports from the sqlReports4.com site.  Several attendees mentioned the idea of adding more reports to the site and having a paid subscription to access them.  On the flight home from the conference, Matt drew up plans for a sqlReports site subscription and started selling it later that year. 
• sqlReports 4 was enhanced over the years and the 4 was dropped.  Due to the name change, content was moved from sqlReports4.com to other domains over the years, including sisresources.com, sqlReports.net, and FreundResources.net.  The full version history of sqlReports can be found by clicking here (you must be logged in to view the page).
• In 2021, Matt started the sqlReports User Group. 
• In the fall of 2026, sqlReports and the site subscription were moved back to sqlReports.net.