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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
