6 Replies Latest reply: Sep 5, 2013 12:45 AM by 929107 RSS

    hide report path in oracle form 10g (10.1.2.0.2)

    Manoj Rajput

      Dear all,

       

      I m oracle form 10g (10.1.2.0.2) ,when i run report through form using paramform='yes' then parameter form open with path and userid/pass please

      help me how to hide this path

        • 1. Re: hide report path in oracle form 10g (10.1.2.0.2)
          usman_noshahi

          Hi Manoj,

          I m oracle form 10g (10.1.2.0.2) ,when i run report through form using paramform='yes' then parameter form open with path and userid/pass please

          help me how to hide this path

           

           

          means you are launching your report from a form ? using RUN_REPORT_OBJECT or something else ?

          if yes then you should use WEB.SHOW_DOCUMENT

           

          hope it works...

          • 2. Re: hide report path in oracle form 10g (10.1.2.0.2)
            Manoj Rajput

            Hi usman

               thanks for reply  ,I m using WEB.SHOW_DOCUMENT, but i m running report without AS

            using following code,

             

            v_pw:=get_application_property(password);
            v_user:=user;
            v_conn:=get_application_property(connect_string);
            lv_host:=:global.gv_ser_add;
            lv_sys_param:='&server='||:global.gv_ser_nm||'&DESTYPE=CACHE&DESFORMAT=PDF&mode=DEFAULT&PARAMFORM=yes';
            lv_path:='report=D:\test.rep';
             
            lv_usr_dtls:='&USERID='||v_user||'/'||v_pw||'@'||v_conn;
            lv_url:=lv_host||lv_path||lv_sys_param||lv_gen_param||lv_usr_dtls;
            lv_url:=replace(lv_url,' ',lv_url);
            --hidden_action := hidden_action ||'&USERID='||get_application_property(username)||'/'||v_pw;

            web.show_document(lv_url,'_blank');

             

            please suggest where i m doing wrong

             

            Thanks

            Manoj rajput

            • 3. Re: hide report path in oracle form 10g (10.1.2.0.2)
              Manoj Rajput

              Dear all,

              I m using WEB.SHOW_DOCUMENT, but i m running report without AS

              using following code,

               

              v_pw:=get_application_property(password);
              v_user:=user;
              v_conn:=get_application_property(connect_string);
              lv_host:=:global.gv_ser_add;
              lv_sys_param:='&server='||:global.gv_ser_nm||'&DESTYPE=CACHE&DESFORMAT=PDF&mode=DEFAULT&PARAMFORM=yes';
              lv_path:='report=D:\test.rep';
              lv_usr_dtls:='&USERID='||v_user||'/'||v_pw||'@'||v_conn;
              lv_url:=lv_host||lv_path||lv_sys_param||lv_gen_param||lv_usr_dtls;
              lv_url:=replace(lv_url,' ',lv_url);
              --hidden_action := hidden_action ||'&USERID='||get_application_property(username)||'/'||v_pw;

              web.show_document(lv_url,'_blank');

               

              please suggest where i m doing wrong

               

              Thanks

              Manoj rajput

               

              • 4. Re: hide report path in oracle form 10g (10.1.2.0.2)
                usman_noshahi

                ManojRajput wrote:

                 

                Dear all,

                I m using WEB.SHOW_DOCUMENT, but i m running report without AS

                 

                 

                what does it mean WITHOUT AS ,  please clear me this point  , arn't you using oracle Developer suit which contains forms and reports , using WEB.SHOW_DOCUMENT you can easily launch any report while hiding your all details ,

                 

                i am doubted about your technique....

                anyways use this way ...

                 

                1. attach your report to your form by expending report node in object navigator (what ever the format you use for your  report like jsp , rdf , rep).

                2. set parameters of attached report using property pallet . desformate , file , pdf e.t.c

                 

                then use this bellow code in any trigger you use for launching report...

                 

                v_rep := RUN_REPORT_OBJECT(<report_id>,<parameter list>); 
                
                --
                -- Call report in a web browser
                --
                -- IF rep_status='FINISHED' THEN
                  WEB.SHOW_DOCUMENT('http://'||:global.gv_ser_nm||'/reports/rwservlet/getjobid'|| 
                  substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=<yourReportServer>','_blank'); 
                

                 

                it requires no username and password authentication.

                hope it could help you...

                 

                thanks

                • 5. Re: hide report path in oracle form 10g (10.1.2.0.2)
                  rgvg

                  try editing your paper parameter form in reports designer.

                  that should allow you to pick which parameter fields to display in your parameter form.

                   

                  bye.