I am using Object Reports to build a Verification of Enrollment form. They want me to place the current year and any previous years that the student has been enrolled in the district. I am not sure how to go about this. I tried making a Powerquery using the CC.Dateenrolled and CC.Dateexit fields, but I am unsure of how to make it work. I keep getting the same error message for insufficient permissions for the powerquery. Does anyone know how I can place all enrollment years on a form?
The CC table shows what course sections a student is enrolled in...I think you want the ReEnrollments table.
District Instructional Data Officer
Gateway Regional School District
Did your issue get solved? Please remember to give Kudos and/or select Accept As Solution on the helpful posts to thank the author and to help others find the solution.
So when I place the Reenrollments in the object report, like so: ^([Reenrollments]Entrydate), it returns 0/0/0. How would I make it so it returns all of the previous years?
@ansmith743 A student's current enrollment is in the Student's table and all previous enrollment data is in the Reenrollment table. I'm thinking you might be able to pull entry date and exit date from both tables, and use decoding of data to change it to school years.
PowerSchool Mentor of the Year 2021 Winner
PowerSchool Beta Tester of the Year 2022 Winner
So when I pull the current year from the students table it works just fine. But, when I try to pull from CC or Reenrollments it does not work. This is what it returns: 0/0/0. My thought was that it has to do with that it is returning multiple rows, maybe. Or, it is not connecting to the student id.
The previous enrollment information is stored in the Reenrollment table which is not accessible using object report/transcript. So, there is no built-in DAT code to pull Previous Enrollment dates on the Transcript.
You can, however, use DDE to pull these records which are not available to object reports.
Sorry, I am a fairly new to PowerSchool, but I was under the impression that you can build your own DAT codes with a PowerQuery. Also, how would I place the DDE within the object Report?
You can indeed build your own DAT codes with a PowerQuery Plugin:
DDE is Direct Database Export. You cannot place it on an object report; it is an area of PowerSchool that allows you to export data directly.