Home » Developer & Programmer » Forms » Run reports from menu (Oracle 10 G)
Run reports from menu [message #443252] Sun, 14 February 2010 02:32 Go to next message
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||'&paramform=no');



END;



------------------------
------------------------


Re: Run reports from menu [message #443259 is a reply to message #443252] Sun, 14 February 2010 05:59 Go to previous message
elsy
Messages: 40
Registered: August 2006
Location: Kuwait
Member

Open the form where u attach the menu

In the reports node add the existing report
compile

then run

Problem Solved
Previous Topic: DBA_ROLE_PRIVS
Next Topic: Maximizing Applet In Froms 10g
Goto Forum:
  


Current Time: Mon Dec 05 08:47:03 CST 2016

Total time taken to generate the page: 0.26425 seconds