Run the report to see the effect of disabling the filters. The report now shows all graduate programs at the University with students enrolled in them. Close the Cognos Viewer. End of Exercise Filter on Details and Summaries You can filter reports in several ways. In the following exercise, you will create a report, total the data, and filter first on detail data and then on the summary data. Exercise 13—Filter on Details On the Report Studio toolbar, click the New button to create a new report. If you are asked if you want to save the previous report, click No. In the New box, select List and OK. On the Source tab, expand the UDSIS Training item by clicking the plus sign and add the following fields to the work area: CAMPUS Student_Type (in the folder) ACADEMIC_ORG_LDESCR Descriptions (in the folder) COUNT_FIELD Statistics Add a line for the total of all students: Click the of the COUNT_FIELD item title On the toolbar, click the Aggregate button’s down-arrow Total. Click the of the ACADEMIC_ORG_LDESCR column and click the Sort title button. Select Sort Ascending. To get rid of duplicate values: Click the of the CAMPUS item. title Hold down the SHIFT key and click the of the Student_Type and titles ACADEMIC_ORG_LDESCR items. Click the Group/Ungroup button on the toolbar to group the items. Your work area should look like the one below: Run the report (Term = 2088) and notice the data in the aggregate report. The of all students appears at the bottom of the report. Page down to see all of the data (below are the first and last pages of the report): Close the Cognos Viewer window. you want your report to show only the number of undergraduates for each academic ►Suppose organization on the Newark campus. You can create filters to show only this data. Click the of the COUNT_FIELD column and, on the toolbar, click the Filters button. title In the Filters window, click the Add button. Under the Available Components pane, click the Data Items icon and double-click CAMPUS. will now appear in the pane. [CAMPUS] Expression Definition
Run the report to see the effect of disabling the filters. The report now shows all graduate programs at the University with students enrolled in them. Close the Cognos Viewer. End of Exercise Filter on Details and Summaries You can filter reports in several ways. In the following exercise, you will create a report, total the data, and filter first on detail data and then on the summary data. Exercise 13—Filter on Details On the Report Studio toolbar, click the New button to create a new report. If you are asked if you want to save the previous report, click No. In the New box, select List and OK. On the Source tab, expand the UDSIS Training item by clicking the plus sign and add the following fields to the work area: CAMPUS Student_Type ACADEMIC_ORG_LDESCR (in the Descriptions folder) COUNT_FIELD (in the Statistics folder) Add a line for the total of all students: Click the title of the COUNT_FIELD item On the toolbar, click the Aggregate button’s down-arrow Total. Click the title of the ACADEMIC_ORG_LDESCR column and click the Sort button. Select Sort Ascending. To get rid of duplicate values: Click the title of the CAMPUS item. Hold down the SHIFT key and click the titles of the Student_Type and ACADEMIC_ORG_LDESCR items. Click the Group/Ungroup button on the toolbar to group the items. Your work area should look like the one below: Run the report (Term = 2088) and notice the data in the aggregate report. The of all students appears at the bottom of the report. Page down to see all of the data (below are the first and last pages of the report): Close the Cognos Viewer window. ►Suppose you want your report to show only the number of undergraduates for each academic organization on the Newark campus. You can create filters to show only this data. Click the title of the COUNT_FIELD column and, on the toolbar, click the Filters button. In the Filters window, click the Add button. Under the Available Components pane, click the Data Items icon and double-click CAMPUS. [CAMPUS] will now appear in the Expression Definition pane.
Cognos%20UDSIS%20Report%20Studio.docx