By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,197 Members | 972 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,197 IT Pros & Developers. It's quick & easy.

trying to move from reports generated in CGI mode to reports generated in Servlet mode

P: n/a
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

Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.