CU System Administration – including the Office of University Controller and FSS Help – will close at 1:00 p.m. on Wednesday, November 27, and reopen for normal business hours on Monday, December 2.
What type of reports can be created using Query Studio?
Query Studio offers several different types of reports, including List Reports, Grouped List Reports, and Crosstab Reports.
List Reports
List Reports are created to show columns of information, with data only summarized on one criterion (if applicable). Examples of List Reports would be:
- Listing of all SpeedTypes for an Organization.
- Listing of all employees with a fiscal role for an Organization.
Grouped List Reports
Grouped List Reports are created to sort the data and suppresses duplicate values in a list report. An example of a Group List Report would be:
- Listing of all SpeedTypes and budget amounts by budget category for an Organization, grouped and summarized by SpeedType.
Crosstab Reports
Crosstab Reports are created to show a measure at the intersection of each row and column. For example, if a report shows budget category as columns, department as rows, and amount as the measure, the value at the intersection of each column and row will show be the budget, for that budget category, for that department.
Budget | Continuing Budget | Temporary Budget | Total Budget |
Department A | 10 | 5 | 15 |
Department B | 20 | 15 | 35 |