Custom Reports Bundle 3.4.4

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.

Customization:

Contributor: 
Jason Treadwell
Brent Johnson
Brian Andle
Tim Scoff
Matt Freund
Roger Sprik
Michael Moore
Dean Dahlvang
Plugin: 
N
CPM Import Friendly: 
Y

Comments

Anyone notice that the tabs whited out after upgrading to 7.8? Making the labels essentially disappear? Happened to mine and another districts.

Gil Mara
Hawthorne School District

We recently updated the test server to 7.8. After doing that the tabs for custom reports appear white and very hard to see. We have applied the lastest custom reports bundle 3.4.4 and the SqLreports4. Is there a fix for this?

Thank you,

judi

Does anyone have problems with their sqlReports after 7.8? When I run any of them it just shows the parameters. I know the query runs because it allows me to make the students my selection.

When will there be an update to correct this?

Would it be possible to have a place in the PDS setup for the "security group=9" value? I know most installs default to 9 but for whatever reason my install is not 9 and It is no fun finding and changing the security group value from 9 to what ours is for every update. I know from last PSUG conf that there were several districts I talked to who had similar issues where thier admin security group was not the "9" group. I discussed this with Jason at the conf and he thought that putting the security group value in the setup page might be a good solution.
Thanks Robert

We are finding that CRB student selection doesn't seem to work in the Chrome browser.
Anyone else run into this? Thank Robert

I run the reports almost exclusively from chrome and don't have a problem with that function.

Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org

I've installed the custom reports as the directions state and have one problem, the Daily Attendance Summary report has only zeros for days absent....all the reports are great but this was the one report a need daily at the District. It just doesn't seem to be "seeing" my attendance codes. Other reports that use my attendance codes are working. Any ideas of how I can fix this report? -- Thanks

Vickie Gray

Not sure if it helps but I changed the fff to 000 in TableTools_JUI.css in the scripts > TableTools > css folder. Now all of my sub buttons (Copy, CSV, EXCEL, PDF, Print) are black with white text. Not as pretty as some may want but they sure show up well.

Original TableTools_JUI.css code snippet:
button.DTTT_button,.ui-buttonset button.DTTT_button {
position: relative;
float: left;
height: 24px;
margin-right: 3px;
/*padding: 3px 10px;*/
border: 1px solid #d0d0d0;
background-color: #fff;
cursor: pointer;
*cursor: hand;
}

Modified TableTools_JUI.css code snippet:
button.DTTT_button,.ui-buttonset button.DTTT_button {
position: relative;
float: left;
height: 24px;
margin-right: 3px;
/*padding: 3px 10px;*/
border: 1px solid #d0d0d0;
background-color: #000;
cursor: pointer;
*cursor: hand;
}

I installed the Custom Reports Bundle V.3.4.4 back in late June on Powerschool 7.7.1 and just noticed that for the custom SQL reports, the query generated for student selection doesn't always work (usually doesn't). When I use SQL reports v.4 with it, I have the same problem. The strange thing is that on my QA installation which has PS 7.7.0 and an earlier version of CRB (3.4.2), everything works fine. In fact, I can copy the query generated for student selection that doesn't work on the 3.4.4 installation, create a new custom SQL report and paste it where the main query goes, and it returns the DCIDs as expected. I know it has to be environmental, but I don't know where to start looking. Has anyone else experienced anything similar, or do you have any clue what could be causing this kind of behavior?

Thanks,
Tom Bradford
Lexington (SC) School District One

With the 7.8 upgrade we are experiencing problems with the Letter Grade Report.

"When we run a selection of Activity_Football =1 we get our 112 football players...all boys but when we run the Custom report of Letter grades report and choose Q1 and current selection we get a different group of kids."

It is the Letter Grades Report on the Grading tab in the reports custom bundle. It is not honoring the current selection when you choose that from the dropdown, it is giving you all students that meet that criteria.

I just encountered this issue myself. If you have access to change the page code, here's what you should do...

The report is located at /admin/reports/grading/gradesreport.html

Change this:

~[if.~[gpv:s]~[gpv:t]~[gpv:h]=cur-99-99]
INNER JOIN ~[temp.table.current.selection:students] temp ON temp.dcid=s.dcid
[/if]

to this:

~[if.~[gpv:se]=cur]
INNER JOIN ~[temp.table.current.selection:students] temp ON temp.dcid=s.dcid
[/if]

Jason, thanks for sharing the fix for the white tabs. Your fix worked for me as well.

If anyone is available to walk me through the installation of these reports, I would be very appreciative! My e-mail is kfoster@stmdphs.org

Thanks!

