Report 10g output in excel problem [message #558859] |
Wed, 27 June 2012 00:26 |
sweetkhaliq
Messages: 200 Registered: April 2006
|
Senior Member |
|
|
Dear Members,
I am using forms 10.1.2.0.2. I am calling the report from Forms parameter. I have passed the report_desformat=SPREADSHEET. But when i run the report it shows nothing and no out put is generated.
Please help me to find out the problem.
Parameter forms code is as under.
PROCEDURE rep_call (p_rep in char, p_param in paramlist) IS
report_id report_object;
mJob_ID varchar2(200);
mRep_Status varchar2(200);
mReportServer varchar2(100) := 'REP_SERVER';
mReportServerJob varchar2(200);
x varchar2(200);
BEGIN
report_id := find_report_object(p_rep);
set_report_object_property(report_id, report_execution_mode, runtime );
set_report_object_property(report_id, report_comm_mode, synchronous );
set_report_object_property(report_id, report_destype,cache);
set_report_object_property(report_id, report_desformat, 'SPREADSHEET' );
set_report_object_property(report_id, report_server, mReportServer);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_OTHER,'paramform=no');
mReportServerJob := run_report_object(report_id,p_param);
mJob_id := substr(mReportServerJob, length(mReportServer) + 2, length(mReportServerJob));
mRep_Status := report_object_status(mReportServerJob);
WHILE Mrep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')
LOOP
mrep_status := report_object_status(mReportServerJob);
END LOOP;
if mRep_status = 'FINISHED' then
x := '/reports/rwservlet/getjobid' || mJob_id
web.show_document (x, '_blank');
else
message('report failed with error message ' || mRep_status);
end if;
END;
Thanks & Regards
|
|
|
|
Re: Report 10g output in excel problem [message #558870 is a reply to message #558862] |
Wed, 27 June 2012 01:03 |
sweetkhaliq
Messages: 200 Registered: April 2006
|
Senior Member |
|
|
Thanks littlefoot,
Next time i will keep in mind to use the format code.
When i used report_desformat='PDF' then it show output. But when i used report_desformat='SPREADSHEET' then it did not show the output.
Now i have used this code
PROCEDURE rep_call(p_rep in char, p_param in paramlist) IS
report_id report_object;
mJob_ID varchar2(200);
mRep_Status varchar2(200);
mReportServer varchar2(100) := 'REP_SERVER';
mReportServerJob varchar2(200);
x varchar2(200);
BEGIN
report_id := find_report_object(p_rep);
set_report_object_property(report_id, report_execution_mode, runtime);
set_report_object_property(report_id, report_comm_mode, synchronous);
set_report_object_property(report_id, report_destype, cache);
set_report_object_property(report_id, report_desformat, 'PDF');
set_report_object_property(report_id, report_server, mReportServer);
SET_REPORT_OBJECT_PROPERTY(report_id, REPORT_OTHER, 'paramform=no');
mReportServerJob := run_report_object(report_id, p_param);
mJob_id := substr(mReportServerJob,
length(mReportServer) + 2,
length(mReportServerJob));
mRep_Status := report_object_status(mReportServerJob);
WHILE Mrep_status in ('RUNNING', 'OPENING_REPORT', 'ENQUEUED') LOOP
mrep_status := report_object_status(mReportServerJob);
END LOOP;
if mRep_status = 'FINISHED' then
x := '/reports/rwservlet/getjobid' || mJob_id
web.show_document(x, '_blank');
else
message('report failed with error message ' || mRep_status);
end if;
END;
Please help me to find the problem.
Thanks & Regards.
|
|
|
|
|
|
|
|