How To pass parameters to RPT [message #87952] |
Fri, 16 November 2001 02:38 |
Umesh Maharana
Messages: 1 Registered: November 2001
|
Junior Member |
|
|
Hi ,
I am facing problem in passing parameters to a RPT (Ver 1.1) file as command line arguments ...
My aim is to run a rpt file from SQL*Forms30 .
I am entering parameters in Forms Screen and want those parameter to be passed to that rpt file called.
Thanks
Umesh
----------------------------------------------------------------------
|
|
|
Re: How To pass parameters to RPT [message #87966 is a reply to message #87952] |
Tue, 27 November 2001 08:01 |
Heide
Messages: 2 Registered: November 2001
|
Junior Member |
|
|
Here is a code example from one of my forms which runs a report:
('runrep $CDS/CDSRE601 USERID=/ PARAMFORM=no'||
' DESTYPE=' ||:DESTYPE||
' DESNAME='||:DESNAME||
' DESFORMAT='||:DESFORMAT||
' COPIES='||TO_CHAR :COPIES ||
' P_PROVIDER='||HOLD_PROV_PARAM ||
' P_PRU='||HOLD_PRU_PARAM ||
' P_ADM_DATES='||HOLD_ADM_PARAM ||
' P_TRANS_ENTRY='||HOLD_TRANS_ENTRY_PARAM ||
' P_TRANS_UPDATE='||HOLD_TRANS_UPDATE_PARAM ||
' P_EPISODE='||HOLD_EP_PARAM
, no_screen);
----------------------------------------------------------------------
|
|
|