Since 2009, sqlReports has allowed admins to easily create custom reports that use SQL to get the data for the report, hence the name sqlReports. A free version is available, as well as a premium version that's part of the Freund Resources Site Subscription.
Below is an example of the output of a report created in sqlReports, followed by a breakdown of the various parts of sqlReports and the differences between the free version and the subscription version:
sqlReports Home Page
The sqlReports Home Page acts as a central location for your reports. It's easy to create new reports, edit reports, and import reports. Links are created automatically on the home page for your reports, and reports can be grouped together or appear without a group reference.
The SQL Behind the Report
The power of sqlReports is the ability to create reports based on Structured Query Language (SQL). Below is an example of the SQL query from a report setup (this is from the report that created the output above):
The is based on regular SQL, however, system variables such as ~(curschoolid) or user variables created by the report writer, can also be included.
Running the Report
Once the report is created, users visit the sqlReports home page and click on a link to the report. If there are any parameters created by the report writer, users will be prompted to enter that information. In the example below, the user is prompted to choose a grading term, choose whether or not to use the current selection of students, and is given a place to enter grades to use in the report. Parameters make the reports powerful and flexible - users can choose different parameters each time they run the report.
Once the user clicks on the Submit button, the report will run based on the SQL query and a page will come up displaying the results:
The user has the option to copy, export, or print the data. The subscription version of sqlReports allows users to filter results by column, and includes a button to click to make any students on the screen the current selection.
Advantages to Using sqlReports
- Powerful Report Builder - it's a powerful tool for those who wish to build their own reports because they find the built-in reports or custom reports from others lacking or too rigid
- Ease-of-Use - there's only one plugin to install (a 2nd plugin must be installed if using the teacher portal version), it's easy to import existing reports, and it's easy to assign reports to specific user groups
- Saves Time - one can create reports that replace everyday tasks, either for oneself or for others. For example, instead of searching DDE for the same information on a regular basis, one can create a report that retrieves the data and can be run by any user.
- Popularity - the customization has been available since 2009 and used by hundreds of users. The large user base makes it easy to get help and there's a good chance someone may already have a report you need or can provide you with the SQL necessary to create a report.
Free Edition vs Subscription Edition
The table below shows the main differences between the free version and the subscription version:
| sqlReports - Free Edition | sqlReports |
|
| Pricing | Free | Part of the Site Subscription |
| Create, Import, Edit Reports | Yes | Yes |
| User Parameters | Up to 3 | Up to 8 |
| Make Current Selection Options | No | Yes |
| Assign Reports to Specific Groups (Run Access) | Yes | Yes |
| Header / Footer Options | No | Yes |
| Results Page | Handful of Options (screenshot) | All Options |
| Other sqlReports Features | None | Saved Params version of sqlReports, Teacher Portal Version of sqlReports, sqlCharts |
Frequently Asked Questions
Once you're logged into the site you'll see a resources menu with a link to a downloads page. The free version of sqlReports is available for download for anyone who has an account on this site. The subscription version of sqlReports is only available for download for those with an active Freund Resources Site Subscription.
Yes - sqlReports will work on hosted or self-hosted servers.
No - the install only adds the sqlReports customization itself. You will need to create a new report or use the import feature to import one to add reports to sqlReports.
No - any report you created in an earlier version will show up automatically in newer versions of sqlReports. If for some reason you don't see all of the reports after an upgrade, consult the troubleshooting section of the installation guide for possible solutions.
Make sure you're running a version of sqlReports that is compatible with the version of SIS you're running (see the compatibility chart on the Knowledgebase page). The error can also happen on any version of sqlReports due to improper HTML anywhere in the sqlReports report.
No - that is an unauthorized version of sqlReports. The company that created it violated the terms of use by poaching and integrating a version of sqlReports into their customization without permission. It should be removed from your server and replaced with a version from this site. If you were told by the company that you should not uninstall it, you were misled by them because the reports for it will work fine with versions of sqlReports from this site.
sqlReports - it was released by Dean Dahlvang in March 2009. It wasn't until 6 1/2 years later (December 2015) that the SIS makers decided to add a built-in SQL reporting tool based on Oracle APEX and called it Enterprise Reporting. Even though that tool is available, sqlReports is preferred by many users, mainly due to sqlReports ease of use and popularity.