Re: How to include Instance ID in SQR output file name?

[Tony DeLia <tdelia@EROLS.COM>]

madav,

   Easy. Try this...

<start>
....

let $Rpt_Name = 'default.lis'

if $process_instance <> ''
   let $p_id = lpad($process_instance,6,'0')
   let $Rpt_Name = 'pi' || $p_id || '.lis'
end-if

new-report $Rpt_Name

....
<end>

This is a very basic solution... I'm assuming 6 digits for process
instance... Change to suit your needs... Also I'm checking if it was run
outside of Process Scheduler (using the standard PeopleSoft
convention)... If it's not the Process Scheduler (i.e. run from SQRW
prompt) I default the report name to 'default.lis' since there is NO
process instance to use. Example yields $Rpt_Name of 'pi001234.lis'...

                                                -Tony DeLia


madav . wrote:
>
> I would like to pad Process Instance ID from Process Scheduler with in
> the SQR report to generate a unique output filename (eg., abc101234.lis
> where 101234 is current Instance ID) .
>
> Any idea to resolve this?
> Your help is much appreciated.
>
> Madav
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com

--
Tony DeLia
AnswerThink Consulting Group
PeopleSoft Solutions Practice - Delphi Partners
tdelia@erols.com