1 Reply Latest reply: Nov 7, 2013 9:39 AM by RJG RSS

    WEB.SHOW_DOCUMENT . Publish reports character mode directly within browser!

    RJG

      hello!

      I'm having the problem.

      When I want to publish reports character mode directly within browser!

      The code is as follows!

      SET_REPORT_OBJECT_PROPERTY(repid, REPORT_EXECUTION_MODE, RUNTIME);
        SET_REPORT_OBJECT_PROPERTY(repid, REPORT_COMM_MODE, SYNCHRONOUS);
        SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESTYPE,  FILE);
        SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESFORMAT, '');
        SET_REPORT_OBJECT_PROPERTY(repid, REPORT_SERVER, server );
        v_rep := RUN_REPORT_OBJECT(reportFile,mparamlist_id);
        rep_status := REPORT_OBJECT_STATUS(v_rep);
           if rep_status = 'FINISHED' then
              vjob_id :=substr(v_rep,length(server)+2,length(v_rep)); 
        WEB.SHOW_DOCUMENT('../reports/rwservlet/getjobid'||vjob_id||'?server='||server,'_blank');
           else
        message('Fail to create Report!');
           end if;
      

       

      The report is generated,

      But it does not open directly in browser!
      The browser will download a file without extension / format, with the name 'getjobid38'!

      When I change the code to 'TXT'

      WEB.SHOW_DOCUMENT('../reports/rwservlet/getjobid'||vjob_id||'.txt?server='||servidor,'_blank');
      

       

      The following error is returned:

      rep-50003 the command line is invalid: getjobid38.txt

      Already grateful!