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!

Runnings reports with DESTYPE=Printer from Oracle Forms 10g question

outdoor25Feb 8 2010 — edited Feb 10 2010
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');
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 10 2010
Added on Feb 8 2010
3 comments
3,458 views