Custom Reports Bundle Validation

About
This plugin will add the validation reports to the custom reports bundle base. Note: the base plugin will need to be installed before you will see these reports automatically appear.

What's New in Version 4.1.1
Return of the export buttons. Also added some "make current selection of students" buttons when applicable.

How do I install a plugin?
Directions can be found here

Change History
V 4.1.1 - Released 2015-07-27

  • Updated to work with CRB Base 4.1.4
  • Added the export buttons back in

V 4.0.0 - Released 2014-04-01

  • Initial Release
Sponsor: 
Computer Logic Group

Customization:

Contributor: 
Jason Treadwell
Brent Johnson
Brian Andle
Tim Scoff
Others I'm sure I'm forgetting
Report Type: 
Web Based Report
Images: 
Custom Reports Bundle Validation tab
Plugin: 
Y
CPM Import Friendly: 
Y

Comments

I need some help with these sync error reports. How do you troubleshoot the error, "Unknown Sync Error"? I have several and I'm not sure where I should be looking to clean these up.
Thanks,

Elainna

I've got a patch that does the following:
1> Adds a warning if Next_Grade is equal to or less than the current grade level of the student.
2> Fixes the "Make Current Student Selection", and "Add to Current Student Selection" buttons so they select the entire selection.
(It seemed that the buttons were intended to only select Enrolled students, but they weren't working, so I fixed them by selecting all of the students in the report.)

The Patch file (I'm an old school *nix hack) follows:
--- RollOverErrors.html.orig Fri Jun 19 11:09:07 2015
+++ RollOverErrors.html.new Fri Jun 19 11:09:21 2015
@@ -60,7 +60,8 @@
CASE WHEN (s.Enroll_Status = 0 AND s.Sched_NextYearGrade = 99 AND s.Next_School != 999999) THEN 1 END nGradSch,
CASE WHEN (s.Enroll_Status = 0 AND s.Sched_NextYearGrade != 99 AND s.Next_School = 999999) THEN 1 END nGradGr,
CASE WHEN (s.Enroll_Status = 0 AND s.Next_School != 0 AND s.Sched_NextYearGrade NOT BETWEEN nsch.Low_Grade AND nsch.High_Grade) THEN 1 END NGOutOfRange,
- CASE WHEN (s.Enroll_Status IN (0,-1) AND s.SchoolID != s.Enrollment_SchoolID) THEN 1 END schMatch
+ CASE WHEN (s.Enroll_Status IN (0,-1) AND s.SchoolID != s.Enrollment_SchoolID) THEN 1 END schMatch,
+ CASE WHEN (s.Enroll_Status = 0 AND s.Sched_NextYearGrade BETWEEN -2 AND s.Grade_Level) THEN 1 END GrDemote
FROM Students s
INNER JOIN Schools nsch ON CASE WHEN s.Next_School = 0 THEN s.SchoolID ELSE s.Next_School END = nsch.School_Number
AND s.SchoolID LIKE CASE WHEN ~(curschoolid)=0 THEN '%' ELSE to_char(~(curschoolid)) END
@@ -71,6 +72,7 @@
OR (s.Enroll_Status = 0 AND s.Sched_NextYearGrade = 99 AND s.Next_School != 999999)
OR (s.Enroll_Status = 0 AND s.Sched_NextYearGrade != 99 AND s.Next_School = 999999)
OR (s.Enroll_Status = 0 AND s.Next_School NOT IN (0,999999) AND s.Sched_NextYearGrade NOT BETWEEN nsch.Low_Grade AND nsch.High_Grade)
+ OR (s.Enroll_Status = 0 AND s.Sched_NextYearGrade BETWEEN -2 AND s.Grade_Level)
ORDER BY s.enroll_Status, std, gr
;alternatecolor]
<tr class="oddRow" valign="top">
@@ -90,6 +92,7 @@
~(nGradGr;t;if.test=1;then=-Next Year School suggests Graduating but Next year grade does not<br>)
~(NGOutOfRange;t;if.test=1;then=-Next Year Grade not in grade range for school<br>)
~(schMatch;t;if.test=1;then=-SchoolID and Enrollment SchoolID should match for Active/Pre-enrolled students<br>)
+ ~(GrDemote;t;if.test=1;then=-Next Year Grade is less than or equal to Current Grade Placement<br>)
</td>
</tr>
[/tlist_sql]
@@ -98,8 +101,8 @@
<div style="text-align:center;">Report generated at ~[time] on ~[date]</div>

<h3 class="makeCurrentSelection">Use Students Above To Modify The Current Student Selection:</h3>
-<button type="button" onClick="selectStudents('replace','studentIDsEnrolled')" >Make Current Student Selection</button>
-<button type="button" onClick="selectStudents('add','studentIDsEnrolled')" >Add to Current Student Selection</button>
+<button type="button" onClick="selectStudents('replace','studentIDs')" >Make Current Student Selection</button>
+<button type="button" onClick="selectStudents('add','studentIDs')" >Add to Current Student Selection</button>
</div>

</div>

Hey guys,
Can you tell me all the places that need to be changed to allow security group 8 to see the validation reports in dynamic mode? I've found quite a few but I'm missing something.

Thanks.
Don

Subscribe to Comments for "Custom Reports Bundle Validation"