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

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Oxmard

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

    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_obje ct_property calls then a run_report_obje ct call.
    Additionally in the env file set by forms_web_cfg file we have a var of
    FORMS60_REPFORM AT=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_REPFORM AT=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_obj ect ( 'QMSREP' );

    set_report_obje ct_property(l_r ep_obj_id, REPORT_DESTYPE, FILE);
    set_report_obje ct_property(l_r ep_obj_id, REPORT_DESNAME, user ||
    to_char(sysdate ,'DDMMYYYYHH24M ISS') || '.xls' );

    set_report_obje ct_property(l_r ep_obj_id, REPORT_DESFORMA T, 'DELIMITED' );
    set_report_obje ct_property(l_r ep_obj_id, REPORT_OTHER, ' DELIMITER=tab' || '
    DELIMITED_HDR=n o');

    set_report_obje ct_property(l_r ep_obj_id, REPORT_EXECUTIO N_MODE, RUNTIME );
    set_report_obje ct_property(l_r ep_obj_id, REPORT_COMM_MOD E, SYNCHRONOUS );
    set_report_obje ct_property(l_r ep_obj_id, REPORT_FILENAME , l_report_name );

    -- qms$forms_error s.push ( 'Call_Report: Client/Server: Report and display
    in Excel' );
    l_rep_id := RUN_REPORT_OBJE CT(l_rep_obj_id , l_par_list_id);

    ELSE -- Generate PDF Report
    l_rep_obj_id := find_report_obj ect ( 'QMSREP' );

    set_report_obje ct_property(l_r ep_obj_id, REPORT_EXECUTIO N_MODE, RUNTIME );
    set_report_obje ct_property(l_r ep_obj_id, REPORT_COMM_MOD E, SYNCHRONOUS );
    set_report_obje ct_property(l_r ep_obj_id, REPORT_FILENAME , l_report_name );
    set_report_obje ct_property(l_r ep_obj_id, REPORT_DESTYPE, PREVIEW);

    l_rep_id := RUN_REPORT_OBJE CT(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



Working...