True Connection 4FrNoWJT60VsW7WYaUl3f9Vw9SlWVsPdf1rNpeo9JSrUfNHLxV+zBX8TYVzwAKAv+XjZCU5MerxiFf1YYCXnD8J49yheBfPt7Fz5yfAsImPCboGKxktL+WtJTb1nXKS7xHD5CUsFQ8hoXCWQY3hiP+V+0QlNS0MJ+Q== Connection MainData PupilForename,System.String PupilWholename,System.String PupilSurname,System.String PupilDOB,System.String PupilGender,System.String PupilForm,System.String PupilFormTutor,System.String PupilFormTutorTitle,System.String PupilFormTutorForenameSurname,System.String PupilHouse,System.String PupilYearGroup,System.String PupilYearGroupName,System.String PupilRegistrationGroup,System.String PupilAge,System.String ClassName,System.String ClassNotes,System.String SubjectID,System.String ClassSubjectName,System.String MarksheetName,System.String ColumnID,System.String ColumnName,System.String ColumnOrder,System.Int16 ColumnNotes,System.String ColumnSubjectMatter,System.String AcademicYear,System.String ReportingPeriodName,System.String ReportingPeriodStartDt,System.String ReportingPeriodEndDt,System.String AssessmentAwarded1,System.String AssessmentAwarded2,System.String ColumnTextNotes,System.String ColumnType,System.String Comment1Header,System.String Comment1Text,System.String Comment2Header,System.String Comment2Text,System.String Comment3Header,System.String Comment3Text,System.String Comment4Header,System.String Comment4Text,System.String Comment5Header,System.String Comment5Text,System.String PupilId,System.String TeacherNameForReport,System.String PupilFormTutorForename,System.String PupilFormTutorSurname,System.String DivisionID,System.String SchoolID,System.String SchoolName,System.String SubjectOrder,System.Int32 ReportingPeriodYear,System.String ReportingPeriodID,System.String ReportingPeriodPeriodName,System.String PupilPreferredForename,System.String SubjectNotes,System.String PupilID,System.String MainData ReportData.PupilAchievementData Attendance PupilID,System.String TotalSession,System.Int32 IsInAttendance,System.Int32 TotalLates,System.Int32 UnauthorisedAbsences,System.Int32 AuthorisedAbsences,System.Int32 Absences,System.Int32 30 Attendance Connection _x0040_StartDate,GetReportingStartDate_x0028__x0029_,4,0 _x0040_EndDate,GetReportingEndDate_x0028__x0029_,4,0 _x0040_PupilIDs,GetDelimitedDistinctValues_x0028__x0022_PupilID_x0022__x0029_,18,15000 SELECT CP.PupilID, SUM(1) AS TotalSession, SUM(cast(ATS.IsInAttendance as int)) AS IsInAttendance, SUM (Case when (PSA.AbsenceTypeId in ('CL1-10'))then 1 ELSE 0 END) AS TotalLates, SUM (Case when (PSA.AbsenceTypeId in ('CL1-2','CL1-8','CL1-9'))then 1 ELSE 0 END) AS UnauthorisedAbsences, SUM (Case when (PSA.AbsenceTypeId in ('CL1-3','CL1-4','CL1-5','CL1-6','CL1-7'))then 1 ELSE 0 END) AS AuthorisedAbsences, SUM(CASE when (ATS.IsInAttendance = 0) THEN 1 ELSE 0 END) AS Absences FROM CurrentPupil AS CP INNER JOIN FNSplitTextIDs(@PupilIDs) AssPupil ON CP.PupilID = AssPupil.[id] INNER JOIN PupilPersonalDetails AS PPD ON PPD.PupilID = CP.PupilID INNER JOIN PupilSessionAttendance AS PSA ON PSA.PupilID = CP.PupilID AND PSA.AttendanceDate BETWEEN @StartDate AND @EndDate INNER JOIN AbsenceTypes AS ATS ON ATS.AbsenceTypeID = PSA.AbsenceTypeID INNER JOIN SchoolDefaults AS SD ON SD.SchoolID = CP.SchoolID Group by CP.PupilID RelationAttendance PupilID RelationAttendance RelationAttendance PupilID Columns Formula ,LogoName,LogoName,System.String,Logo.jpg,False,False ,LogoPath,LogoPath,System.String,,False,False Columns,Effort,Effort,System.String,,False,False Columns,Homework,Homework,System.String,,False,False Columns,WorkingAt,WorkingAt,System.String,,False,False Columns,EndofYearTarget,EndofYearTarget,System.String,,False,False Columns,Strategytoimprove,Strategytoimprove,System.String,,False,False Columns,EffortGrade,EffortGrade,System.String,,False,False Columns,EndOfYearPredictedLevel,EndOfYearPredictedLevel,System.String,,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,18.5,0 PageHeaderBand1 {MainData.PupilWholename} Transparent 0,1.2,18.5,13.4 None;Black;1;Solid;False;1;Black Transparent 2.8,2.8,6.8,0.6 Times New Roman,11,Bold 2,0,0,0 Text3 {MainData.PupilForename} {MainData.PupilSurname} Black None;Black;1;Solid;False;1;Black Transparent 0,2.8,2.6,0.8 Times New Roman,11,Bold 2,0,0,0 Text4 Name: Black None;Black;1;Solid;False;1;Black Transparent 0,4.2,2.6,0.8 Times New Roman,11,Bold 0,0,0,0 Text10 Attendance: Black None;Black;1;Solid;False;1;Black Transparent 9.2,4,1.2,0.8 Times New Roman,11,Bold 4ecb4b4440bc463baac420769f31e495 0,0,0,0 Text11 Late: Black Expression All;Black;1;Solid;False;1;Black [223:223:223] 0,11.8,4,1.6 Times New Roman,11,Bold Center 0,0,0,0 Text16 Subject Black Expression Center All;Black;1;Solid;False;1;Black [223:223:223] 4,11.8,2,1.6 Times New Roman,11,Bold d5291e13f44d4a90a605ca94602b3cc0 Center 0,0,0,0 Text17 Effort Black Center All;Black;1;Solid;False;1;Black [223:223:223] 6,11.8,12.4,1.6 Times New Roman,11,Bold e5bc1bbc9dd34f6ca98a2467a59cc680 Center 0,0,0,0 Text21 Steps for Success Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center None;Black;1;Solid;False;1;Black Transparent 3.4,0.8,15,1 Book Antiqua,16,Bold Center 0,0,0,0 Text1 Learning Report Term 1 December 2013 Black Expression Center None;Black;1;Solid;False;1;Black Transparent 2.8,4.2,4.2,0.8 Times New Roman,11,Bold 0,0,0,0 Text9 {Round(((double)((double)Attendance.IsInAttendance/ (double) Attendance.TotalSession))*100)}% Black None;Black;1;Solid;False;1;Black Transparent 10.8,4.2,4.2,0.8 Times New Roman,11,Bold 0,0,0,0 Text14 {Round(((double)((double)Attendance.TotalLates/(double) Attendance.TotalSession))*100)}% Black Expression True AdvTransparent;1;Solid;Transparent;1;Solid;Transparent;1;Solid;Transparent;1;Solid;False;4;Black Transparent 0,0,3.4,1.8 V:\Users\s.keens\Desktop\cis-logo.jpg {LogoPath} Image1 True None;Black;1;Solid;False;1;Black Transparent 9.6,2.8,1.2,1.2 Times New Roman,11,Bold 2,0,0,0 Text6 Class: Black Expression None;Black;1;Solid;False;1;Black Transparent 10.8,2.8,6.2,1.2 Times New Roman,11,Bold 2,0,0,0 Text5 {MainData.PupilForm} Tutor: {MainData.PupilFormTutorTitle}. {MainData.PupilFormTutorSurname} Black Expression All;Black;1;Solid;False;1;Black [223:223:223] 0,5.4,4,1.6 Times New Roman,11,Bold 33e103673c26482bbcc657adc7053f47 Center 0,0,0,0 Text8 Subject Black Expression Center All;Black;1;Solid;False;1;Black [223:223:223] 4,5.4,2,1.6 Times New Roman,11,Bold 5aa9f07f7d2547d685d1e5ff75785755 Center 0,0,0,0 Text12 Effort Black Center All;Black;1;Solid;False;1;Black [223:223:223] 6,5.4,2,1.6 Times New Roman,11,Bold f7da61518caa4ba49a148955a3c0ede7 Center 0,0,0,0 Text13 Current NC Level Black Expression Center All;Black;1;Solid;False;1;Black [223:223:223] 12,5.4,6.4,1.6 Times New Roman,11,Bold ebd349f66db84309a6439e23a101ead5 Center 0,0,0,0 Text15 Steps for Success Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center All;Black;1;Solid;False;1;Black [223:223:223] 8,5.4,2,1.6 Times New Roman,11,Bold ef5e8f2ce77449f59697c152ce72cf06 Center 0,0,0,0 Text19 Predicted NC Level June 2014 Black Expression Center All;Black;1;Solid;False;1;Black [223:223:223] 10,5.4,2,1.6 Times New Roman,11,Bold af7d1038787a40b5b4f589f577f9d3ce Center 0,0,0,0 Text20 Expected End of Y1 NC Level Black Expression Center All;Black;1;Solid;False;1;Black [223:223:223] 0,7,4,1.6 Times New Roman,11,Bold a2ae93536667445ea900400e6014851e Center 0,0,0,0 Text24 Subject Black Expression Center All;Black;1;Solid;False;1;Black White 0,8.6,4,1.6 Times New Roman,11,Bold f5be65152e934f1ab52359042623c6ca Center 0,0,0,0 Text28 Black Expression Center All;Black;1;Solid;False;1;Black White 0,7,4,1.6 Times New Roman,11,Bold 6aa99e52ab034c26aba793bf61d780dd Center 0,0,0,0 Text25 Black Expression Center All;Black;1;Solid;False;1;Black White 0,10.2,4,1.6 Times New Roman,11,Bold c652ebb77f2f4682a4060fde4f34be26 Center 0,0,0,0 Text29 Black Expression Center All;Black;1;Solid;False;4;Black White 4,7,2,1.6 Times New Roman,11,Bold 0,0,0,0 Text30 Black Expression All;Black;1;Solid;False;4;Black White 10,7,2,1.6 Times New Roman,11,Bold 052edcdd614147638b33566cebdc2b1c 0,0,0,0 Text41 Black Expression All;Black;1;Solid;False;4;Black White 8,10.2,2,1.6 Times New Roman,11,Bold 21e415d46d9a4f59a893f3afc57056d4 0,0,0,0 Text31 Black Expression All;Black;1;Solid;False;4;Black White 10,10.2,2,1.6 Times New Roman,11,Bold 37e3d192ebf140059530777432652ad9 0,0,0,0 Text32 Black Expression All;Black;1;Solid;False;4;Black White 6,10.2,2,1.6 Times New Roman,11,Bold 47ca63877e554b18abfa5f7f2c67ee0e 0,0,0,0 Text33 Black Expression All;Black;1;Solid;False;4;Black White 4,10.2,2,1.6 Times New Roman,11,Bold b3f80601b3534e54a039817aab2cd47e 0,0,0,0 Text34 Black Expression All;Black;1;Solid;False;4;Black White 10,8.6,2,1.6 Times New Roman,11,Bold 9df923e6acfb4aabaf4d0ef7667d6176 0,0,0,0 Text35 Black Expression All;Black;1;Solid;False;4;Black White 8,8.6,2,1.6 Times New Roman,11,Bold 34ec000fb623443e9f93771afa0877e7 0,0,0,0 Text36 Black Expression All;Black;1;Solid;False;4;Black White 6,8.6,2,1.6 Times New Roman,11,Bold 642cbe07ef2e48faa7f8fade0a82ff56 0,0,0,0 Text37 Black Expression All;Black;1;Solid;False;4;Black White 4,8.6,2,1.6 Times New Roman,11,Bold e066b80d62164235acb604baedde1da9 0,0,0,0 Text38 Black Expression All;Black;1;Solid;False;4;Black White 6,7,2,1.6 Times New Roman,11,Bold edb3ec46456d4c15b4d6fac029a42b95 0,0,0,0 Text39 Black Expression All;Black;1;Solid;False;4;Black White 8,7,2,1.6 Times New Roman,11,Bold 205be96a7b3f465e8de3c5348a90b44b 0,0,0,0 Text40 Black Expression All;Black;1;Solid;False;4;Black White 12,7,6.4,1.6 Times New Roman,11,Bold 0,0,0,0 Text42 Black Expression All;Black;1;Solid;False;4;Black White 12,8.6,6.4,1.6 Times New Roman,11,Bold feb0f22b50954f608fabcc83db89cc97 0,0,0,0 Text44 Black Expression All;Black;1;Solid;False;4;Black White 12,10.2,6.4,1.6 Times New Roman,11,Bold cc6102d3f90a4067b11b88858989cea0 0,0,0,0 Text43 Black Expression {MainData.PupilSurname}{MainData.PupilForename}{MainData.PupilID} groupHeaderPupil True ResetVars() {MainData.ClassSubjectName} Transparent 0,15.4,18.5,0 {MainData.SubjectOrder} groupHeaderSubject Transparent True 0,16.2,18.5,1.2 Transparent True True 0.6,0,7.2,1.2 Transparent True 0,0.4,7.2,0 RelationAttendance Attendance DataAttendance Panel1 MainData True data DynamicSetVars() Transparent 0,18.2,18.5,2.2 All;Black;1;Solid;False;1;Black Transparent True 4,0,2,2 Times New Roman,11 True Center 0,0,0,0 Text22 {Effort}{EffortGrade} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center True All;Black;1;Solid;False;1;Black Transparent True 0,0,4,2 Times New Roman,11,Bold True 5,0,0,0 Text26 {MainData.ClassSubjectName} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg Center All;Black;1;Solid;False;1;Black Transparent True 6,0,12.4,2 Times New Roman,11 True 5,5,0,2 Text27 {Strategytoimprove} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center groupFooterSubject Transparent 0,21.2,18.5,0 All;Black;1;Solid;False;4;Black Transparent 0,0,4,2 Times New Roman,11,Bold 0,0,0,0 Text2 General Comments Black Expression All;Black;1;Solid;False;4;Black Transparent 4,0,14.4,2 Times New Roman,11,Bold 0,0,0,0 Text7 Black Expression groupFooterPupil True bba115bfdce1405ba20e111e565e9eb9 1.5,1,1,1 Assessment 29.7 21 A4 Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 11/17/2013 9:12:54 AM 2/26/2009 1:45:08 PM \\WCLSVDFAPP01\Listings\Assesments\PRIMARYREPORT.mrt e6b4f5ad14b248eeafa91a26ff790d5a Report Centimeters 2012.3.1500 CSharp