Running Report from Oracle Form [message #88119] |
Sun, 24 March 2002 21:26 |
yuvraj
Messages: 6 Registered: January 2002
|
Junior Member |
|
|
Hello everybody,
Can you please tell me how to call a report from and form which will pass some parameters from the form which will be used to form the query.
Further can we pass the query directly to the report module and use it instead o creating it.
Thanks in advance.
Regards,
Yuvraj
|
|
|
Re: Running Report from Oracle Form [message #88174 is a reply to message #88119] |
Wed, 24 April 2002 05:19 |
arun kumar
Messages: 13 Registered: April 2002
|
Junior Member |
|
|
DECLARE
PL1_ID PARAMLIST;
RPT_DATE_VALUE VARCHAR(20);
BEGIN
RPT_DATE_VALUE:='21-JAN-2001';
PL1_ID := Get_Parameter_List('tmpdata');
IF NOT Id_Null(PL1_ID) THEN
Destroy_Parameter_List( PL1_ID );
END IF;
PL1_ID := Create_Parameter_List('tmpdata');
Add_Parameter(PL1_ID,'BACKGROUND',TEXT_PARAMETER,'NO');
Add_Parameter(PL1_ID, 'PARAMFORM',TEXT_PARAMETER, 'NO');
Add_parameter(PL1_ID,'MAXIMIZE',TEXT_PARAMETER,'YES');
Add_Parameter(PL1_ID,'RPT_DTE',TEXT_PARAMETER,RPT_DATE_VALUE));
Run_Product(REPORTS,c:/XXX/ONE.RDF, SYNCHRONOUS, RUNTIME,FILESYSTEM, PL1_ID, NULL);
END;
|
|
|
Re: Running Report from Oracle Form [message #89467 is a reply to message #88174] |
Fri, 09 April 2004 06:39 |
ARSHAD
Messages: 5 Registered: April 2004
|
Junior Member |
|
|
HI THANKS FOR U CODE..
BUT I HAVE A FEW MISUNDERSTANDINGS ABOUT REPORTS PLEASE HELP ME IN ORDER TO NOTIFY IT.
IS IS BETTER APPROACH TO MADE PARAMETERS ON REPORTS OR OTHERWISE MADE IT SO THAT U MAKE IT.
PLEASE TELL ME THE DETAILED METHOD OF RUNNING
PARAMETRIZED REPORTS..
THANKS
KHAN
|
|
|