Home » Developer & Programmer » Forms » problem in RUN_PRODUCT
problem in RUN_PRODUCT [message #271162] Sun, 30 September 2007 05:16 Go to next message
alijeyan
Messages: 180
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 messageGo to next message
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
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


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


Current Time: Sat Dec 10 11:07:19 CST 2016

Total time taken to generate the page: 0.08692 seconds