How to Make a Report from a Table › Creating Your Report From an ASF Table › Step 4— Specifying additional selection criteria

Step 4— Specifying additional selection criteria

Additional selection criteria

The Additional selection criteria field and the Selection Criteria screen, give you more room to add selection criteria for the rows of data you want in your report.

In this example, you want to report on those employees whose:

• Department ID is 4000 (already specified above)
• Project is Evaluation
• Manager is Ms. Sanchez (DEPT-HEAD-ID = 0111)
• Last name begins with a 'C' or an 'S'
• Annual salary is greater than $40,000 and less than $100,000
• Start date with the company was after 1988

Begin entering the additional selection criteria on this screen. Then specify Y to go to the Selection Criteria Screen for more room to enter selection criteria.

     CA OLQ Release nn.n                          *** Column Select ***
 ->                                                       Page     1 Of     1
124000 Select columns, specify selection criteria and press the ENTER key.

   Columns Currently Selected:    0     Selection Criteria     Distinct N Y/N
 _ EMPLOYEE
 _ 02 EMP-ID
 s 02 EMP-LAST-NAME
 _ 02 EMP-FIRST-NAME
 s 02 START-YEAR
 s 02 DEPT-HEAD-ID
 s 02 DEPT-ID                               eq 4000
 s 02 SALARY-AMOUNT
 s 02 PROJECT
 _ 02 OFFICE-CODE




 Additional Selection Criteria: PROJECT EQ 'EVALUATION'  


                                   Proceed to Selection Criteria Screen? Y Y/N  
 1=HELP          3=QUIT          4=MESSAGE          6=MENU          PA2=REFRESH

Finish entering the additional selection criteria.

     CA OLQ Release nn.n                          ***Selection Criteria***
 ->                                                Line     1 Of     1

146000 Type in selection criteria, and press the ENTER key.
 Please Enter Additional Selection Criteria:
 PROJECT EQ 'EVALUATION' AND (DEPT-ID EQ 0111) AND (EMP-LAST-NAME
 EQ 'C' OR EMP-LAST-NAME EQ 'S') AND (SALARY-AMOUNT GT 40000 AND SALARY-
 AMOUNT LT 100000) AND (START-YEAR GT 88)  













 1=HELP          3=QUIT          4=MESSAGE          6=MENU          PA2=REFRESH

With the Selection Criteria screen you can also enter:

• Logical record keywords
• Criteria expressions for subscripted fields