Kate Foster
Academic Counselor & SIS Administrator

When viewing our Custom Reports, the tabs are all white... I heard there was a fix for this but can't find it. Thanks!

Donna Zalar
PowerSchool Administrator
Lake Local Schools

dzalar@lakeschools.org

Hey Donna,
I am not sure if this is the recommended method for solving this issue but I changed the theme used to one that is more consistent with the standard PowerSchool theme and I am very happy with the results. I am posting the changes below.

On /admin/reports/customreports.html page change the original:

Custom ~[if.is.a.school]School[else]District[/if.is.a.school] Level Reports

~[if.pref.pdscrmdisable=1]~[redirect:/admin/reports/customreports_static.html][/if]

to the following:

Custom ~[if.is.a.school]School[else]District[/if.is.a.school] Level Reports

~[if.pref.pdscrmdisable=1]~[redirect:/admin/reports/customreports_static.html][/if]

The change is actually only line 8, changing the theme jquery-ui.custom.css from the one in the dark hive folder to the one in the crm-css folder.

Original line 8:

Modified line 8:

Hope this works for you.

I removed:
Custom ~[if.is.a.school]School[else]District[/if.is.a.school] Level Reports

~[if.pref.pdscrmdisable=1]~[redirect:/admin/reports/customreports_static.html][/if]

and replaced it with:
Custom ~[if.is.a.school]School[else]District[/if.is.a.school] Level Reports

~[if.pref.pdscrmdisable=1]~[redirect:/admin/reports/customreports_static.html][/if]

It changed the tabs but I'm getting a bullet list of everything before the reports, Help?

I'm on PS 7.7.

I updated to the latest version of the Custom Reports bundle, following the instructions as listed.

I can no longer edit ANY SQL report. The pencil just plain isn't there, period.

All the other features seem to function as normal, but I can't edit reports that either I or someone else created.

Please advise.

Thanks
Geoff

Geoff Lilley
Natomas Unified School District
Microsoft Office Master Instructor, Microsoft Certified Trainer
glilley@natomas.k12.ca.us

if you go to the bottom of the page you should see.... Configure sqlReports preferences once you click that link it will take you to a page that allows you to set the group for editing.

You were SO CLOSE.

Actually, I could NOT see those buttons, I regret.

Good news is, I remember reading about other people having the same problem I do...the IT Admin/SuperUser security group is NOT group #9, but group #12.

So I had to go into the customsqlreports.html file and tell it, "don't look for group 9, look for group 12."

And all was well.

Thank you to PowerData Solutions for this wonderful functionality, and thank you to Jeff Smith for a good suggestion.

Much obliged.

Geoff Lilley
Natomas Unified School District
Microsoft Office Master Instructor, Microsoft Certified Trainer
glilley@natomas.k12.ca.us

Most of the reports in the Custom Reports Bundle work beautifully! A tip of the toque to the creators. However, the Student Free Report and some of the Attendance Reports do not work for us. Are there any specific settings that we need to change to make it work in our division? Any suggestions as to why they don't work?

Found it...they work in Internet Explorer and Firefox. I was using Chrome....Wish the browsers didn't have all the little glitches when working in PowerSchool. One does one thing, the other not!

JJ

We are using 7.8.2 Power School, after upgrading we are unable to get the Nurses clinic listing (Health Report by Day) to load, and it is not in the 3.4.4 bundle. Does anyone have any ideas or suggestions on how to get this to load. Our nurses like the report.

Thanks
Sue

Belinda S. Calemine
Student Data System Adminitrator
450 Radio Lane
Culpeper, VA 22701

When you choose Current Selection on the Letter Grades Report (I am using version 3.4.4) it is pulling all students from all schools even though I am only at our Middle School with a current selection of 34 students. Is this something that can be fixed?

Melissa Tront
St Joseph County ISD

Has there been any answer on how to fix this? I see other people are having the issue but I haven't seen a response to it yet. Can anyone please help??

Melissa Tront
St Joseph County ISD

I just encountered this issue myself. If you have access to change the page code, here's what you should do...

The report is located at /admin/reports/grading/gradesreport.html

Change this:

~[if.~[gpv:s]~[gpv:t]~[gpv:h]=cur-99-99]
INNER JOIN ~[temp.table.current.selection:students] temp ON temp.dcid=s.dcid
[/if]

to this:

~[if.~[gpv:se]=cur]
INNER JOIN ~[temp.table.current.selection:students] temp ON temp.dcid=s.dcid
[/if]

Would love to have this report give the time in and time out and be able to select a student and date range.

Also, an option to run as daily or meeting.

