SqlReports - Revision history

Rsprik: /* sqlReports Examples */

2023-08-23T19:04:32Z

‎sqlReports Examples

Rsprik: /* sqlReports Examples */

2023-05-11T22:46:09Z

‎sqlReports Examples

Rsprik: /* sqlReports Examples */

2022-10-22T19:08:57Z

‎sqlReports Examples

Rsprik: /* sqlReports Examples */

2022-10-22T19:08:36Z

‎sqlReports Examples

Rsprik at 17:36, 24 July 2021

2021-07-24T17:36:33Z

Rsprik at 17:35, 24 July 2021

2021-07-24T17:35:55Z

Rsprik: /* sqlExports and sql Exports Lite */

2021-07-24T17:35:28Z

‎sqlExports and sql Exports Lite

Rsprik at 17:32, 24 July 2021

2021-07-24T17:32:08Z

Rsprik: /* sqlReports Examples */

2021-05-17T17:18:55Z

‎sqlReports Examples

Rsprik: /* sqlReports Examples */

2021-05-17T17:13:43Z

‎sqlReports Examples

@@ Line 22: / Line 22: @@
 * [[Media:SqlReportClassRankAudit.zip|Class Rank Audit]] - Lists all schools in district and their Class Rank recalculation frequency setting and the latest date for which Class Rank was recalculated.
 * [[Media:SqlReport CourseRoster.txt.zip|Course Roster]] - Provides a roster of students, course number and term, based on user supplied Course Number. It should work "as is".
 * [[Media:SqlReport ImmunizationRecordAllActiveStudents.txt.zip|Health Immunizations-All Active Students]] - All immunization records for all active students
 * [[Media:SqlReport ImmunizationRecordByGradeLevel.txt.zip|Health Immunizations-by Grade Level]] - Immunization records for active students based on grade-level selected.

@@ Line 45: / Line 45: @@
 * [[Media:Student email missing.txt.zip|Student Email Missing]] - Lists students from the grade levels specified by the user who do not have an email entered in the stock student email field.
 * [[Media:StudentRequestTally.txt.zip|Student Request Tally]] - A near clone of the built-in "Student Request Tally" found in PowerScheduler, but with filters and the ability to make the filtered results the current student selection. For example, filter to students with 0 requests and make them the current selection.
 * [[Media:SqlReport mastersched gradecount.txt.zip|Master Schedule with Grade Counts]] - Reports master schedule data for the current term(s), with class size, but also broken down by grade level. Useful for finding teachers who have just seniors, or juniors, etc. If you set a grade level to "No", it will NOT include any sections that have any students in that grade level.
 **For example, to find sections with ONLY seniors, set 9th, 10th and 11th to "No" and Seniors to "Yes".

@@ Line 49: / Line 49: @@
 * [[Media:DemeritCount sqlReport.zip|Demerit Count]] - Reports active students in the current school and their demerit count based on the adoption of discipline_incidenttype field in log table as demerit field. You can modify query to suit your implementation of demerits.
 * [[Media:YeartoYearEnrollmentComparison.zip|Year to Year Enrollment Comparison]] - Lets the user select two years to compare. Lists all enrollments from year 1 and then if they are enrolled or not in year 2.
-**[[Media:SSO_Global_ID_Missing_Mismatched_sqlReport.txt.zip|sqlReport to find missing or mismatched Global IDs]] - Related to SSO via OIDC through Azure or Google. Unzip this file then open the txt contents and copy/paste in sqlReports setup to import this report that can help you keep your Global IDs up-to-date.
+*[[Media:SSO_Global_ID_Missing_Mismatched_sqlReport.txt.zip|sqlReport to find missing or mismatched Global IDs]] - Related to SSO via OIDC through Azure or Google. Unzip this file then open the txt contents and copy/paste in sqlReports setup to import this report that can help you keep your Global IDs up-to-date.
 [[Category: Contents]]

