Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Copy file from report cache

405862Mar 31 2005 — edited Mar 31 2005
i am using 9ids.
my purpose is to get character mode report printing from
user-end.

now one way i thought to design report in character mode
and give printing directly by using

web.show_document('/reports/rwservlet'||'?
server='||vc_reportserver||'&destype='||vc_destype||'&desname='||vc_desname||'&'||con_url||'&report=c:\makess\hrpay\reports\sal_reg_dept.rdf'||'&comp_code='||:global.vc_comp_code||'&catg='||catg||'&dept='||dept||'&emp_code='||emp||'&locat='||:list_loc||'&month='||mth||'&year='||yr||'¬e='||note||'¬e1='||note1||'&FORM_WB=1001' ,'_blank');

where
vc_destype:='printer'; vc_desname:='\\neeraj\epson';

but here this report can be given in one printer only.

and if i make destype=cache
character mode report format gets little-bit changed
and it does not give draft printing.

now one option left is to run report in character mode
and copy that file to user-end from
server/report/cache.

say for run report i use

set_report_object_property (rep_id,REPORT_EXECUTION_MODE,BATCH);
set_report_object_property(rep_id,REPORT_COMM_MODE,SYNCHRONOUS);
set_report_object_property(rep_id,REPORT_DESTYPE,CACHE);
set_report_object_property(rep_id,REPORT_DESFORMAT,vc_runformat);
set_report_object_property(rep_id,REPORT_SERVER,vc_reportserver);
set_report_object_property(rep_id,REPORT_OTHER,'comp_code="'||:global.vc_comp_code||'" catg="'||catg||'" dept="'||dept||'" emp_code="'||emp||'" locat="'||:list_loc||'" month="'||mth||'" year="'||yr||'" note="'||note||'" note1="'||note1||'" Paramform=no');
vc_reportserverjob:=RUN_Report_Object(rep_id);
vjob_id:=substr(vc_reportserverjob,length(vc_reportserver)+2,length(vc_reportserverjob));
vc_rep_status :=REPORT_OBJECT_STATUS(vc_reportserverjob);

now report has run.
please guide me further how to get file name from report/cache.
and download into user-end.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 28 2005
Added on Mar 31 2005
1 comment
258 views