Teresa Plumlee

School Bulletin
Says
Not Found
The requested file could not be found on this server.Error 404
PS 7.8.2

I just uploaded the new version and the tabs for each section looks like it is highlighted white and you can not read what they say. Ex: Attendance, enrollment, fees. What can I do to fix this?

You have to modify the line in guardian_header_yui.txt to ~[if.pref.bulletin~(curschoolid)=1][else]

  • Hi,

    New to PowerSchool. Is there a way to add two columns to the Custom Reports bundle, specifically the youngest child report? I need to add Primary Phone Number and Homeroom.

    Thanks.

    Hi,
    Also, New to PS, and we'd also like to add columns to Custom Reports-Enrollments-Entry/Exit Report (Student_Number and a local custom field). We tried modifying the tlist SQL to add Student_Number and the column header but it didn't work. Suspect we need to mod some other part of the HTML, but we are HTML novices. Did you ever get a response?
    Thanks

    After installing SQL Reports 4 our Custom Reports tab no longer appears under System Reports. Is there anyway to bring it back or should we re-install?

    Bob Owens
    ANWSU
    Vergennes, VT

    I created a custom report that until recently was working fine. I now get an error that the webpage is not available and if I click reload page I get no data. The query should return just under 3000 records. Has any one encountered this?

    Earlier today all the reports in the Custom Bundle were visible and working. This evening, the Custom Reports menu has changed. I no longer have all the reports visible.

    For example, my original page from this morning I had over 25 reports under the Grading heading alone. Now I have three, Gradebook Preferences, Honor Roll, and Internal Grade by Summary. All the most important ones are not there (i.e., Final Grade Setup).

    I checked in PS Admin to see if those reports are still there and they all are in the Grading folder, but I don't know how to display them on the table of contents. It's not just the Grading ones, but that's my main concerning at the moment.
    Sure would appreciate some help on this.

    Bonita Coleman

    I updated to PS 7.9.1 and also update the Custom Report Bundle and when I look at Custom Reports in PowerSchool all my tabs are white and I can't see what they say.

    Kathy Stainbrook
    Computer Technician Student Information Manager
    Centerville-Abington Community Schools
    115 West South Street
    Centerville, IN 47330
    kstainbrook@centerville.k12.in.us
    Phone: 765-855-3475 Ext 2193
    Fax: 765-855-3815

    Is there a way to limit the output to only active students.

    We had a situation where students got duplicated in the system. We have set the old version of the student to inactive. However, both versions of the student will show on this report.

    Marcia Philbrick
    Nemaha Valley High School
    mcphilbrick@usd115.org

    Marcia Philbrick

    I can't get the 'Maker Current Student Selection' button to work with the Student Attendance by Frequency Report. I've tried in both Firefox and Chrome.

    PowerSchool version 7.9.1 / Custom Reports Bundle was re-installed in late October 2013
    Macintosh OS X computer

    Marcia Philbrick

    We upgrade PS to version 7/9/1/2 and I loaded the latest Custom Reports bundle and Sql Reports 4. I have a few sql reports that were working fine and still run ok, but they now have a lot of white space between the report name and the data. How do I fix that? Also, there are some attendance reports I don't want to show in our list because we don't use daily attendance and the log reports are not pulling accurate data. How do I make these reports unavailable? Or for the log reports, how can I edit them so they show accurate data?

    Lynne

    I've modified this report to include our fields. The report runs great and our staff really like it. However, they would like to be able to print by Home Room Teacher, so I either need to figure out how to insert a page break or create a parameter to pull the report by Home Room Teacher. I've been trying to accomplish this but have not been totally successful. The parameter is there, but still pulls all homeroom teachers not the one selected. Can you help me with this? Here's what I have in there:
    ~[if#pageaction.~[gpv:action]#getresults]

    Emergency List

    ~[x:insertfile;/scripts/custom-jquery-1.0.html]
    ~[x:insertfile;/scripts/custom-datatables-1.0.html]
    ~[x:insertfile;/admin/includes/template/reports-commonscripts.html]

    (function($){
    var reportdataURL ='/~[self]';
    var pageseperator =' ';
    var totalreports = 0;

    $(function(){
    $('#params_container').accordion({collapsible:true,autoHeight:false});
    $('input:submit').button({label:"Submit"});
    $('.datepicker').datepicker({
    dateFormat: convertOracleDF('~[gpv:dateformat]')
    });
    $('#ui-datepicker-div').hide();//Bug in jQuery UI 1.8.9 causes datepicker div to be visible upon creation
    $('#params').submit(function(){
    clearError();
    $("#reportresult").empty();
    $("#reportresult").html('Loading ');
    var settings = $('#params').serializeObject();
    $.get(reportdataURL, settings
    )
    .done(processReportResults)
    .fail(function(xhr, status, error){
    $('#loader').hide();
    displayError("Report failed to load. Status Message: " +status);
    });
    return false; //override regular form submission
    });
    });//end jquery.ready

    function processReportResults(data){
    $('#reportresult').html(data);
    $('#reportresult table').addClass('display').dataTable({
    "bPaginate": false,
    "bFilter": false,
    "bJQueryUI": true,
    "sDom": 'T<"H"fr>t<"F"ip>',
    "oTableTools": {
    "sSwfPath":"/scripts/tabletools/swf/copy_cvs_xls_pdf.swf"
    },
    "aaSorting":[[0,'asc']]
    });
    }
    function displayError(msg){
    $('#error_container').html('Alert: '+msg+'').show();
    }
    function clearError(){
    $('#error_container').empty().hide();
    }
    })(jQuery);

    ~[wc:commonscripts]

    ~[x:insertfile;/admin/includes/template/admin_reportheader_start.html]
    Emergency List
    ~[x:insertfile;/admin/includes/template/admin_reportheader_end.html]

    Emergency List

    Report Parameters

    Home Room Teacher

    ~[tlist_sql;SELECT DISTINCT (ps_customfields.getstudentscf(students.id, 'IA_CLASSTEACHERNAME')) FROM students WHERE schoolid=~(curschoolid) ORDER BY (ps_customfields.getstudentscf(students.id, 'IA_CLASSTEACHERNAME'));]
    ~(gl)
    [/tlist_sql]

    Waiting for report parameters.

    ~[x:insertfile;/admin/includes/template/pds_copyright_footer.html]

    [else#pageaction]

    Student
    Gr
    Med
    Gdn
    Address
    Home
    Lives With
    Mother/Legal Guardian
    Father/Legal Guardian
    Home Room Teacher

    ~[if.is.a.school]
    ~[tlist;students;schoolID=~(curschoolid);enroll_status=0;(ps_customfields.getstudentscf(students.id,'IA_CLASSTEACHERNAME'))=[gpv;g];alternatecolor;>]

    ~(lastfirst)
    ~(Grade_Level)
    ~(alert_medical;if.not.blank.then=Yes)
    ~(alert_guardian;if.not.blank.then=Yes)
    ~(Street)~(City), ~(State) ~(Zip)
    ~(Home_Phone)
    ~(decode;~(father_custody);1;~(Father_rel);Father;Legal Guardian; ;)~(decode;~(mother_custody);1;~(Mother_rel);Mother;Legal Guardian; ;)
    ~(Mother), ~(Mother_rel)
    (w) ~(motherdayphone)
    (h) ~(Mother_home_phone)
    (c) ~(Mother_cphone)

    ~(Father), ~(Father_rel)
    (w) ~(fatherdayphone)
    (h) ~(Father_home_phone)
    (c) ~(Father_cphone)

    ~(IA_classteachername)

    [/if.is.a.school]

    [/if#pageaction]

    Do you have any old subdirectories from previous installs that can be removed in the Custom Page Management?

    i never get the data every time run this report.

    I always come with no data when run this report.

    We already have sqlReports 4. Is there a way to just install the Dashboards from the Custom Reports Bundle?
    Thanks,
    Nick

    I can't seem to put a custom SQL report into a report group - there is a blank dropdown. Apparently there are three groups, all blank, and it's making the SQL screen a bit messy - is there an easy fix?

    At this time, I would like to view/test just the FinalGradeSetups.html report. Is there a step by step process to be able to do this?

    Thanks,
    Jan

    If you would like to view any of the reports you need to have the custom reports bundle customization installed. Then you can use PS Administrator to modify the report and the regular PS interface to view it. I would highly suggest you do this on your test server.

    In the student discipline reports the Incident Type field is not displaying on the report. Any ideas on how we can get this information to display?

    When you say Incident Type field I don't understand what you mean? Can you list some examples of what you mean by Incident type field?

    Ok guys...Any ideas why when I put this simply query in sqlreports it only returns data for the first field and not the second? I also noted that the build header option only reports 1 field rather than 2...it is like this field is too long or something and sqlreports just can't deal with it...but it is a regular field in the table.

    select excludefromgpa, excludefromclassrank
    from storedgrades

    Thanks, Robert

    Is there a list of all the files from the old CRB so I can go in and delete them all.
    Thanks

    Pages

    Subscribe to Comments for "Custom Reports Bundle 3.4.4"