Use Filters on a Custom Report

When in a Custom Report, select Filters. Make sure data has been added to the report prior to filtering.

1. Click on the green + sign.
2. Select the Data Column you would like the filter to apply to.

3. Select the Field Operator, or rule, that the data column show follow. Depending on the data column selected, field operations may vary.
4. Enter a Filter Value to be used in conjunction with the Filter Operator you selected. For example, if you only want your reports to list students with a particular proficiency level (such as 4/Proficient and above), you would select 4 here.
5. Click Save Filters.

You will now see your filter displayed with your columns. You may repeat the above steps to add additional filters if you desire. To go back to your data columns, select Manage Columns.

Any column with a filter applied to it, will display this scope symbol on the Manage Columns page.

Click Saves Changes and View to see your report.

The Sacred Six are data categories that must have their partner also added to the report to use as a filter and help you achieve the best, most accurate results. Please note, depending on the nature of the report, you may not need to add these columns of data.

• If you added Enrollment<Grade Level, filter by Enrollment<Academic Year
• If you added Teacher<Teacher Name, filter by Roster<Roster is Current
• If you added Enrollment<Site Name, filter by Enrollment<Site Current

Typically these filters are hidden from the report in Manage Columns, since they are added to the report to assist in providing the most accurate data as opposed to displaying information that is needed.

You can check out some additional reporting options at Create a Form Letter Using Custom Reports and Mail Merge.