Please either Logon or create a New Account.
Author
Paul Dwyer (2)
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



It seems like there was a way to copy a calendar from a school to your other schools in PS.  I have it setup in our HS, but would like the same one to go to JH and Elementary.  Anyone doing this?
Tags: calendar
Comments
4 Responses to "Possible to copy a calendar to another school(s)?" (view all)

Yes.  Go to District - District Calendars - You can share calendars with your other schools.  Make sure your bell schedules are set up and that your times and day are EXACT. It will not copy over if there is any difference at all.  Such as title of bell schedule, time differences.  Check every school.  Once all that is set works great!

Thanks Rebecca for the inforamtion.  Never knew that was there before.  The issue is I have done my HS calendar, and need that one to go to the Elementary and JH schools.  I don't want to set it up in District, as that would involve having to setup the whole calendar again.  I thought there was a way to do it in DDA.

Paul,
there is an OLD customization called calcopy that I have and use to copy from one school to the next.  Let me know if you would like the pages.  I just bring them up in the URL using the path to them in the webfoot they are not linked to any pages I have.

Suzanne

Post Your Comment



  1