Re: How Do I define a the -f .lis file from within a SQR

["Shenoy, Sunil" <sshenoy@MAIL.TCU.EDU>]

Thanks to Tony and Don for their Suggestions !!  Go SQRUG !!

> -----Original Message-----
> From: Tony DeLia [SMTP:tdelia@EROLS.COM]
> Sent: Monday, July 26, 1999 9:30 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Re: How Do I define a the -f  .lis file from within a SQR
>
> Whoops! Actually it may produce something like...
> c:\sqr\tcucv.sqr101.lis !!!!!!
> The drive/path needs to be parsed off as well (along with the
> extension)...
> If you're using PeopleSoft use the standard $ReportID (which is the SQR
> name without the path or extension)... the programmer is responsible for
> populating this...
> In any event a very simple exercise either way... sorry for the
> oversight...
>
>     Tony DeLia
>
> Don Mellen wrote:
> >
> > On Mon, 26 Jul 1999, Tony DeLia wrote:
> >
> > > input #file_no 'Enter Legacy File No' type=integer
> > > let $Rpt_name = $sqr-program || edit(#file_no,'099') || '.lis'
> > > new-report $Rpt_name
> > >
> > > This will assign a name of 'TCUCV101.LIS' assuming the SQR program
> name
> > > is TCUCV.SQR and the user entered 101 as the File Number...
> >
> > Actually, I believe this will produce 'TCUCV.SQR101.LIS'.  This might be
> > fine on your file system, if not, you just need to substr() off that
> pesky
> > extension.  :)
> >
> > HTH,
> > -----------------------------------------------------------------------
> > Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
> > donm@ontko.com |  "In the beginning, there was nothing, which exploded"
>
> --
> Tony DeLia
> AnswerThink Consulting Group
> PeopleSoft Solutions Practice - Delphi Partners
> tdelia@erols.com
> http://www.sqrtools.com