Multiple output reports question

[Benjamin Le <ble@PCC.EDU>]

ORACLE 7.3, HP-UX 10.00, SCT-BANNER 3.1
I am trying to create two report outputs in the same SQR program. As the
example bellow, I want to print last names on the default report output
name and first names on a NEW-REPORT output.

Example codes:
--------------
begin-report
 do main
end-report

begin-procedure main
begin-select
spriden_last_name &last
spriden_first_name &first
 print &last (+1,1)
 new-report '/home/ble/first_name.lis'
 print &first (+1,1)
from spriden
end-select
end-procedure main

Is there a reset command after printing first name on 'first_name.lis'
(new-report) to prevent the next last name record prints on the
'first_name.lis'?

The example above overwritten the next first name on the same line of
previous first name on the 'first_name.lis'. How do I print the next first
name on the next line and so on on the 'first_name.lis'.

Since we have to use Job Submission for the default report with the special
format report name, DECLARE-REPORT and USE-REPORT can not be used here.

I hope my questions do not cause me as an idiot. Thanks for your help.



Ben Le
ITS - Sylvania CC-224
Voice:(503)-977-4970  Fax:(503)-977-4987
Mailto:ble@pcc.edu