If you've had the opportunity to participate in the latest Enrollment Review trainings, as promised here are the instructions on how to create your own Street Address Grid (SAG) report in Zangle. This query is a wonderful resource tool to have handy in your query writer when you're trying to identify what school a student resides in based on their grade, check spelling of street names and suffixes, checking zip codes, geocodes or validating a student's home address.

Go to Enrollment, Reports, and then select the Student Query Writer. Click on the New button to create a new query report. Select the Data Source View called 'Street Address Grid'. Follow the example below to put your's together.

The highlighted sections are key areas to have setup correctly to make sure the report works correctly. Make sure you select a layout that fits all the data you need returned and modify the column widths by adjusting the numbers next to the fields. In the Filters section, I added a '?', so the query would prompt me to enter a value(s). Notice also that next to the Grade filter, ' In List ' is the criteria to be used to enter a value and ' Begins With ' for Streetname. Test your query by clicking on the Preview button. Once tested and you are happy with the results, name the query in top field 'Query Name: ' and Save the file.

When you are prompted to enter values for your query, your prompt box should look like this:

The Grade - in list field will allow you to enter multiple grades (separated by a comma) or click on the All box to view all grades. The StreetName - begins with field allows you to enter the first few letters of a street name; the system will then return all possible street names that match the letters you entered.

Give it a try. If you have any suggestions or share a great example with others, click on the Comment box. We'd love to hear Zangle practices are out there :)