Re: Appending multiple reports output into one file

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

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