This discussion is archived
6 Replies Latest reply: Jan 29, 2013 1:52 AM by HamidHelal RSS

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

yash_08031983 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    Sorry,

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


    Hamid

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points