This is on 9iAS R1 patch15:
We are calling all out reports from forms.
We already have a number of forms that call reports that are using the
reports servlet. All the reports come out in pdf format. Basical there are a
number of set_report_object_property calls then a run_report_object call.
Additionally in the env file set by forms_web_cfg file we have a var of
FORMS60_REPFORMAT=pdf
We have been using the CGI report server to generate tab delimited files one
could bring into Excel. I'm having problems getting a different file other
than a pdf to be generated. I'm I stuck due to the FORMS60_REPFORMAT=pdf
var? How can I override this for a tab delimited file?
I think my problem is with the REPORT_DESTYPE
here is part of the code from the form (which does not work):
IF P_FOR_EXCEL = 'Y' THEN -- Generate Excel Sheet
l_rep_obj_id := find_report_object ( 'QMSREP' );
set_report_object_property(l_rep_obj_id, REPORT_DESTYPE, FILE);
set_report_object_property(l_rep_obj_id, REPORT_DESNAME, user ||
to_char(sysdate,'DDMMYYYYHH24MISS') || '.xls' );
set_report_object_property(l_rep_obj_id, REPORT_DESFORMAT, 'DELIMITED' );
set_report_object_property(l_rep_obj_id, REPORT_OTHER, ' DELIMITER=tab' || '
DELIMITED_HDR=no');
set_report_object_property(l_rep_obj_id, REPORT_EXECUTION_MODE, RUNTIME );
set_report_object_property(l_rep_obj_id, REPORT_COMM_MODE, SYNCHRONOUS );
set_report_object_property(l_rep_obj_id, REPORT_FILENAME, l_report_name );
-- qms$forms_errors.push ( 'Call_Report: Client/Server: Report and display
in Excel' );
l_rep_id := RUN_REPORT_OBJECT(l_rep_obj_id, l_par_list_id);
ELSE -- Generate PDF Report
l_rep_obj_id := find_report_object ( 'QMSREP' );
set_report_object_property(l_rep_obj_id, REPORT_EXECUTION_MODE, RUNTIME );
set_report_object_property(l_rep_obj_id, REPORT_COMM_MODE, SYNCHRONOUS );
set_report_object_property(l_rep_obj_id, REPORT_FILENAME, l_report_name );
set_report_object_property(l_rep_obj_id, REPORT_DESTYPE, PREVIEW);
l_rep_id := RUN_REPORT_OBJECT(l_rep_obj_id, l_par_list_id);
END IF;
My question is what do I need to do to generate tab delimited files using
the reports servlet without breaking the pdf's or changing the forms_web.cfg
file?
Thanks very much