Version 4.0 is out and is modular and built for PowerSchool 7.9 and above. If you are looking for the reports bundle go here unless you are on PowerSchool 7.8 or older. This version will remain open only for users who absolutely need these reports and are on an older version of PowerSchool. If you can wait we recommend you do wait and install after upgrading PowerSchool to at least 7.9
3.4.4 (5/8/2013)
- Various report fixes where current selection is used.
3.4.3 (2/23/2013)
- Bug Fix: Fixed sqlReports accordion
- Adjusted reports that use current selection to use method that handles over 1,000 students.
3.4.2 (5/16/2012)
- New Report: Sub Finder - Find teachers that PowerSchool thinks are free to cover a selected staff member.
- Bug Fix: Projected Enrollment - Issue where counts were off when viewed from District Office.
- Bug Fix: Grades Dashboard - Removed extra submit button.
- New Feature: Consecutive Days - Added Make/Add Current Students to current selection. PS 7.0.3+ Required
- New Feature: Attendance Frequency Search - Added Make/Add Current Students to current selection. PS 7.0.3+ Required
- New Feature: Student Attendance List - Added Make/Add Current Students to current selection. PS 7.0.3+ Required
- New Feature: Exit/Entry Report - Added Make/Add Current Students to current selection. PS 7.0.3+ Required
- New Feature: Search Grades & Attendance - Added Make/Add Current Students to current selection. PS 7.0.3+ Required
- New Feature: Address Issues - Added Make/Add Current Students to current selection. PS 7.0.3+ Required
- New Feature: Phone Number Search - Added Make/Add Current Students to current selection. PS 7.0.3+ Required
- New Feature: Birthday List - Added Make/Add Current Students to current selection. PS 7.0.3+ Required
- New Feature: Youngest Child - Added Make/Add Current Students to current selection. PS 7.0.3+ Required
- New Feature: Student Free - Added Make/Add Current Students to current selection. PS 7.0.3+ Required
- New Feature: Bus Search - Added Make/Add Current Students to current selection. PS 7.0.3+ Required
Patch 3.4.1a (4/11/2012)
This patch is just a update to 3.4.1. CRB 3.4.1 must be installed first then this patch on top.
- New Report: CPM Files/Folders - Lists all the active custom files in Custom Page Management (CPM).
- Bug Fix: Student Attendance List - Widened the date entry boxes.
- Bug Fix: Monthly Attendance Review - Changed the date code used in the SQL query.
- Bug Fix: Projected Enrollment - When run from a school, the school can only see current, outgoing and incoming students.
- Bug Fix: Log Entry Search - Students without a Discipline_ActionTaken were not listed on the report. This has been resolved.
- Bug Fix: Instruction Time - Sections that were not full year were showing higher hours. This has been resolved.
Changes in version 3.4.1 (4/6/2012)
- Report Update: Phone Number Search updated to look at more stock phone number fields and report format is updated. (doctor_phone, emerg_phone_1, and emerg_phone_2)
- Performance Fix: Student Attendance List performance should be improved
- Bug Fix: Fixed Bad Entry Dates. Results will now show.
- Bug Fix: Fixed Projected Enrollment. Results will now show.
- Bug Fix: Updated Student Request Letters text wrapping.
- Bug Fix: Fixed issue where table tools and sorting would not work after running reports.
- Bug Fix: Fixed issue where popups on Exit/Entry, Consecutive days and Gradebook vs Stored would not work.
- UI Fix: Updated parameter box to be wider.
- New Report: Instruction Time. Shows how many hours/minutes a section meets based on the calendar setup.
About:
The Custom Reports Bundle is a collection of custom html reports and dashboards for PowerSchool. The content in this bundle has been contributed by several members of the PowerSchool customization community. The bundle also includes the Custom SQL Reports customization created by Dean Dahlvang.
Features:
The 3.x release of the Custom Reports Bundle has many great new features.
- New PS7 compatible layout on all reports
- Report data is retrieved with AJAX. No more page refreshes to get results.
- Most reports are now printable and sortable
- Some reports are exportable to PDF and CSV
- Performance improvements to underlying report queries.
- Improved UI for report parameters
Known Issues:
Several reports are still undergoing a transition to the new layout. As a result some are not working.
Broken Reports
- Schedule Course Demographics (/admin/reports/schedule/coursedemographics.html)
- Sections with no room Assigned(/admin/reports/schedule/SectionnoRoom.html)
- NY State Reports
Install Instructions - Custom Page Management:
To upload an entire zip you’ll have to be on PowerSchool 7. Then the steps are as follows:
Switch to District Office.
Use one of the 2 methods below to get to the import/export screen. I would click the export button on the screen listed below to make a backup of your current customizations so you have a backup copy.
A. PS Administrator->Custom Pages->Import/Export
B. District->Localization Administration->Import/Export Customizations
Export the current customizations as a backup.
After you have done that, click browse and select the PDS (or other customization) zip and then click import.
NOTE - The following steps will need to be done if using CPM, because of a bug in PowerSchool, to enable all the bundle features.
1. In CPM navigate to \scripts\tabletools\ click Add then Create Folder with the name swf, if it doesn't already exist.
2. Upload copy_cvs_xls_pdf.swf and copy_cvs_xls.swf from the \scripts\tabletools\swf folder from the unzipped download.
3. navigate to \images\css\theme\crm-css\ click Add then Create Folder with the name images, if it doesn't already exist.
4. Upload all the files from the \images\css\theme\crm-css\images folder from the unzipped download.
Install Instructions - Custom Webroot:
Unzip the downloaded file and place the included files in the same folder structure that exists in the zip in your data\custom\webroot folder.
Comments
joefire50
Mon, 11/26/2012 - 10:52am
Permalink
Teacher Free report not pulling all sections
Since our upgrade to 7/5, the Teacher Free report seems to not be pulling all free sections. It appears it may only be pulling year long classes. Anyone else see this issue?
joefire50
Mon, 11/26/2012 - 10:52am
Permalink
Teacher Free report not pulling all sections
Since our upgrade to 7/5, the Teacher Free report seems to not be pulling all free sections. It appears it may only be pulling year long classes. Anyone else see this issue?
carlsonj
Wed, 12/05/2012 - 9:23am
Permalink
Custom SQL Reports
I tried to edit an existing custom report by adding ~(schoolname) to the heading. As soon as I submit it the report goes away.... Is there anyway to add a variable to the report heading? Thank you.
mbowie0001
Thu, 12/06/2012 - 10:19am
Permalink
make current selection
I am having trouble getting my sql reports to give me a current selection.
this is the query
SELECT DISTINCT s.DCID FROM students s, HonorRoll h where s.id = h.studentid AND h.storecode = (%param1%) AND h.yearid = ~(curyearid) AND h.method = %param2% AND s.schoolid = ~(curschoolid);
any help would be greatly appreciated!!!!
Max Bowie
Data Applications Specialist
Colonial Beach Schools
Colonial Beach, VA
josecalahorrano
Tue, 12/11/2012 - 2:49pm
Permalink
Re: make current selection
Have you looked at the Yahoo tech group PSUG? There is a thread that has a discussion about SQL Reports and current selection. It is titled: Re: New Report Bundle 3.3.2. The link is: http://tech.groups.yahoo.com/group/PSUG/message/113315. Maybe that thread will give you an idea.
Jose
mhartung
Mon, 12/10/2012 - 2:44pm
Permalink
Student Free doesn't work in Chrome
under Live Scheduling, Student Free doesn't work in Chrome.
Student Free does work in FireFox.
Thanks for any help,
Mark Hartung
Grant Wood AEA
josecalahorrano
Tue, 12/11/2012 - 2:57pm
Permalink
Grade Detail Verification Information
The Grade Detail Verification Information Report is not displaying data in our District's schools. The file name is verificationDetail.html. The label for this report in the Custom Reports tab is Verification Detail Information. I have run the results tlist_tsql query in Oracle SQL Developer and I get data. Has anyone else seen and solved this problem? Would love to have some assistance in what is preventing the data from displaying on the page.
Thanks in advance,
Jose.
mtront
Fri, 12/14/2012 - 6:38am
Permalink
Gradebook Assignment Status Report
I would like to add date fields to this report. Our middle school runs this report during lunch hour homework, so the admin running it needs to be able to put dates in for missing assignments. Is there anyway dates can be added to the criteria? If not, do you guys do custom reports that we could pay for?
Melissa Tront
St Joseph County ISD
mrackler
Fri, 12/14/2012 - 11:26am
Permalink
help please
I imported the bundle twice but I don't have all of the items that I see on other folks systems. I don't have a create or import on the Custom reports page and I don't have the Validation tab on the Custom Reports. I was hoping someone could give me some suggestion on how to clear everything out and try again.
Thanks
Mike Rackler
Technology Director
Portales Municipal Schools
Portales, NM 88130
mrackler@portalesschools.com
bhodges
Tue, 01/08/2013 - 5:20am
Permalink
Custom SQL Reports not working with PS 7.6.0.1
Over the Christmas break, we upgraded to the latest version of PowerSchool, 7.6.0.1. We have now discovered that we cannot open any of the categories we developed which contain all of our SQL reports. At times, some may open but mostly they will not display the reports contained within the category selection. Is there a fix for this???
wvaughan
Tue, 01/08/2013 - 10:21am
Permalink
Custom SQL Reports not working with PS 7.6.0.1
I'm having the same issue, they will open when you first go to SQL reports but after that the categories
will not open.
bminter
Fri, 01/18/2013 - 10:02am
Permalink
Custom SQL Reports not working with PS 7.6.0.1
I have the same issue here as well. I can't access some of my reports that are in another category, and I desperately need them! Does anyone know a workaround to access the other categories?
janeta
Wed, 01/09/2013 - 8:47am
Permalink
Missing grades report
I am not getting any results when I run the missing grades report in the custom bundle. Maybe I'm not doing something correctly or don't have something installed. Any thoughts?
Janet
Elk City Schools
jmcgreevy
Thu, 01/10/2013 - 2:36pm
Permalink
change course recommendation requests
I like this report but I had to take a lot of the code out to show a course request that an administrator put in. So by taking out the course that requested the recommendation out I got all requests. Is this something that is possible to show both or just one or the other.
jmcgreevy
Thu, 01/10/2013 - 2:53pm
Permalink
course recommendation change 2
the link for the student leads you to the incident page it needs to lead to the course recommendation page.
if you need the new code let me know
Jon
nhoffman
Fri, 01/11/2013 - 8:20am
Permalink
Report bundle disappeared
Good Morning,
We recently upgraded to PS 7.6.0. Our custom report bundle tab has disappeared. Do we need to reinstall?
thank you,
Nancy
nhoffman@sau10.org
jtreadwell
Tue, 01/15/2013 - 7:15am
Permalink
re: Report bundle disappeared
Perhaps. I've heard some schools updated to 7.6.0 and CPM was turned on by the update process. That doesn't really make sense but it's happened to a few different servers that I know of. It's possible your CPM was turned on in which case turning it off will fix your issue. That is assuming you weren't using CPM to begin with. This is sporadic and so far once turned off it doesn't turn itself back on in our experience.
If that's not your problem then yes, you probably will need to reinstall. Its possible that your pages weren't put in the custom/web_root and so when you updated the custom pages were overwritten. Ultimately that'll depend on how you put the customization on your server.
Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org
vinit
Sun, 01/20/2013 - 9:24pm
Permalink
Report bundle disappeared
Hi... I am having the same problem since upgrading to version 7.6.01.
However, it is not consistent. Sometimes, when click on the categories then show reports under it, while most of the computers especially Macs, it does not display any reports.
I believe the issue is with the accordion class ... this line ' div class="accordion" '
to solve the current issue, I have changed it to ' div class="box-round" ' to permanently display the reports
...Vinit
Vinit Pathela
jroper
Tue, 01/15/2013 - 1:14pm
Permalink
Editing Custom SQL Reports
I am unable to edit existing SQL reports and unable to create new SQL reports. When I try to edit one, I get a HTTP Status 500 error. I have had this problem for about a week or two since upgrading to PS 7.6
Jeremy Roper
Independence School District
Independence, MO
Jeremy_Roper@isdschools.org
flora.contreras
Wed, 01/16/2013 - 9:27am
Permalink
forgive me for asking
I'm following the CPM directions and I'm stuck on the Please note sections...my files are created, but where do I "upload" the needed files in PS as directed in steps 2 & 4 below? thanks!
2. Upload copy_cvs_xls_pdf.swf and copy_cvs_xls.swf from the \scripts\tabletools\swf folder from the unzipped download.
4. Upload all the files from the \images\css\theme\crm-css\images folder from the unzipped download.
flora.contreras
Wed, 01/16/2013 - 9:42am
Permalink
Custom SQL Reports Page
When I click on a "Report Group" name the page appears like it is trying to render the extended list, but it doesn't, all I can see are "titles' of the report groups, it will not allow me to click on the arrow to expand my selection under any of my report groups...any suggestions? Thank you!
datagirl001
Mon, 01/21/2013 - 1:15pm
Permalink
Accordian Pain
The accordian fix posted earlier does seem to work.
carlsonj
Tue, 03/26/2013 - 2:47pm
Permalink
Accordian Pain
Which file do you make the modification in? I am having the same problem. It works in Chrome if you go to custom sql tab and "open in new window." Where am I making the div class=box_round change? Thank you.
cpotter
Fri, 01/18/2013 - 11:06am
Permalink
Custom SQL Reports Page
Like others, I'm having difficulty with the Custom SQL Reports customization... I've tried reinstalling (via CPM) the latest version, and it is still not working. I'm on PowerSchool 7.6.0.1.
Chris Potter
Data Manager
West Shore Educational Service District
carlsonj
Fri, 01/18/2013 - 11:24am
Permalink
admin\home screen is PS6 on PS7 server
I believe I had this problem before but cannot find how I fixed it. They updated our TEST server (not on an array) with state updates last week. Everything looks OK except for the Admin home page. It looks like the old PS6 home page. I check in CPM against my live server (on an array) and the admin\home.html is blue like it's customized, but it's blank. What am I missing?
**I just "customized" the original admin\home.html and published it. Rebuilt custom page links and it seems to be working. ???? ** Does anybody have an idea of what might be happening or if this really "fixes" the problem? Thank you.
vinit
Sun, 01/20/2013 - 9:25pm
Permalink
Hi... I am having the same
Hi... I am having the same problem since upgrading to version 7.6.01.
However, it is not consistent. Sometimes, when click on the categories then show reports under it, while most of the computers especially Macs, it does not display any reports.
I believe the issue is with the accordion class ... this line ' div class="accordion" '
to solve the current issue, I have changed it to ' div class="box-round" ' to permanently display the reports
...Vinit
Vinit Pathela
nhoffman
Thu, 01/24/2013 - 1:02pm
Permalink
Custom Report bundle 3.4.2
Good Morning,
I have successfully installed the report bundle on our test server 7.6.0 using CPM. I installed it on our production server also but I had an older custom report bundle on our production server, and have migrated it over from web root to CPM. Now the older version of the bundle shows up. Should I go through the import process again via CPM. or does the web root files just need to be deleted?
Thanks for the help, this is all very new to me.
thanks,
Nancy
nhoffman@sau10.org
acox
Fri, 01/25/2013 - 11:51am
Permalink
Modification to Missing Attendance Report
I edited the "MissingAttendance" report to be able to scan multiple days. If you're interested in the report, shoot me an email at acox AT renewschools DOT org. You're welcome to use it, or include it in future releases.
tbullard34
Sun, 02/03/2013 - 9:28am
Permalink
make/add current students to current selection
The Make/Add current students to current selection buttons do not work in the bundle. We re running PS v7.6. Is this a known issue?
Karina
Thu, 02/07/2013 - 2:55pm
Permalink
SQL Reports Customization Report Groups not working on 7.6
Hi Dean, thanks for this program. Its great. However, since 7.6 (we think) the report groups will not open to show the reports. We can't see them to run them. It will only the show the reports in the first Report Group. All we see is the report group headings. Clicking on the error just makes the screen bounce. We can't access our custom SQL reports to change the Report Group. We also can't change it in the GEN table because RptGroup is in a custom section of the Gen table.
To correct this, I deleted all our SQL reports out of the GEN table and created them again under one report group.
ewilliams1730
Mon, 02/11/2013 - 6:53am
Permalink
SQL Reports
I'm having the same issue, I'm unable to open the report categories on the SQL reports page. The first category is open when I open the page, but I'm unable to open the other categories and when I click on a different category, the first group closes and won't open up again.
Didn't have this issue before 7.6.1.
johannaj
Fri, 02/08/2013 - 12:19pm
Permalink
Folder \scripts\tabletools does not exist
Am I supposed to create it?
Johanna Johanson
Rio Rancho Public Schools
adamer
Fri, 02/08/2013 - 12:53pm
Permalink
7.601 and changes
I havent had the same errors everyone is mentioning when I upgraded to 7.601
I did add new columns to some of my reports and had CLG add a report for me a couple of weeks ago for attendance.
The only issue I am having is it seems the flash is crashing on my export to excel or csv buttons. I use chrome and my administrators firefox and everything is up to date. Has anyone else run into this?
johannaj
Fri, 03/15/2013 - 12:08pm
Permalink
Cannot log in to PS Administrator since installing
I loaded the custom reports bundle on my test server. It works very well, but now i cannot get into PowerSchool Administrator - it keeps saying the user name and password are invalid - I have tried several different user/password combinations that work just fine in production.
Forget this - problem resolved!
Johanna Johanson
Rio Rancho Public Schools
jsmthfld
Wed, 02/13/2013 - 3:36pm
Permalink
Student Attendance List Very Slow
I'm not sure if anyone is still developing for the bundle but the student attendance list is really slow again for all beginning dates after August. It takes about 15 minutes to run 1. This is the same problem as it had before, but it reappeared with 7.6. Hopefully someone can apply a similar fix again. Thanks.
thomasonb
Fri, 02/15/2013 - 4:00pm
Permalink
Projected enrollment report
We are running the custom reports bundle 3.6.2 but I am not seeing the projected enrollment summary under either the custom tab or system reports. I do see it in CPM however. Can you tell me where to look for it?
Barbara Thomason
Peninsula School District
Gig Harbor, WA
lazpowerschool
Tue, 02/19/2013 - 11:53am
Permalink
Projected enrollment report
I believe you have to add a link to the report. I added a link on Enrollment.html page.
wvaughan
Wed, 02/20/2013 - 7:12am
Permalink
Custom SQL Reports not working with PS 7.6.0.1
Has there been any fixes to Custom SQL reports not functioning properly after upgrading to 7.6.01. I have not seen any solutions to the reports categories not staying open. Does anyone have a fix?
dvanness
Fri, 02/22/2013 - 6:31am
Permalink
Last Gradebook Update report uses..??
I'm trying to validate the "Last Update" report data. Can you explain which field(s) are read to designate "update" ? ANY kind of update? Assignments added? Student grades calculated? I personally worked in a teacher's gradebook this week, yet for one subject the report shows no updates when I used either 30 or 120 days to test.
School and District Admin is keen on this information, too, and I want to insure accuracy in my interpretation. Thanks for any explanation.
--David Van Ness
stewartj@dlshs.org
Fri, 02/22/2013 - 12:26pm
Permalink
custom report - search for low grades - will not show all male
When using custom report - search for low grades aka letter grade report - will not show all males when that is the current selection. Girls will show when they are the current selection, selecting all students will show both boys and girls.
Anyone else with this problem? Any suggestions?
awperdue
Thu, 02/28/2013 - 9:09am
Permalink
Custom SQL Reports Tab Secuirty
Can anyone tell me how they have handled securing the Custom SQL Reports Tab so that users can access reports, but not create them?
Morse999
Thu, 03/07/2013 - 1:11pm
Permalink
Student Course Request letters
I'm having trouble getting this to run. Nothing happens upon submit, whether I have one or many students selected, regardless of settings. Can you help please? thanks!
chay
Fri, 03/15/2013 - 1:02pm
Permalink
Student Course Request letters
I'm having the same problem! Has there been a solution? It worked great last year.
Chris Hay
Morse999
Mon, 03/18/2013 - 7:19am
Permalink
Student Course REquest Letters
I never got a reply, but found that the report renders for me if i run it in FireFox. It will do nothing in IE9.
Linda Morse
agoldberg
Wed, 03/20/2013 - 6:50am
Permalink
Student Course Request Letters
I am able to get it to run in Firefox, Chrome, and IE10. However, if I run IE10 in compatibility mode it does not render. It appears to be an IE specific issue.
jbrislin
Fri, 03/08/2013 - 5:30pm
Permalink
Custom reports
Does this replace the current custom reports bundle? Will this override the other one?
kveilleux
Fri, 03/15/2013 - 11:49am
Permalink
Today's Daily Attendance Summary
I have a student that won't show up on this report. He has an absence code just like another student on the report - not sure what to check. When I run the standard "Absentee Report" in PS he shows up on the list.
johannaj
Fri, 03/15/2013 - 12:35pm
Permalink
Worked on test server but not in production
After reviewing the custom reports bundle on our test server I tried loading it to production. When I click on the Custom Reports tab, it says it is loading reports, but they never appear. I tried "Rescan" to no avail.
Our production setup is a stand-alone database server with six virtual application servers and an image server (also virtual). Do I need to do something special to handle these on an array?
Production and test are on 7.6.0.
Johanna Johanson
Rio Rancho Public Schools
johannaj
Fri, 03/15/2013 - 2:03pm
Permalink
Discipline Summary Report
The "No Subtype" row appears to be counting log entries for logs other than discipline. Is that the case? Could it be corrected to use the Discipline log only?
Johanna Johanson
Rio Rancho Public Schools
fitzgeraldl
Thu, 03/21/2013 - 11:29am
Permalink
Student Discipline Report
This is a great report but the Student Discipline Report doesn't pull any dates for Incident Date. I'm not sure where this data comes from. The field names for date & time entered on the New Log Entry page are entry_date and entry_time. How can I have that info pulled.
Thanks
Linda
Pages