| Often times, you need a report for your administrator | | | | are building for PowerSchool. |
| and there is not a report made in PowerSchool for | | | | Navicat also has the ability to create a pivot table |
| you to print. Of course, your boss needs the report in | | | | report. In a future article, I will describe the steps |
| 15 minutes so what can you do? A product named | | | | needed to create a grade distribution report using a |
| "Navicat" is made to be able to access your Oracle | | | | pivot table. In this report, I was able to exclude my |
| database and you can create a report quickly and | | | | homeroom/seminar course that principal did not want |
| easily without a lot of knowledge of SQL. | | | | included in the count. Please check my blog for |
| Navicat is reporting tool that allows you to create a | | | | postings of the grade distribution report. |
| connection to the PowerSchool Oracle database | | | | The use of third party tools to extend PS have been |
| which will allow you access to all of the PowerSchool | | | | in practice about as long as PS has existed. With the |
| tables in the PS schema. At that point you can go to | | | | development of ReportWorks, there is going to be a |
| the report module to build a report. Navicat also has an | | | | day that we will not need to use these tools, but it is |
| elaborate query tool that could be used to build queries | | | | not that way at this time. |
| that you could incorporate into a custom page that you | | | | |