From: shankeyp@no-spam.comcast.net   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)