1,309
edits
Changes
→sqlReports Examples
==sqlReports Examples==
These can be "imported" by unzipping the download, opening the text file and pasting the contents into the "import" feature in sqlReports. These reports may need modification to work on your server and are shared "as is".
* [[Media:SqlReport APClassSizes.txt.zip|AP Class Sizes]] - Written to report on class sizes for 2nd semester. It helps the AP test coordinator with ordering the tests. The "WHERE" clause should be easily modifiable to suit your environment. Assumes:
**That all AP course names start with "AP...."
**That the semester 2 termid ends in "02"
[[Category: Contents]]
