WebFOCUS Techniques

Create a Subfoot

When creating a report, you sometimes want to include totals at the end of the report that count certain characters. Examples would be the number of students accepted for admission, different types of aid received, number of students enrolled by campus, etc. The following exercise using the SPRIDEN table will illustrate how to do a subfoot.

1. Create Your Report
   1. Open a new report in Report Assist
   2. Choose the SPRIDEN table
   3. Select the following sort fields
      1. SPRIDEN_LAST_NAME
      2. SPRIDEN_FIRST_NAME
      3. SPRIDEN_ID

2. Create Define Fields to Get Counts (If you want the fields to line up easily, you should define your fields with the same format. I'm using I5 for this exercise).
   1. Click on the COMPUTE tab
   2. Click New Define
   3. Create the DEFINE fields as follows and click OK:

    

   STUDENTS

The technique for STUDENTS is used to get a unique count of the number of students on the table.

FIRST

FULLNAME

SHORTNAME

3. Choose Your Column Fields
   1. Click the Fields tab
   2. Choose the SUM tab
   3. Click on the fields SHORTNAME, STUDENTS, FIRST (in that order) as your column fields.
4. Eliminate the Appearance of Sort Fields on the Report
   1. Click on FIELD OPTIONS button
   2. Highlight SPRIDEN_LAST_NAME and uncheck the Visible indicator
   3. Highlight SPRIDEN_FIRST_NAME and uncheck the Visible indicator
   4. Click OK
5. Create Where Statements
   1. Click the WHERE tab
   2. Click New by Existing Where statements
   3. Create the WHERE statements as follows and click OK:

    

   SPRIDEN_CHANGE_IND

SPRIDEN_LAST_NAME

6. Choose Options
   1. Choose PDF in Display Format
   2. Submit the program to see that you are reporting the fields correctly.
7. Create Define Field to Do Subfoot (This can be any alpha field you wish).
   1. Click on the COMPUTE tab
   2. Click New Define
   3. Create the DEFINE field as follows and click OK

This technique is used to create a sort field upon which the whole table can be totaled. Unlike specific fields (example: SRIDEN_LAST_NAME) which would put a subfoot total after each SPRIDEN_LAST_NAME.

8. Make Previous Define Field a Sort Field
   1. Click FIELDS tab
   2. Choose SORT tab
   3. Click on field TABSUB
   4. Click on arrow in FIELDS box to move this field to your first SORT field
9. 9. Eliminate the Appearance of Columns Fields on the Report
   1. Click the FIELD OPTIONS button
   2. Highlight STUDENTS - uncheck the Visible box
   3. Highlight FIRST - uncheck the Visible Box
   4. Highlight TABSUB - uncheck the Visible Box
10. 10. Go To Subfoot Tab
    1. Click the right arrow next to the RECOMPUTE tab. The SUBFOOT tab will appear. Click on the SUBFOOT tab.
    2. In the open box type the titles for the fields you want to subfoot. If you want your totals in a certain column you would do the following (50 indicating the column number):
       
       NUMBER OF STUDENTS <50<TOT.STUDENTS
       NUMBER WITH FIRST NAME OF Kristin or Ralph <50<TOT.FIRST
       
       
    3. If you want to show a line and leave some space between the line and your subfoot information you can draw a line and space twice before the titles of your subfoot information as follows: Then click OK.

11. Heading
    1. Click HEANDINS tab
    2. In the open box type
       
       TECHNIQUE FOR SUBFOOT WITHOUT COUNTER FIELDS SHOWING </2
       
       
    3. Save your program then Submit your program (see Show Only Totals?)

MCIS Documentation and Information page at Miami University