PowerSchool 12.0.4 Report Card issue

PowerSchool 12.0.4 Report Card issue

In version 12.0.4, PowerSchool introduced a limit to the number of records that can be retrieved via tlist_sql.  As a result, any request that would retrieve more than 50,00 records will return only the first 50,000.


This limitation causes the MBA Report Card Creator to fail to generate report cards in some circumstances when running for large groups of students.  This issue is most likely to arise when generating standards based report cards.


Consider the following scenario when generating a standards based report card:


200 students

8 courses per student (average)

15 standards per course (average)

4 grading terms (i.e. Q1-Q4)


This would result in a query that would return approximately (200 x 8 x 15 x 4) 96,000 standard grade records, and the report cards would not successfully generate for this group of students.


For PowerSchool Customers already on version 12.0.4 or above, running report cards for smaller groups of students will serve as a temporary workaround.  MBA developers are currently working on a new version of the MBA Report Card Creator that will accommodate the limitation PowerSchool introduced in version 12.0.4.  We do not have a target release date for this update but will keep you posted on our progress.

    • Related Articles

    • Comments on Report Card

      Depending on how you have your Teacher Comments set up determines the best way to have them show on the report card. If you are using Stored Grades table I would advise not pulling the comments on those tables since they are wanting multiple terms to ...
    • Extra Curricular Activities on Report Card

      1. You can use the newer Data Access Tag feature to add Activity information. For example, on my test server, I added a new row with 1 column, and then inserted a Text Element. In the Text Line box, I typed Activities: and then a space after it. I ...
    • Report Card on App or Mobile Web Pages

      Unfortunately we are unable to customize the PowerSchool App, so parents will not be able to see the Report Cards via an App. For Mobile Web pages, this would be a situation where a parent uses a phone or iPad and opens up the Parent Portal via ...
    • Update Report Card Creator

      Once we have released it, on the Start Page, in the dark blue ribbon, you should see the icon with "MBA" and an arrow pointing downward. If you click on that MBA download icon, you will see the version you are currently on (3.2) and the new version ...
    • Printing a Blank Report Card

      There is no way to run a blank report card but you could change the font for student name etc to white so it does not show when printing- just make sure you change it back.