Cross Tab a Report

A cross tab allows you to display a report using a column value in a grid as the column header. This allows you to analyze the relationship of that value with one or more other columns in the report. For example, you want to see a count of the number of courses offered in an academic year within a specific group of departments. You may even want to know what instructors are assigned to those courses and how many courses each instructor is assigned to. You can create a cross tab to analyze this data. Although this example utilizes Student reporting, cross tabs can be used throughout all of the FAST applications. First, run your report using your selected filters. Open the Advanced Options tab. Expand the Cross Tab section. Select the value in the report that you want to become your column headings. The column headings in my example will be the course subject. Next, determine what you are going to populate the rows with and how you want to calculate that row. I have selected to populate the column heading (Department) with the CRN (Course Number). Next, I'll decide how I want to calculate the field. I am going to count the courses within that subject. When I execute the report, the new report will display how many courses exist within the given subject. I can add additional rows to the report by selecting additional rows to be displayed within the Grid Options section. Once you are satisfied with your cross tab, make sure you pin the result so that you can use it again without recreating the crosstab.