Please either Logon or create a New Account.
Month
Sep 2016 (3)
We have used the Low Current Grades report to do our down list that I got from somewhere a few years ago.  All worked well, except now with the new gradebook the Last Update isn't pulling into the report.  It shows it as 00/00/00 on the report.

Here is the code that is used in the report.  ~(v.DSQL_lastupdate)  Any suggestions?
Tags:
Comments
3 Responses to "Pulling LastUpdate from Gradebook into report?"

From Matt Freund: 

Updating the Low Current Grades Reporting Engine Reports

I recently posted how to update the Current Grades sqlReports to show the last grade update, but some places still use a reporting engine I created years ago that does the same thing. I quit updating it after PS 7 and no longer support it in general because of sqlReports, but here's how to get the last grade update to work okay in the reporting engine report as well:
This only applies to Version 7.0 of the Low Current Grades reporting engine reports (you see the version number when you run the report) -
1 - click on system reports, engine, and the setup link on the engine tab. That will bring up a list of reporting engine reports.
2 - click on the Variables link on the line for the Low Current Grades report.
3 - click on the sqlStatement link on the variable page.
4 - in the Value box, look for the cc.lastgradeupdate reference in the first SELECT line and change the cc to pgf. In other words, change it to read pgf.lastgradeupdate.
5 - scroll to the bottom of the page and click on Submit.
The next time the report is run, the last grade update value should be correct. Originally I had the report pulling from the cc table, but PTP doesn't save the last grade update to that table. Both gradebooks instead save the last grade update to the PGFinalGrades table, which is what the pgf is a reference to in the sql.
There were some versions of the report that had an activities drop-down, and the fix should be the same. If you have a version older than the 7.0 one, then I'm not sure how to fix it and I don't support it. I'd recommend you use sqlReports instead and the reports on the Grades Report page of this site.
I also had a Last Gradebook Update reporting engine report and it won't work with PTP. The fix for it isn't as easy because it mainly looks at the cc table for the last update and to make it look at the PGFinalGrades table would take rewriting everything. I have a similar sqlReport on this site for site subscribers, but if you're not a site subscriber and want a free report, then I'd recommend installing the grades bundle as part of the Custom Reports Bundle from powerdatasolutions.org as it has a last update report.
Matt

Thanks Peggy.  That was it.

Thank You!  Work like a charm.  Thanks for the step by step directions!

Post Your Comment



I am putting grades in and I keep getting the message that "An invalid grade scale exists for at least one class or standard. Contact your administrator to correct the grade scale configuration before saving scores." I've looked, but I'm not sure what I need to change. Some of my teachers have this, and some do not.  I've tried to check the grade scale in both course and section to make sure they match, but it is time consuming, even for a little district like ours to go through every single one.  Suggestions?
TIA
Tags:
Comments
1 Response to "PTP Invalid grade scales"

I just fixed this for our Elementary Grade Scale. Look in District>District>Gradescales. I had a yield sign on the one affected. Click the pencil and in the Cutoff column, make the low grade = 0. We had a "U" have a low of an 80 and a teacher gave a kid a 50 and would get that message and not save. I made it a zero and all was good.

Post Your Comment



Roger Sprik will be a guest presenter.
He presents at National Conferences.
He will be presenting Enterprise Reporting, Data Import/Data Manager, and more.

Pam Taggart from the NDE will be there for NSSRS sessions/questions.

Prizes include 2 tickets to the Nebraska vs Purdue game (October 22).


Registration opens
September 7
Register here: https://nepsug.revtrak.net
Cost is $60 - includes continental breakfast and lunch

14th Annual Nebraska PowerSchool Users Group (NEPSUG)
Educational Service Unit #10 Kearney
76 Plaza Blvd, Kearney, NE  68845

Wednesday, October 5, 2016 - Networking Social (6:00-8:00 pm)
Thursday, October 6, 2016 - PowerSchool Sessions (8:00 am-4 pm)

Networking Social- La Quinta Inn & Suites
      *  Join us for snacks to network with fellow PS users!
PowerSchool Sessions- Educational Service Unit #10 located at 76 Plaza Blvd in Kearney
Lodging-  A block of rooms has been reserved at the LaQuinta Inn & Suites for Wednesday evening, October 5th.  Reserve your room by September 2

      *  108 3rd Ave, Kearney, NE 68845
        *  Call 308-237-4400 and mention you are with NEPSUG (Power School)  
      *  Room cost is $91.00
      *  Amenities include free wi-fi and a complimentary breakfast

Questions?
Contact Suzanne Stevenson (stevensons@discoverers.org  402-563-7000 ext.1503) or Andie Maupin(andrea.maupin@bpsne.net  402-827-8599)


Tentative Sessions
PowerTeacher Pro - New! (web based)
Enterprise Reporting - New!
PowerSchool 101
(for new schools using PowerSchool)
Secretary Session
Drop & Adds - What They Affect
Importing/Exporting with Data Manager
What is YOUR Question?
Stored Grades and Report Cards
GPA Troubleshooting
How to get your information for CRDC from NSSRS
Moving from NSSRS to ADVISER
NSSRS - Validation Reports
NSSRS Help Session
NSSRS How do you handle…?

Comments
2 Responses to "NEPSUG Conference Update - Special Guest - Roger Sprik"

The deadline to register at La Quinta Inn & Suites has been extended to September 22. Phone #: 308-237-4400. Mention you are with NEPSUG (Power School).

Roger Sprik will be a guest presenter.
He presents at National Conferences.
He will be presenting Enterprise Reporting, Data Import/Data Manager, and more.

Pam Taggart from the NDE will be there for NSSRS sessions/questions.

Prizes include 2 tickets to the Nebraska vs Purdue game (October 22).

Post Your Comment



  1