Previous Topic: Step 5— Retrieve the dataNext Topic: Creating Your Report From an ASF Table

How to Make a Report from a Table › Creating Your Report From an SQL Table › Step 6— Display your report

Step 6— Display your report

Your report displays information on the employees in department 4000 with the additional selection criteria you specified.

     CA OLQ Release nn.n                          *** Display Report ***
 ->                                                                  Line     1
125004 press the ENTER key for DISPLAY/FORMAT ACTIVITY selections

 EMP_LAST_NAME_0415 EMP_STATE_0415 EMP_PHONE_0415 EMP_SALARY_AMOUNT_0415 START_
 ------------------ -------------- -------------- ---------------------- ------
 CONNOLLY	MA		6173298912 49000.00 	      89
 COOPER		MA		6173291111 74000.00               89
 CULLIPERO	NH      		6033291433 90000.00               91
 SACCO   	NH 		6033291212 80000.00               90
 STEVENS 	MA 		6173298155 48000.00               89
 STYCZCHENSKI 	MA		6173292323 48000.00               90
 SULLIVAN 	MA 		6173292323 55320.00               91
 SZCHIEU	NH                 	6033291414 47770.00               91
     END OF REPORT








 1=HELP     3=QUIT     4=MESSAGE     6=MENU     7=BWD     10=LEFT     11=RIGHT

Press [PF11] to see the right half of the report.

     CA OLQ Release nn.n                          *** Display Report ***
 ->                                                                  Line     1
125004 press the ENTER key for DISPLAY/FORMAT ACTIVITY selections

YEAR_0415 EMP_DEPT_ID_0415
--------- ----------------
          4000
          4000
          4000
          4000
          4000
          4000
          4000
          4000









 1=HELP     3=QUIT     4=MESSAGE     6=MENU     7=BWD     10=LEFT     11=RIGHT

Type leftmax or lmax on the command line to return to column 1 of the current page of the report. Type home on the command line to return to column 1 of the first page of the report.