Runnings reports with DESTYPE=Printer from Oracle Forms 10g question
I've got a question.
Is there a specific set of commands you have to use in order to send Oracle Reports commands across to the Reports Server when sending DESTYPE=printer and DESNAME=printer_name . When I send a report across with NO parameters, the reports generate just fine and run. When I run a report with one or more parameters attached to the report, it doesn't run at all so it makes me think that I've put something in the wrong order.
I am able to generate PDF with the below commands. The only difference is that I am changing the DESTYPE and DESNAME.
I send my parameters across in the SET_REPORT_OBJECT_PROPERTY(REPORTS_OTHER, variable) path. vParameters is the value where I build my parameter list (i.e. p_Department = '-99'
Any help is appreciated.
Chris
V_OTHER := 'PARAMFORM=NO READONLY=YES authid='||user||' BATCH=YES';
V_OTHER := V_OTHER||' PAGESIZE='||vPaper;
V_OTHER := V_OTHER||' ORIENTATION='||vOrientation;
V_OTHER := V_OTHER||' DELIMITER='||V_DELIM;
V_OTHER := V_OTHER ||' '||vParameters;
SET_REPORT_OBJECT_PROPERTY('GENERICREPORT', REPORT_FILENAME, LOWER(:MODULE.MODULE_NAME)||'.rep');
SET_REPORT_OBJECT_PROPERTY('GENERICREPORT', REPORT_SERVER, 'rep_inxx37_ybs');
SET_REPORT_OBJECT_PROPERTY('GENERICREPORT', REPORT_OTHER, V_OTHER);
SET_REPORT_OBJECT_PROPERTY('GENERICREPORT', REPORT_DESTYPE, CACHE);
SET_REPORT_OBJECT_PROPERTY('GENERICREPORT', REPORT_DESFORMAT, 'PDF');
SET_REPORT_OBJECT_PROPERTY('GENERICREPORT', REPORT_DESNAME, LOWER(:MODULE.MODULE_NAME)||TO_CHAR(SYSDATE,'YYYYMMDDHHMISS'));
V_REP := RUN_REPORT_OBJECT('GENERICREPORT');
V_GET := 'http://test.website.bh-int:7777/reports/rwservlet/getjobid'||substr(v_rep, instr(v_rep, '_', -1, 1)+1)||
'?server='||substr(v_rep, 1, instr(v_rep, '_', -1, 1)-1);
WEB.SHOW_DOCUMENT(V_GET, '_BLANK');