Report Showing Under, Over and Official Age Enrollments Jasper Report

[Ghislain Hachey]

Nationally and by District and by School (but School aggregate data not yet ready and lower priority.)

Should be in three reports:

• National version located in Jasper's "Schools" folder (and online in Schools -> Dashboard) Call it "Age Distribution for Enrollments Nation.jrxml"
• District version located in Jasper's "Schools" folder (and online in Schools -> Dashboard) Call it "Age Distribution for Enrollments by District.jrxml"
• School version located in Jasper's "School" folder (and online in Schools -> School -> Dashboard) This one is a subreport to be included in the School Report Card 2 report.

Refer to the table [warehouse].[DistrictEdLevelAge]

[Shraddha Tambe]

Hi @ghislain ,

I have looked into jrxmls present inside Schools folder for National and District versions. I did check the table [warehouse].[DistrictEdLevelAge].

In both the jrxmls , we are showing pie chart (district/authority wise count of schools)

My question here is, do I have to add any tabular report towhich will show district/authority wise count of UnderAge ,OfficialAge or OverAge ?

or we should show stacked bar chart?

[Ghislain Hachey]

Yes, please go ahead with this and we can discuss it once I see a draft report

[Rupam Bhardwaj]

Hi @ghislain ,

we have completed the development and updated the files in the branch issue332.

[Rupam Bhardwaj]

Hi @ghislain ,

we have completed the Nation version of this report and shared in the bit bucket.

in the community version of jasper soft studio , we were facing issues in developing below visualization-

in jFree chart, the same visualization looks like below -

[Brian Lewis]

Maybe worth looking at my comment in issue #369 to see if the calculations used here are ok.

If comparing Overs and Unders, perhaps present as a percentage bar chart? ie the point is to show the relative percentages of children at official level, or older than official level BETWEEN states. If this varies between states, we can ask - why? Are kids starting later in one state? Are there impediments in getting to school ( distance/transport?) Are children repeating more? ....etc

[Rupam Bhardwaj]

@softwords - Please find attached the screenshot , we had tried to create the visualization in 2 ways.

Please check and let us know which one will work for you.

[Ghislain Hachey]

@rupam_bhardwaj I can't see your screenshot. Can you edit your post. You can also use the Preview button to see how it will look to make sure the image displays correctly.

[Ghislain Hachey]

feat(JasperReports): various new reports from Helical

Closes #333, #332, #354, #245, #346, #344, #360

→ <<cset f1bfb047f41a>>