The Invalid Records report is sorted in random order. How can I view it in alphabetical order?
You may view the Invalid Records report in any order you wish by running an extract, saving it as a Microsoft Excel spreadsheet, and sorting the list from there. To run an extract: 1. Select the Extracts tab at the top of the page. 2. Locate the extract you wish to run (Invalid records listing). 3. Click the Open button and the extract will open in a new window. 4. The default sort is alphabetical by employee name. To sort by any other column: a. Save the extract onto your computer by selecting File Save As from the browser menu. b. Re-open the extract using Microsoft Excel. c. Select Data Sort from the toolbar and specify your sorting preferences. Contact your agencys IT staff for assistance with Microsoft Excel.
