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.
In the Save As Name box, type: your initials Summary Filter. Click Save. End of Exercise Filter Crosstabs You can filter crosstab reports using all the methods we have discussed for filtering list reports. In the following exercise, you will create a crosstab report and filter it in several ways to see subsets of the data you are using. Exercise 15—Filter a Crosstab Report On the Report Studio window toolbar, the New button to create a new report. In the New box, select Crosstab and OK. On the Source tab, expand the Training Extract item by clicking on the plus sign. Click Student_Type and drag the selection to the Columns section of the work area. When you see the Columns area flash black, release the mouse button. Click the title of the Student_Type column and click the Sort button. Select Sort Ascending from the Sort menu. and drag the selection to the Rows section of the work area. When you see the Rows area flash black, release the mouse button. Click the title of the College row and click the Sort button. Select Sort Ascending from the Sort menu. Click COUNT-FIELD (in the Statistics folder) and drag the selection to the Measures section of the work area. When you see the Measures area flash black, release the mouse button. Click ACADEMIC_ORG_LDESCR (in the Descriptions folder) and drag the selection to the right of College in the Rows section of the work area. When you see the bold black bar, release the mouse button. the title of the ACADEMIC_ORG_LDESCR row and click the Sort button. Select Sort Ascending from the Sort menu. Under the UDSIS Training Extract item, click UD_ACADEMIC_LOAD and drag the selection under the Student_Type item in the Columns section of the work area. When you see the bold black bar, release the mouse button. the title of the UD_ACADEMIC_LOAD item and click the Sort button. Select Sort Ascending from the Sort menu. Your work area should look like the one below: Run the report to see the data available to you.
Close the Cognos Viewer window. On the Report Studio window toolbar, click the Save button to save the report. End of Exercise You can also create a cascading prompt that will re-prompt you to select the next set of values once you have selected one set. You will create a prompt in the following exercise. Exercise 20—Create a Multiple-Value Cascading Prompt On the Report Studio toolbar, click Open and go to My Folders. In the Open box, scroll down and open the your initials Cascading Prompt Multiple report. ► You will insert a prompt button into your report that will let you move from prompt to prompt. Click the Page Explorer tab in the center of the Report Studio window. Click Prompt Page 1 In the Insertable Objects pane, click the Toolbox tab. Scroll down to the end and Prompt Button . Drag the Prompt Button to the right of the ETHNICITY prompt box. Click the Prompt Button that currently says “Next”. Go to the Properties pane. Under General, click Type. Using the pull-down arrow, select Reprompt.