| Run reports from menu [message #443252] |
Sun, 14 February 2010 02:32  |
elsy
Messages: 40
Registered: August 2006
Location: Kuwait
|
Member |
|
|
Dear All,
Recently i migrated all my forms and reports from 6i to 10.
I am able to run the reports in the web.
But when I am trying to run thru menu it give me error
Invalid report id -frm 41219
(I had already searched the forum for the same but i didnt get any valid answer. )
In the forum some says to add the report in the object navigator
The reports node is available for the forms only but not for the menus then how can i add the report????Can anyone help me
If i am wrong kindly correct me
Below is the code i am using in the menu
--------------------
----------------------
DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);
plid ParamList;
vParamValue number;
BEGIN
plid := Get_parameter_List('tmp');
IF NOT Id_Null(plid) THEN
Destroy_parameter_List( plid );
END IF;
plid :=Create_parameter_List('tmp');
add_parameter(plid,'BRID',text_parameter,to_char(:GLOBAL.BR_ID));
Add_parameter(plid, 'PARAMFORM', TEXT_parameter, 'NO');
repid := FIND_REPORT_OBJECT('TEST');
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_FILENAME, 'D:\MIGRATE10\TEST.REP');--add you are report name here with full path.
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,cache);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'repsrv');
v_rep := RUN_REPORT_OBJECT(repid,plid);
rep_status := REPORT_OBJECT_STATUS(v_rep);
WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')
LOOP
rep_status := report_object_status(v_rep);
END LOOP;
WEB.SHOW_DOCUMENT('http://TEST::8889/reports/rwservlet/getjobid'||substr(v_rep,instr(v_rep,'_',-1)+1)||'?
'||'server=repsrv&BRANCH='||:GLOBAL.BR_ID||'¶mform=no');
END;
------------------------
------------------------
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
