The Sponsored Projects Balances Report was recently enhanced with the addition of an Unformatted Data option in the report output choices. Selection of the Unformatted Data output returns an Excel file that has no special formatting and a single row for column headings, making it the best source for pivot tables and other advanced spreadsheet analysis.
In addition, when viewing the report in a browser, column sorting is now available on any field in the column header. Click the icons available in each column header to rearrange the output in ascending or descending order. The column sort feature is only available when viewing the HTML output.
Users may need to clear their browser’s cache in order to take advantage of these enhancements.