1 2 Previous Next 15 Replies Latest reply: Nov 27, 2008 2:52 AM by Tarun.Oracle RSS

    Printing report oracle10g at client side through form

    Tarun.Oracle
      Report Mode : CHARACTER.


      I am running report through oracle10g from in browser based environment from client machine.
      My application server running that form. My code is following for setting the report destination type:


      IF :B01.S_REPORT_TO = 'S' THEN
      SET_REPORT_OBJECT_PROPERTY(REP_ID,REPORT_DESTYPE,CACHE);
      ELSIF :B01.S_REPORT_TO = 'P' THEN
      SET_REPORT_OBJECT_PROPERTY(REP_ID,REPORT_DESTYPE,PRINTER);
      ELSIF :B01.S_REPORT_TO = 'F' THEN
           SET_REPORT_OBJECT_PROPERTY(REP_ID,REPORT_DESTYPE,FILE);
      SET_REPORT_OBJECT_PROPERTY(REP_ID,REPORT_DESNAME,'c:\temp\abc.txt');
      END IF;

      vrep := RUN_REPORT_OBJECT (vrepid,PRAM_ID);
      web.show_document( 'http://servername:port/reports/rwservlet/getjobid'||
      SUBSTR (vrep, INSTR (vrep, '_', -1) + 1)|| '?'|| 'server=REPserver','_blank');

      But when i am using destype as print , the report output is directed to Application Server's printer and not in clinet computer's printer. as well as detination type is file , then specified file is stored in Application Server and not in client machine.

      HOW CAN I PRINT REPORT DIRECTLY AT DEFAULT PRINTER OF CLIENT COMPUTER OR SAVE THE FILE AT CLIENT COMPUTER'S HARDDISK
        1 2 Previous Next