Re: Appending multiple reports output into one file

[Alan Ljungberg <Alan.Ljungberg@CNPL.ENBRIDGE.COM>]

Vijay;
I should ready your questions thoroughly before I open my big mouth.

No I've never used OPEN and WRITE on .spf files before, maybe someone here
has and can be of some assistance.  My reply was in error I intended to
recommend using OPEN and WRITE to output to a file (not .spf) and if you
needed, print from this output file.  It's much easier to control than the
unpredictable .spf appending, especially if your in PeopleSoft.  So if your
having trouble controlling the .spf creation why not avoid them, that is
unless you have a specific reason not to?  There are some commands that
force the creation of .spf files that I know of the -KEEP or -NOLIS options
of course and also using the last-page command, as well as some others i
don't recall.  I'm sure you can find them all listed in the archive or
likely someone here knows them all.

-Alan.





                    "Pimple, Vijay C Mr
                    USAREC"                     To:     SQR-USERS@list.iex.net
                    <Vijay.Pimple@USAREC        cc:
                    .ARMY.MIL>                  Subject:     Re: Appending 
multiple reports output into one file
                    Sent by: "Discussion
                    of SQR, Brio
                    Software's database
                    reporting language"
                    <SQR-USERS@list.iex.
                    net>


                    02/22/2002 04:55 PM
                    Please respond to
                    sqr-users






Hi Alan,

I combined reporta and reportb into one sqr file and used 'USE-REPORT'
command, but it writes to two different output files.

Can I open *.spf files in append mode ? If you have any sample code, please
send me ?

Thanks,

________________________________________
Vijay Pimple
EDS-ARISS
6579 Eisenhower Ave., Room 321,
Fort Knox, KY - 40121
(502)-626-1144


-----Original Message-----
From: Alan Ljungberg [mailto:Alan.Ljungberg@CNPL.ENBRIDGE.COM]
Sent: Friday, February 22, 2002 9:56 AM
To: SQR-USERS@list.iex.net
Subject: Re: Appending multiple reports output into one file


Instead of the -A flag you can use the OPEN and WRITE commands in your SQR.
You can control the destination of the output as well as the file name with
variables so you have that flexibilty.

For example:

   OPEN c:\temp\reporta.spf as 1 FOR-APPEND record=100
      WRITE 1 from $var1 $var2 $var3  ! etc etc
   CLOSE 1

-Alan.




                    "Pimple, Vijay C Mr
                    USAREC"                     To:
SQR-USERS@list.iex.net
                    <Vijay.Pimple@USAREC        cc:
                    .ARMY.MIL>                  Subject:     Appending
multiple reports output into one file
                    Sent by: "Discussion
                    of SQR, Brio
                    Software's database
                    reporting language"
                    <SQR-USERS@list.iex.
                    net>


                    02/22/2002 05:45 AM
                    Please respond to
                    sqr-users






Hi all,


I want to run report A, report B and report C and append the output into
one
file.

I ran report A and created output file reporta.spf
I was using -A switch while running report B to append the output of report
B in the same file reporta.spf

But I am getting following error - "Unknown Command line flag", when I use
-Afilename.

I am not sure how -A switch works ? Is there any other way of appending
multiple reports output into one file ?


Thanks,
________________________________________
Vijay Pimple
DBA
6579 Eisenhower Ave., Room 321,
Fort Knox, KY - 40121
(502)-626-1144