Copy file from report cache
405862Mar 31 2005 — edited Mar 31 2005i 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.