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;
--• Business Solutions: --• Enterprise ERP, Database Management & IT Infrastructure --• AI, Cloud
Subscribe to:
Post Comments (Atom)
https://www.linkedin.com/pulse/building-real-time-database-monitoring-dashboard-oracle-khaleeq-tpwxf/
-
# Report Column (only column): 1. Column Formatting > HTML Expression <span style="display:block; width: 200px"> #...
-
when open forms builder then errors FRM-91129: fatal error: no value specified for required environment variable FORMS_BUILDER_CLASSPATH a...
-
Installing Oracle Forms and Reports 12c on Windows 10 64 Bit. Hardware used for this installation is · Intel i3-2370M CPU · ...
-
I wanted to share a little trick I’ve used in APEX for a while now to conditionally format report columns based on their values. I’m sure th...
No comments:
Post a Comment