Removing Duplicate Students in a Custom Report
If you see multiple rows for the same students or teachers, it is not an error. This is happening by design in the report builder when you select a piece of data for which the same student or teacher has multiple "answers," at which point a "multiple row" element is introduced. Basically, the report is displaying all applicable data, though you may decrease this to 1 row per student or teacher if you wish.
For example, suppose your report displays Student ID, 2011 ELA CST Scale Score, and Teacher. A student has 1 student ID and 1 scale score from that particular test, so ordinarily he would display as only 1 row in your report, but if the same student has had multiple teachers over time you will see a row for each teacher.
Other systems make a "best guess" as to which piece of data (e.g., Phone Number) to display, but that approach is limiting and open to error. Illuminate's report builder offers you more control so you can view the data you want. If you want your report to show only 1 student or teacher per row, this lesson will show you how.
3. Select the title of the report you would like to edit.
Pick Criteria for Filtering Data
Click Add Columns.
You may be interested in other lessons from "Custom Report Options".