@@ Line 49: / Line 49: @@
 * [[Media:DemeritCount sqlReport.zip|Demerit Count]] - Reports active students in the current school and their demerit count based on the adoption of discipline_incidenttype field in log table as demerit field. You can modify query to suit your implementation of demerits.
 * [[Media:YeartoYearEnrollmentComparison.zip|Year to Year Enrollment Comparison]] - Lets the user select two years to compare. Lists all enrollments from year 1 and then if they are enrolled or not in year 2.
 [[Category: Contents]]

← Older revision		Revision as of 17:36, 24 July 2021
Line 1:		Line 1:
−	sqlReports is a free customization ~~with a premium option~~ that allows you to create sql-based reports and/or charts in the admin portal. As a reporting tool you can create reports that do not exist in PS and make them interactive by asking admins for input. As an export tool you can build simple or complex reports and users can save the information in comma or tab format. No need to use DDE, quick export, or report templates - admins can run reports you create and export the results on the screen or filter the results before exporting. You can also build student based reports that have a 'Make Current Selection' button to easily use the results of the report as the current selection.	+	sqlReports is a free (Classic version) or paid (Premium version) customization that allows you to create sql-based reports and/or charts in the admin portal. As a reporting tool you can create reports that do not exist in PS and make them interactive by asking admins for input. As an export tool you can build simple or complex reports and users can save the information in comma or tab format. No need to use DDE, quick export, or report templates - admins can run reports you create and export the results on the screen or filter the results before exporting. You can also build student based reports that have a 'Make Current Selection' button to easily use the results of the report as the current selection.

	* https://freundresources.net/ - sqlReports Website. Requires subsription (free or paid)		* https://freundresources.net/ - sqlReports Website. Requires subsription (free or paid)

@@ Line 1: / Line 1: @@
 sqlReports is a free customization with a premium option that allows you to create sql-based reports and/or charts in the admin portal. As a reporting tool you can create reports that do not exist in PS and make them interactive by asking admins for input. As an export tool you can build simple or complex reports and users can save the information in comma or tab format. No need to use DDE, quick export, or report templates - admins can run reports you create and export the results on the screen or filter the results before exporting. You can also build student based reports that have a 'Make Current Selection' button to easily use the results of the report as the current selection.
-* https://freundresources.net/ - sqlReports Website
+* https://freundresources.net/ - sqlReports Website. Requires subsription (free or paid)
 ==sqlExports==

@@ Line 3: / Line 3: @@
 * https://freundresources.net/ - sqlReports Website
-==sqlExports and sql Exports Lite==
+==sqlExports==
 sqlExports is a powerful way to get your data out of PowerSchool. With it you can export almost any data you need out of PS and export from tables you see in DDE and tables you don't see in DDE, such as health, incidents, extended tables, and more. You can query the database first before doing an export and either do a one-time export or schedule it to run hourly, daily, or weekly. There are also a wide range of output methods - the export can be just to the report queue, it can be saved to a local or network drive on your PS server, it can be FTP'd to a server, or included in an email.
-sqlExports Lite is a free and more limited version of the full sqlExports.
+* https://freundresources.net/ - requires subscription (free or paid)
 ==SQL Topics==

@@ Line 21: / Line 21: @@
 **That all AP course names start with "AP...."
 **That the semester 2 termid ends in "02"
-* [[Media:CategoryPoints-sqlReports.zip|Category Points]] - Lists all the PTP categories and how many points in each one. User can optionally specify a date rang.
+* [[Media:CategoryPoints-sqlReports.zip|Category Points]] - Lists all the PTP categories and how many points in each one. User can optionally specify a date range.
 * [[Media:SqlReportClassRankAudit.zip|Class Rank Audit]] - Lists all schools in district and their Class Rank recalculation frequency setting and the latest date for which Class Rank was recalculated.
 * [[Media:SqlReport CourseRoster.txt.zip|Course Roster]] - Provides a roster of students, course number and term, based on user supplied Course Number. It should work "as is".