Filtering Reports by Student Demographics

• 1. Click to the Conditions tab.Click the +Add button on the grid (the grid name will vary based on the report you are filtering).

  2. Select a property in the Condition column. 

     • You can search for a property by beginning to type it. For example, typing Enter will bring up a list similar to what is show at right. Note that the letters you type will display in red on the list. If you type the wrong letters, hit the Backspace key to remove letters from your search. 

     • Click a property in the list to select it. If you select the wrong property, you can click it again and hit the Delete key to remove it.

     • See below for a description of common properties.

  3. Use the Not and Operator columns to determine the logic of your filter.Enter the Value to filter by. If the property being filtered is a checkbox, enter Y for checked and N for unchecked. For example, the screenshot at right filters for Interpreter Needed is checked.

Suggested properties

The following are some properties you might consider using as a filter.

• 1. Grade (StudentSchoolYear.Grade) -- most reports have a Grade filter on the Options tab, but if a report is missing this feature you may be able to use the Conditions tab instead.Enter Date (StudentSchoolYear.EnterDate)

  2. Leave Date (StudentSchoolYear.LeaveDate)

  3. Leave Code (StudentSchoolYear.LeaveCode)

  4. ADA/ADM (StudentSchoolYear.ExcludeAdaAdm) -- this field can be used to return concurrently-enrolled students only. Select Condition = ADA/ADM (StudentSchoolYear.ExcludeAdaAdm), Operator = Equal To, and Value = Concurrent.

  5. Home Language (Student.HomeLanguageForAdd)Interpreter Needed (Student.InterpreterNeeded)

  6. Hispanic/Latino (Student.HispanicIndicator)

  7. Resolved Race/Ethnicity (Student.EthnicCode) -- The values that appear under Race on the Demographics tab of the Student screen can be entered here.

Multiple conditions can be added to the grid, but they are additive. The report will be filtered by all conditions added to the grid, for example, if one line is Enter Date Greater Than 1/1/17 and another is Enter Code Equal To R3, the report will return students with Enter Date greater than 1/1/17 AND Enter Code equal to R3. If a result set including students matching ANY of several conditions, the report will need to be run once for each condition.