6 Replies Latest reply: Jan 29, 2013 3:52 AM by HamidHelal RSS

    CHARACTER MODE REPORT SHOWING ERRO WHILE USING TO CONVERT PDF OR HTML FILE?

    yash_08031983
      HELLO EXPERTS,
      Requirement: i want the output of report in 4 format
      text, excell,pdf and html.

      how to generate report in text format ?
      as we can not use the character mode report for pdf,html,htmlcss,spreadsheet or rtf and vice-versa.

      so if i want the output in hml,text,pdf and excel then how to manage the character mode file.
      can we change the mode of file dynamically or we have to maintain the other report.rdf file for generate the output
      in text format ?????


      Thanks
      yash
        • 1. Re: CHARACTER MODE REPORT SHOWING ERRO WHILE USING TO CONVERT PDF OR HTML FILE?
          HamidHelal
          yash_08031983 wrote:
          HELLO EXPERTS,
          Requirement: i want the output of report in 4 format
          text, excell,pdf and html.

          how to generate report in text format ?
          as we can not use the character mode report for pdf,html,htmlcss,spreadsheet or rtf and vice-versa.

          so if i want the output in hml,text,pdf and excel then how to manage the character mode file.
          can we change the mode of file dynamically or we have to maintain the other report.rdf file for generate the output
          in text format ?????
          Hi yash
          .........
          SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_EXECUTION_MODE, BATCH);
          SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_COMM_MODE, SYNCHRONOUS);
          SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_DESTYPE, cache);
          SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_DESFORMAT, 'PDF' );
          ......
          Look at the above code, Code are using when run report, if you use this to run report the out put will be PDF but it will able to generate also html,htmlcss,spreadsheet .
          For that you need to change PDF to other format like HTML etc.

          You can achieve this by send this value with variable.


          Hope this helps


          Hamid
          • 2. Re: CHARACTER MODE REPORT SHOWING ERRO WHILE USING TO CONVERT PDF OR HTML FILE?
            yash_08031983
            HI hAMID,

            but i also want to convert it in text form .
            if i set the report_desformat to 'txt' then showing error.


            iuse the below code:
            ----------for set property of report_object----------------------------------------------------------------------------
             DES_FILE_NAME := to_char(sysdate,'ddmmyy_hh24miss')||'.TXT';
                REPID := FIND_REPORT_OBJECT('RP2RRO');
                 set_report_object_property(repid,report_filename,FILE_NAME);
                 set_report_object_property(repid,report_server,REP_SERVER);
                 set_report_object_property(repid,report_execution_mode,BATCH);
                 set_report_object_property(repid,report_comm_mode,synchronous);
                 set_report_object_property(repid,report_destype,FILE);
                 SET_REPORT_OBJECT_PROPERTY(REPID,REPORT_DESNAME,'Z:\TEST\'||DES_FILE_NAME);
                 set_report_object_property(repid,report_desformat,'TXT'); 
            
            -----------------------------------------------------------------------------------------------------------------------------------------------------------
            create parameter
            -----------------------------------------------------------------------------------------------------------------------------------------------------------
            ----------------------------code for calling report---------------
            
            REPORT_SERVER_JOB := RUN_REPORT_OBJECT(REPID,PL_ID);
            REPORT_JOB_ID := SUBSTR(REPORT_SERVER_JOB,LENGTH(REP_SERVER)+2,LENGTH(REPORT_SERVER_JOB));
            REPORT_STATUS := REPORT_OBJECT_STATUS(REPORT_SERVER_JOB);
            
            IF REPORT_STATUS ='FINISHED' THEN
            WEB.SHOW_DOCUMENT('http://'||'192.168.1.216'||'/test/'||DES_FILE_NAME,'_BLANK');
            ELSE
                 message ('error when running report'||REPORT_STATUS);
            end if;
            
            ---------------------------------------------------------------------------------------------------------------------------------------------------------------
            ERROR: REPORT_TERMINATED_WITH_ERROR.
            Thanks
            yash
            • 3. Re: CHARACTER MODE REPORT SHOWING ERRO WHILE USING TO CONVERT PDF OR HTML FILE?
              HamidHelal
              set_report_object_property(repid,report_desformat,'TXT');
              Hi,
              Use
              set_report_object_property(repid,report_desformat,'RTF');
              or
              set_report_object_property(repid,report_desformat,'DELIMITED');
              Hope this works..

              Mark correct/helpful to help others to get right answer(s).*
              • 4. Re: CHARACTER MODE REPORT SHOWING ERRO WHILE USING TO CONVERT PDF OR HTML FILE?
                yash_08031983
                I USED THE
                set_report_object_property(repid,report_desformat,'RTF');
                • 5. Re: CHARACTER MODE REPORT SHOWING ERRO WHILE USING TO CONVERT PDF OR HTML FILE?
                  yash_08031983
                  I USED THE
                  set_report_object_property(repid,report_desformat,'RTF');
                  BUT txt file content is not like the report output.
                  i also try the delimited. output come me delimited formate. but my requirement if convert that rdf file output to text file in which,

                  heading, field titles etc will just like pdf format or html format.


                  thank
                  yash
                  • 6. Re: CHARACTER MODE REPORT SHOWING ERRO WHILE USING TO CONVERT PDF OR HTML FILE?
                    HamidHelal
                    Sorry,

                    I don't know more..
                    Just one thing. Check this http://www.lv2000.com/re/repexpert.htm


                    Hamid