| calling report from form [message #348924] |
Thu, 18 September 2008 05:42  |
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
|
Senior Member |
|
|
hi martin
i call report from form to write this coding.until today morning it works well .Suddenly report is not opened.No error message displayed.send solution urgently.
Declare
repid REPORT_OBJECT;
v_rep VARCHAR2(1000);
rep_status VARCHAR2(20);
BEGIN
repid := find_report_object('REPORT21');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH);
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,'rserver');
v_rep := RUN_REPORT_OBJECT(repid);
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;
IF rep_status = 'FINISHED' THEN
/*Display report in the browser*/
WEB.SHOW_DOCUMENT('http://it-2c162956cad3:8889/reports/rwservlet/getjobid' ||
substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=rserver','_blank');
ELSE
message('Error when running report');
END IF;
END;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: calling report from form [message #349461 is a reply to message #349441] |
Sun, 21 September 2008 23:43  |
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
|
Senior Member |
|
|
sir
I removed the Run_report_object.But report did not open.Already I was sending the code.kindly what are the lines i should remove.
Please notedown.
Regards
Vishu
|
|
|
|
|
|
| Re: calling report from form [message #362440 is a reply to message #348924] |
Tue, 02 December 2008 05:25 |
randritsy
Messages: 20
Registered: June 2007
Location: Dago
|
Junior Member |
|
|
i'm calling report from form and using web.show_document and destype=cache, but we feel that this create a network traffic trouble by using this destype "cache", the server cache can't support we think!. I'd like to use another type of destype like destype=file but it's occured only successfull operation if i executed the command but nothing appeared (report).
Is anyone can help me to use web.show_document with another type destype.
[Updated on: Tue, 02 December 2008 05:29] Report message to a moderator |
|
|
|
|
|
| Re: calling report from form [message #362756 is a reply to message #362722] |
Thu, 04 December 2008 01:22 |
randritsy
Messages: 20
Registered: June 2007
Location: Dago
|
Junior Member |
|
|
yes, i did but, it's appeared only operation successfull. Nothing happen no report showed. In that's way i ask how make the report showed using another destype values.
Thanks.
Tsil
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
