Tutorial 3: Student Roster Report

Tutorial 1 - Student Roster: We will create a prebuilt report using Jaspersoft Studio with a student roster that groups students by school and grade level. Using variables we will count the number of students by grade level and graph the number of students at each grade level by school. Last, we will create a summary at the end of each school to show the distribution by grade level. We will use a CSV connection (Custom Report) Data Adapter as the data source for this report.

Here is a sample of what your final report should look like:

Site Summary:

Chart Summarizing Grade Levels at Each Site

End of Report Shows District Summary:

Getting started: 1. Create Custom Report using Search 2.0 by selecting all students & 'Make a Report’ 2. Sort the custom report by Current Site Name, Grade Level, Last Name, First Name, Middle Name 3. Apply a translation to the grade levels so they sort properly. For example, grade "K" translated to 0. 4. Export data into Tab Delimited file 5. Open Jaspersoft Studio and create DataAdapter. Name your data adapter StudentRosterData 6. Add ILLUMINATE parameter with data type “String" 7. Open data source, where it shows ‘SQL’ you will TYPE IN the string “illuminate_custom” 8. Link the Data Adapter 'StudentRosterData’ to your report 9. Save your file and begin report design as follows. 10. Create a group called “Site” 11. Create a group called “Grade Level” 12. Add Student ID, Last Name, First Name, SSID, Birthdate and Gender to the “Detail” band 13. Add the Current Site Name to the Site Header band 14. Add the text “Student Roster for: “ in front of the $F{Current Site Name} 15. Add the Current Grade Level to the Grade Level band, add "Grade Level: " in front of $F{Current Grade Level} 16. Click the Site Group Header, in Properties click “Reprint Header on Each Page” 17. Click the Grade Level Group Header, in Properties click “Reprint Header on Each Page" 18. Click Preview to see what the report is producing so far 19. Add a Variable to count the number of students in each grade level 20. Drag the variable onto the Grade Level Footer, and annotate with “Total Number of Students: “ 21. Create a bar chart with the number of students rostered at each grade level. Add this to the Site band. Add “Text” element with ""Total Enrollment for: " + $F{Current Site Name}" 22. Create a Crosstab in the Summary band to count the number of students rostered at each school and grade level 23. SAVE your report in Jaspersoft Studio (JSS) 24. Login to Illuminate, click Reports > Create a Jasper Prebuilt Report 25. Name your Report “Student Roster Jasper Tutorial 1”, upload the jrxml file you just created (should be in your My Reports folder), type in the name of the custom report you created) 26. In the reports list, search for the word “Tutorial” and you should see the Custom and Prebuilt you created. 27. Test running your report 28. Make edits to your report in Jaspersoft Studio 29. Save report in JSS and re-upload into Illuminate 30. Test again. 31. Share out report as desired.

Sample files for this tutorial are available here:

Tutorial 1 Sample Data

Tutorial 1 Report

Did you know Illuminate can build your BI Tool for you? Click here to learn about Illuminate's Report Building Service.