School Accreditation Form B Report FSM JasperReport

[Ghislain Hachey]

Two new reports to go in folder “School” called:

• School Form B Latest Report
• School Form B All Reports

They are very similar. One contains only the latest (best hopefully) Form B report. The other one contains all the Form B reports available in the system.

The specifications for Form B Report for FSM

https://drive.google.com/open?id=1snGBKs2Jw7JKXlgWO57BZfrJtpmNv92V (details about the report and all calculations necessary included)

Please carefully review all this and let me know how you do.

Here are the key warehouse tables/view

• warehouse.accreditations
• warehouse.BestInspection

You may also find the following views useful.

• pInspectionRead.SchoolStandardAssessment
• pInspectionRead.SSACriteria
• pInspectionRead.SSAStandard
• pInspectionRead.SSACategoryType
• pInspectionRead.SSATally
• pInspectionRead.SSATallyByStandard
• pInspectionRead.SSATallyByCategoryType

[Shraddha Tambe]

Report has been deployed on the production server and also checked from the FEDEMIS Application UI.

Tested with various older surveys. Please check.

Attached a document showing the results for some use-cases for old survey data .

Please check the same. We have some concerns, especially about the “Classroom Observation” data.

[Shraddha Tambe]

Report generated with Latest Survey submitted by us through the app. Please review all calculation & formatting changes as discussed on the call

‌

[Shraddha Tambe]

Hi @Ghislain Hachey , We have done changes in both default Form-B and Form-B prior 2019, tested with the FEDEMIS application and crossed checked data. seem everything is working good.

We are attaching default Form-B and Form-B prior 2019 pdf files.

Please review.

[Ghislain Hachey]

@Shraddha Tambe what is all these Form B reports? Which one is good?

[Shraddha Tambe]

Hi @Ghislain Hachey , report with the name “School Accreditation Form B Report.jrxml“ is the actual report. Please do not consider other reports

[Ghislain Hachey]

@Shraddha Tambe please cleanup the reports that are not suppose to be there

[Ghislain Hachey]

feat(JasperReports): works from Helical as of 25 March 2020

Resolves #736, #685, #686, #341, #678, #687, #765, #617, #656, #662, #777, #616

→ <<cset 8805ba9df3c5>>

[Ghislain Hachey]

feat(JasperReports): works from Helical as of 25 March 2020

Resolves #736, #685, #686, #341, #678, #687, #765, #617, #656, #662, #777, #616

→ <<cset b8641eaa78eb>>