Home » Developer & Programmer » Reports & Discoverer » How To pass parameters to RPT
How To pass parameters to RPT [message #87952] Fri, 16 November 2001 02:38 Go to next message
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 Go to previous message
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);

----------------------------------------------------------------------
Previous Topic: Re: Dr. Watson Error----Urgent
Next Topic: Re: Printing part of group on second page
Goto Forum:
  


Current Time: Sun Jan 16 22:38:27 CST 2022