In the Save As box, type: Click Name your initials Summary Filter. 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 of the Student_Type column and click the Sort button. Select Sort Ascending title 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 of the College row and click the Sort button. Select Sort Ascending from the Sort title 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 of the row and click the Sort button. Select ACADEMIC_ORG_LDESCR Sort title from the Sort menu. Ascending Under the item, click and drag the UDSIS Training Extract UD_ACADEMIC_LOAD 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 of the UD_ACADEMIC_LOAD item and click the Sort button. Select Sort title Ascending from the Sort menu. Your work area should look like the one below: Run the report to see the data available to you.
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.
Cognos%20UDSIS%20Report%20Studio.docx