OraFAQ Forum: Forms » problem in RUN

Home » Developer & Programmer » Forms » problem in RUN_PRODUCT

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

problem in RUN_PRODUCT [message #271162]

Sun, 30 September 2007 05:16

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

Report message to a moderator

Re: problem in RUN_PRODUCT [message #271170 is a reply to message #271162]

Sun, 30 September 2007 06:55

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.

Report message to a moderator

Re: problem in RUN_PRODUCT [message #515357 is a reply to message #271170]

Mon, 11 July 2011 01:38

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

Report message to a moderator

Previous Topic:	Error getting group cell
Next Topic:	Reg . Migration

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 23:16:47 CST 2025