Current Tooling U Administrators enjoy several “canned” reports (reports available to all Administrators) and the ability to create custom reports to meet their specific needs. Following the launch of the sixth version of Tooling U, one of the areas the Application Development team monitored and reviewed was the Group Reports section and identified several areas of improvement, which led to the development of several enhancements:- The Amount of Data – Large amounts of data can be accumulated throughout years of use and several reports were generated using an organization’s entire history resulting in extremely large sets of data. To prevent this, many reports now feature several search parameters to allow the Administrator to narrow the amount of data returned in the report.
- Data Filtering – Custom reports are great when an Administrator has a specific report format they need to run on a regular basis; but they can become a bother when one of the canned reports retrieves the data the Administrator wants but requires the Administrator to page through too many results. To address this i
ssue column filters have been added to almost all of the reports, allowing the Administrator to search for a subset of the results based on the column being filtered. For example, in the Comprehensive Report an Administrator can enter in “Smith” (last name) and modify the results to only display students with “Smith” in their last name. One filter per column can be used, allowing for a flexible and powerful method of filtering and sorting data.
- Data Sorting – Launched with the release of version six of Tooling U, many Administrators may not be aware the column titles (when applicable) allow the Administrator to sort the entire report by the data in the selected column. A single click sorts the data in an ascending order (a, b, c, d … etc.), a second click sorts the data in a descending order (z, y, x, w … etc.), while a third click will reset the report to its default display.
- Exporting Data – Many of the reports provide the capability the export their results directly to an Excel file. All of these Excel exports feature some enhanced features which went live with the release of Tooling U Version 6. However, after monitoring exceptionally large data exports it was discovered that the file size grew exponentially in size, creating difficulties downloading the report. Eventually, it would be possible to reach the limit of what Excel could handle. To compensate for this, all reports to Excel have now been capped to a specific level, which once reached will then switch the export format to CSV (a flat text file) reducing the size of the file while allowing more data to be exported.
If you are a current Tooling U Administrator and have some ideas of your own regarding the Group Reports feature please visit the Tooling U Idea Exchange at http://www.toolingu.com/community to share your idea’s with us and help us improve your Tooling U experience.
Web Developer
