In this example, you'll create a report showing students in your scope (school or district) who have at least one absence.
Starting any new report
To start, click Reporting on your menu. It defaults to the 'create report' screen, but you can see "saved reports" at the top, which you will use to open the saved report later.
1. From your SchoolStatus home dashboard, click Reporting. It defaults to the 'create report' screen.
2. Select SchoolStatus as your data source, and click "Choose" at the bottom.
3. Then click the arrows button and OK. These steps will usually be the same whenever you create any new report.
Choose the style of report
At the top, you'll see "Crosstab". For most basic reports, change that to TABLE, which will give you a simple grid. You may want to experiment with how fields are shown in Crosstabs vs. Tables.
Note: Changing the report style while building a report will remove data from your rows and columns.
Add data to Columns and Rows
Now, we can add data into Columns. Drag "Student Name" and "Grade" (grade level) into the Columns box- those are in the blue Fields, under Students. Beneath that section, you'll see a gold Measures section. In Measures, look under Students Core Data Aggregates and drag "Absence Count" into columns.
Create a data filter
In the previous step, you loaded all Absence Counts. To limit this report to only those which are greater than or equal to 12, right click on the purple "Absence Count" block you just dropped, and choose "Create Filter." Change "Equals" to "is greater than or equal to," type in the number, and click Apply.
You may have noticed that some student names are appearing more than once. By default, our report so far is showing all years of data related to absences. To select the current year's students, go back to the blue Fields; select Students Core Aggregates and right click on Attendance School Year to choose this year. (We don't need a column with the same year in every cell, so that's why we didn't drag it over.) Create a filter; choose "is greater than or equal to", add number, and click Apply.
Note: When choosing a year, always choose the year in which the academic session ends.
Organize your data
To put the grade column in front of the names, drag one block in front of the other. Then, hover over the report data column and right-click the column heading and choose "Use for Sorting" to organize by grade level first, and then by student name.
EXPORT: At this point, you can export the data without saving, or you can save both the template and the published report.
TITLE: Now, you may want to create a title- something like 2017 Absences 1 or more. This title will appear as the first row on your published report. Tip: Copy the title before you save, so you don't have to re-type it four times!
SAVE: Click the diskette (it is next to the eyeball); choose "Ad Hoc View and Save Report." Paste the report name you copied into both title boxes and both description boxes. Make sure to choose the 'Saved Reports' folder on both sides (if you get a save error, this is why.) Save.
VIEW: To view a report you've just created, go to Saved Reports at the top of the page. Choose All available or Reports, and Today.