Re: Working with multiple reports

[Ray Ontko <rayo@ONTKO.COM>]

Colin,

There are two approaches:

1) modify the program so that the CSV is written to a file using
WRITE instead of PRINT (as has been suggested by others), or

2) use -NOLIS and -KEEP to save copies of the .SPF files instead
of generating the .PDF and .CSV files.  Then, in a second step,
use

  SQRP xxx.spf -printer:pd

to generate the PDF file, and

  SQRP yyy.spf -eh_csvonly

to genreate the CSV file.

If you like you can use CALL SYSTEM at the end of your program
to perform these steps.  If you do, be sure to use NEW-REPORT
on each of your reports to close-out the initial file.

Ray

> Hi,
>
>      I have a SQR program that generates a summary report as well as a
> detail report. I am trying to find a way to make the summary report
> generate in .pdf format but the detail report in .csv  I can not seem to
> find a way to create two different types of output from the same program as
> it seems to be controlled by a switch on the command line.
> Is there a way to accomplish this?
>
> Thanks
> Colin
> =======================================
> Colin Abbott
> Analyst (Finance)
> Information Systems Resources
> McGill University
> E-mail: Colin.Abbott@MCGILL.CA
> Fax: 1-514-398-8252
> =======================================
>

----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/