Re: How do you give a multiple report SQR specific file names (not sqrname99.lis)?

[Dennis Palmer <dennis.palmer@FERGINC.COM>]

      Assuming you want the report(s) to go to the same directory as the 
original
      you can do something like:

      let #pos  = instr($sqr-report,'oldname',0)
      let #pos  = #pos - 1
      let $path = substr($sqr-report,1,#pos)
      let $newreport = $path || 'newname.lis'
      new-report $newreport

      BEFORE you issue any PRINT commands.  Note that $sqr-report is a
      "built-in" variable in SQR that contains the complete path to the file.
       i.e.  " C:\TEMP\filename.lis " .  I would assume you know what the
       current filename is that you don't like.  You can just search for it in
       the string, pull out the directory path portion, and append on whatever
       filename you like.   Be sure to include the ".lis" extension.
       The "new-report" command tells SQR to start sending your output to
       "this" file.   You ought to be able to use this as a starting point to do
       whatever it is you want to do.....

-----Original Message-----
From:   John Haberin [SMTP:jhaberin@AMRE.COM]
Sent:   Tuesday, June 19, 2001 9:03 AM
To:     SQR-USERS@list.iex.net
Subject:        Re: How do you give a multiple report SQR specific file names 
(not sqrname99.lis)?

You can use the  -F  flag.  I have used this command when creating multiple
reports within one sqr.  example. -FXXX.lis -Fxxa.lis
I found out  how to do this from  the book SQR in PeopleSoft and Other
Applications.




Your Name <christine.x.maziarz@SB.COM> on 06/18/2001 02:20:45 PM

Please respond to sqr-users@list.iex.net

To:   SQR-USERS@list.iex.net
cc:    (bcc: John Haberin/AmericanRe)
Subject:  How do you give a multiple report SQR specific file names (not
      sqrname99.lis)?




We have an SQR with multiple reports using declare-report.  We switch
between the reports throughout the SQR.
Our reports print just as we would like them.  However, we are not happy
with the standard '.lis' filenames given to them.

We can't use the -f flag at the command line because we have multiple
reports.

We have tried renaming the .lis files within the SQR, but this does not
work as the reports are printed at the very end of the program.

Has anyone figured out a way to assign the report filenames anything other
than the standard filename?

Thank you all!!!!!

Christine Maziarz