PROCEDURE PRINT_PROC_url IS
v_rep VARCHAR2(1000);
rep_url varchar2(2000);
v_Params varchar2(2000);
v_Params1 varchar2(2000);
v_userid varchar2(1000):='jayson/jsn@orcl';
v_host varchar2(1000):='localhost:9002'; --:global.IP;
v_path_int varchar2(1000):='E:\JAYSON\'; --:GLOBAL.MENU_PATH;
v_path varchar2(1000);
v_desformat varchar2(1000);
BEGIN
v_desformat:='pdf'; --spreadsheet
v_Params:= '&P_DT1='||:JNPBD_STN_MAST.DT1
||'&P_DT2='||:JNPBD_STN_MAST.DT2
||'&P_PRODUCT_CD='||:JNPBD_STN_MAST.PRODUCT_CD
||'&P_ITEM_CD='||:JNPBD_STN_MAST.ITEM_CD;
if :JNPBD_STN_MAST.REPOT_LIST=1 then
v_path:=''||v_path_int||'JNPBD\Reports\jnpbd_list_of_mps.rdf';
elsif :REPOT_LIST=2 then
v_path:=''||v_path_int||'JNPBD\Reports\jnpbd_list_of_wbs.rdf';
elsif :REPOT_LIST=3 then
v_path:=''||v_path_int||'JNPBD\Reports\jnpbd_material_used_for_product.rdf';
elsif :REPOT_LIST=4 then
v_path:=''||v_path_int||'JNPBD\Reports\jnpbd_list_of_mfg_bd_dt.rdf';
elsif :REPOT_LIST=5 then
v_path:=''||v_path_int||'JNPBD\Reports\jnpbd_list_of_mfg_bd_dt_code.rdf';
elsif :REPOT_LIST=6 then
v_path:=''||v_path_int||'JNPBD\Reports\jnpbd_list_of_mfg_bd_dt_name.rdf';
elsif :REPOT_LIST=7 then
v_path:=''||v_path_int||'JNPBD\Reports\jnpbd_list_of_mfg_comp_uncomp.rdf';
elsif :REPOT_LIST=8 then
v_path:=''||v_path_int||'JNPBD\Reports\jnpbd_charge_recons1.rdf';
elsif :REPOT_LIST=9 then
v_path:=''||v_path_int||'JNPBD\Reports\jnpbd_list_of_product.rdf';
elsif :REPOT_LIST=10 then
v_path:=''||v_path_int||'JNPBD\Reports\jnpbd_list_of_item.rdf';
elsif :REPOT_LIST=11 then
v_path:=''||v_path_int||'JNPBD\Reports\jnpbd_Product_group_list.rdf';
elsif :REPOT_LIST=12 then
v_path:=''||v_path_int||'JNPBD\Reports\jnpbd_material_type_list.rdf';
elsif :REPOT_LIST=13 then
v_path:=''||v_path_int||'JNPBD\Reports\jnpbd_material_group_list.rdf';
elsif :REPOT_LIST=14 then
v_path:=''||v_path_int||'JNPBD\Reports\jnpbd_sbd_list.rdf';
elsif :REPOT_LIST=15 then
v_path:=''||v_path_int||'JNPBD\Reports\jnpbd_charge_cal_list.rdf';
end if;
rep_url:='http://'||v_host||'/reports/rwservlet?userid='||v_userid||'&report='||v_path||''
||'&desformat='||v_desformat||'&destype=cache'
||''||v_Params||'¶mform=no';
/*
rep_url:='http://'||v_host||'/reports/rwservlet?userid='||v_userid||'&report='||v_path||''
||'&desformat='||v_desformat||'&destype=cache'||''||v_Params||'¶mform=no';
--ok above
rep_url:='http://'||v_host||'/reports/rwservlet?userid='||v_userid||'&report='||v_path||''
||'&desformat='||v_desformat||'&destype=cache'
||'&v_Params¶mform=no';
rep_url:='http://'||v_host||'/reports/rwservlet?userid='||v_userid||'&report='||v_path||''
||'&desformat='||v_desformat||'&destype=cache'
||'&v_Params¶mform=no';
*/
WEB.SHOW_DOCUMENT(rep_url,'_blank');
EXCEPTION
WHEN OTHERS THEN
MESSAGE('Error, Contact your administrator');
END;
Md. Quium Hossain who I'm Oracle DBA & APEX Developer. All-rounder in building small, medium, and enterprise applications. Extensive knowledge in various areas of web-driven applications in Back-end (PL/SQL, SQL, Java), Front-end (Oracle APEX, Oracle Forms, Oracle Reports, HTML, JavaScript, CSS, jQuery, OracleJET, ReactJS), RESTful APIs, Third-party library integrations (Apex Office Print (AOP), Payment Gateways, SMS, Syncfusion, HighCharts) and APEX Plugins (HighChart, StarRating)
Subscribe to:
Post Comments (Atom)
How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10
#########################Install Oracle APEX 24.1################################ ----------------------------------------------------...
-
# Report Column (only column): 1. Column Formatting > HTML Expression <span style="display:block; width: 200px"> #...
-
Installing Oracle Forms and Reports 12c on Windows 10 64 Bit. Hardware used for this installation is · Intel i3-2370M CPU · ...
-
when open forms builder then errors FRM-91129: fatal error: no value specified for required environment variable FORMS_BUILDER_CLASSPATH a...
-
---------------------------- | Keyboard Shortcut | ---------------------------- · Create: Breadcrumb Region Ctrl+/, C, B · ...
No comments:
Post a Comment