orarrp question

From: grace lim <mglim_at_softhome.net>
Date: Mon, 26 Feb 2001 16:54:37 -0800
Message-ID: <F001.002BDDA6.20010226164027@fatcity.com>

gurus,

i want my users to print their report directly to their printer rather than to the server.

so i've installed orarrp.exe in my computer and updated the nt web application server 6iserver.conf to include application/x-orarrp rrpp rrpa rrpr rrpt rrpi .

 to test if it's working , a form is created that will call an oracle report and specifies that it shld be output to file w/ file extension rtf. This sample is the same as the one in the technet. the form has a push button to start the report and create a timer to monitor its progress...when i run the form nothing happens...

grace.rdf is tested working for client server and web. Is there something wrong in my code?
pls help...

here's thecode In when button pressed trigger,

declare
report_id report_object;
htimer timer;
vcfile varchar2(255);
vcresult varchar2(20);

BEGIN
        --call_form('GETARGUS');
break;
vcfile := 'test.rrpr'; -- rich text format report_id := find_report_object('c:\suysing\grace.rdf'); -- path where the grace.rdf report can be found in web app. server

set_report_object_property(report_id,report_execution_mode,batch);
set_report_object_property(report_id,report_destype,file);
set_report_object_property(report_id,report_desformat,'rtf' );
set_report_object_property(report_id,report_desname,'c:\app\'||vcfile);
set_report_object_property(report_id,report_server,'Rep60_Web');

:global.reporthandle := run_report_object(report_id);
:global.printoutpurt := vcfile;

htimer := create_timer('Printer_Queue','15000',repeat); end;

In when timer expired ( form trigger);

declare
  vcstatus varchar2(20);
 vctimername varchar2(30);
 htimer timer;                 

begin

   vctimername := get_application_property(timer_name);   if vctimername = 'PRINTER_QUEUE' then

     vcstatus := report_object_status(:global.reporthandle);
     if vcstatus in ('RUNNING','OPENING_REPORT','ENQUEUED') then
        null;
     elsif  vcstatus = 'FINISHED' then
           web.show_document('http://web/app/'||:global.printoutput,'_blank');
           delete_timer(vctimername);
     else
        message('report fialed');
       delete_timer(vctimername);

    end if;
 end if;
end;  

Best regards,
Grace Lim
Suy Sing Comm'l Corp.
(063)-02-247-41-34

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: grace lim
  INET: mglim_at_softhome.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Feb 26 2001 - 18:54:37 CST