Home » Developer & Programmer » Forms » problem in RUN_PRODUCT
problem in RUN_PRODUCT [message #271162] |
Sun, 30 September 2007 05:16 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
alijeyan
Messages: 184 Registered: January 2007 Location: IRAN
|
Senior Member |
|
|
Hi All
I want run a report with folowing parameters :
DESTYPE = FILE ,
DESNAME ='C:\TEMP\MYREP.HTM'
DESFORMAT = HTML
I USE A bUTTON AND WRITE THESE CODE :
--------------------------------------------------
Declare
list_id ParamList;
Begin
list_id := Create_Parameter_List('input_params');
Add_Parameter(list_id, 'DESTYPE',TEXT_PARAMETER,'FILE');
Add_Parameter(list_id, 'DESFORMAT',TEXT_PARAMETER,'HTML');
Add_Parameter (LIist_id, 'DESNAME',TEXT_PARAMETER,'C:\TEMP\MYREP.HTM');
v_cmd_rwrun := 'T:\CHAH\REPORTS\COD1.rEP ';
RUN_PRODUCT(REPORTS, V_CMD_RWRUN, SYNCHRONOUS, BATCH, FILESYSTEM, LIST_ID, NULL);
End;
------------------------------------------
WHEN I PRESS BUTTON MY REPORT NOT RUN BUT WHEN I USE
RUN_PRODUCT(REPORTS, V_CMD_RWRUN, SYNCHRONOUS, BATCH, FILESYSTEM, NULL, NULL);
REPORT RUN .
PLEASE HELP ME !!
ThanQ ALI JEYAN
|
|
|
Re: problem in RUN_PRODUCT [message #271170 is a reply to message #271162] |
Sun, 30 September 2007 06:55 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
hemavb
Messages: 103 Registered: May 2007 Location: Dubai , UAE
|
Senior Member |
|
|
RUN_PRODUCT(REPORTS, V_CMD_RWRUN, SYNCHRONOUS, BATCH, FILESYSTEM, LIST_ID, NULL);
instead of that try...
RUN_PRODUCT(REPORTS,
V_CMD_RWRUN,
ASYNCHRONOUS,
RUNTIME,
FILESYSTEM,
LIST_ID,
NULL);
You need synchronous only when you are passng a data parameter or you want the user's form to be held up till the report is open.
|
|
|
Re: problem in RUN_PRODUCT [message #515357 is a reply to message #271170] |
Mon, 11 July 2011 01:38 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
mfa786
Messages: 210 Registered: February 2006 Location: karachi
|
Senior Member |
|
|
sir
see my code in button press event
-----
Declare
list_id ParamList;
Begin
list_id := Create_Parameter_List('input_params');
Add_Parameter(list_id, 'DESTYPE',TEXT_PARAMETER,'FILE');
Add_Parameter(list_id, 'DESFORMAT',TEXT_PARAMETER,'HTML');
Add_Parameter (List_id, 'DESNAME',TEXT_PARAMETER,'C:\MYREP.HTM');
--v_cmd_rwrun := 'd:\mfawork\aamirtesthtml';
RUN_PRODUCT(REPORTS,'d:\mfawork\aamirtesthtml', ASYNCHRONOUS, RUNTIME, FILESYSTEM, LIST_ID, NULL);
--RUN_PRODUCT(REPORTS,'aamirtesthtml', ASYNCHRONOUS,RUNTIME,FILESYSTEM, LIST_ID, NULL);
:tt := 'fahimmmm';
Destroy_Parameter_List( list_id );
--RUN_PRODUCT(REPORTS,V_CMD_RWRUN, ASYNCHRONOUS,RUNTIME,FILESYSTEM, LIST_ID, NULL);
--RUN_PRODUCT(REPORTS, V_CMD_RWRUN, SYNCHRONOUS, BATCH, FILESYSTEM, LIST_ID, NULL);
End;
----------
but no error, no resutl and report browser not open report
please give me idea
Regard
fahim
|
|
|
Goto Forum:
Current Time: Tue Sep 10 08:49:33 CDT 2024
|