Link to home
Start Free TrialLog in
Avatar of chandrasekhar_m
chandrasekhar_m

asked on

Oracle Forms 10g(10gDeveloper)the client requirement "PRINT THE REPORT WITHOUT PREVIEW..from FORMS" they don't want to see the out put on browser

Oracle Forms 10g(10gDeveloper)the client requirement "PRINT THE REPORT WITHOUT PREVIEW..from FORMS" they don't want to see the out put on browser they just want prints outs. i.e. i am running reports from forms it'sworking but the clients require without preview it should print to thier 'userprofile'printer. currently i have used below code 'WEB.SHOW_DOCUMENT' it's working fine and even display in browser but "NO" print out, and NO ERRORS..is there a way wecan fix this please.i have tried "destype=printer" but no use

WEB.SHOW_DOCUMENT('http://localhost:8890/reports/rwservlet?cmdkey=adkey&report=C:\Chandra\Forms\EMP.rdf&host=//w2kprnsrv/KONICA-F13','_SELF');
before-print.JPG
SOLUTION
Avatar of Helena Marková
Helena Marková
Flag of Slovakia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of chandrasekhar_m
chandrasekhar_m

ASKER

thanks henka, i have managed to print out the report with web.showdocument, but the browser is still there saying 'report run successfully' the print out is coming but i want the browser close as soon as i print or run the report ..any built in or any other way around please

cheers
sekhar
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial

/*******************************************
   Last Code modified by the Sekhar
   31-Aug-2008 12:48 PM
 *******************************************/
PROCEDURE print_report (i_report in varchar2, i_param_form in varchar2) is
  pl_id ParamList;
  a varchar2(40);
  begin
  pl_id := get_parameter_list('repdata');
  if not id_null(pl_id) then
  destroy_parameter_list(pl_id);
  end if;
  pl_id := create_parameter_list('repdata');
 add_parameter(pl_id,'pdn_number',TEXT_PARAMETER,:b1.despatch_id);

if i_param_form = 'YES' then
add_parameter(pl_id,'PARAMFORM',TEXT_PARAMETER,'YES');
web.show_document('http://it-cons.adnoc-dist.co.ae:8889/reports/rwservlet?userid=sales/sale@addev&desformat=PDF&destype=printer&printjob=yes¶mform=yes&desname=\\w2kprnsrv\KONICA-F13&report=\\it-cons.adnoc-dist.co.ae\c$\Chandra\Forms\'||i_report||'.rdf'||'&pdn_number='||:b1.despatch_id,'_BLANK');
-- CURRENT web.show_document('http://it-cons.adnoc-dist.co.ae:8889/reports/rwservlet?userid=sales/sale@addev&desformat=PDF&destype=printer&desname=\\w2kprnsrv\KONICA-F13&report=\\it-cons.adnoc-dist.co.ae\c$\Chandra\Forms\saw523-NEW.rdf'||'&pdn_number='||:b1.despatch_id,'_BLANK');
else
-- CURRENT web.show_document('http://it-cons.adnoc-dist.co.ae:8889/reports/rwservlet?userid=sales/sale@addev&desformat=PDF&destype=printer&desname=\\w2kprnsrv\KONICA-F13&report=\\it-cons.adnoc-dist.co.ae\c$\Chandra\Forms\saw523-NEW.rdf'||'&pdn_number='||:b1.despatch_id,'_BLANK');
web.show_document('http://it-cons.adnoc-dist.co.ae:8889/reports/rwservlet?userid=sales/sale@addev&desformat=PDF&destype=printer&desname=\\w2kprnsrv\KONICA-F13&report=\\it-cons.adnoc-dist.co.ae\c$\Chandra\Forms\'||i_report||'.rdf'||'&pdn_number='||:b1.despatch_id,'_BLANK');
--web.show_document('close.html','_self');
--web.show_document('\\it-cons.adnoc-dist.co.ae\c$\Chandra\Forms\close.html','_self');
end if;
END;