5 Replies Latest reply: Jan 7, 2013 5:41 AM by Alok Dubey RSS

    Web.show_document for All Records (%).

      Hi all,

      I m using form 11gr2, and calling report from form with a built-in Web.show_document as follow:

      v_show_document := v_show_document
      || v_connect
      || '+server='
      || v_report_server
      || '+report='||:parameter.repname
      || '+destype=CACHE'
      || '+desformat='||v_format
      || '+paramform=no'
      || '+select1='||:mainblock.SELECT1
      || '+fromdate='||TO_CHAR(:FROMDATE,'DD-MM-RRRR')
      || '+todate='||TO_CHAR(:TODATE,'DD-MM-RRRR');


      It run the report successfully.

      But a problem arises when I change one of parameters defined in above built-in i.e. select1=% , for all records, i.e.
      when I make parameter select1 equivalent to *% (which is meant for all records)*. That is when I set parameter for all records=%, it shows following error:

      REP-52006: The specified URL % cannot be decoded

      i.e. when I set parameter equal to single value , report runs fine, but when I set parameter equal to *% (all records)*, it show above error.

      I searched the net, someone said that *%* can not be used for all records, then what should be used for it and how?

      Pl guide me .

      Thanks & Regards.

      Edited by: ocpdev on Jan 2, 2013 10:52 PM
        • 1. Re: Web.show_document for All Records (%).
          Andreas Weiden
          The %-sign is a resevred sign in an url, you have to mask it. Check the UTL_ENCODE-package in the database. But i would advice you you to RUN_REPORT_OBJECT when you call a report ffrom forms, ghe you don't have that problem.
          • 2. Re: Web.show_document for All Records (%).
            Thanks again Guru for reply,

            But after using Run_report_object, problem is same i.e. runs fine for a single record, but not when using *%* (for all records).

            I have used following code:
            Repid REPORT_OBJECT;
            v_rep VARCHAR2(100);
            rep_status VARCHAR2(20);
            repid := FIND_REPORT_OBJECT('REPORT7');
            set_report_object_property(repid, REPORT_EXECUTION_MODE, BATCH);
            set_report_object_property(repid, REPORT_SERVER, 'rep_wls_reports_shiva-pc_asinst_1');
            set_report_object_property(repid, REPORT_COMM_MODE, SYNCHRONOUS);
            set_report_object_property(repid, REPORT_DESTYPE, CACHE);
            set_report_object_property(repid, REPORT_DESFORMAT, 'html');
            set_report_object_property(repid, REPORT_FILENAME, 'd:\finance\CATWISE_ITEMWISE_PARTYSALES.RDF');

            v_rep := RUN_REPORT_OBJECT(repid);



            It gives same error as sent you previously.

            So sir please guide me again for using *%* .


            Edited by: ocpdev on Jan 4, 2013 12:26 AM
            • 3. Re: Web.show_document for All Records (%).
              Andreas Weiden
              You have to add your parameters using SET_REPORT_OBJECT_PROPERTY, not by appending it to the url, add something like
              set_report_object_property(repid, REPORT_OTHER, 'FROMDATE="' ||TO_CHAR(:MAINBLOCK.FROMDATE,'DD-MM-RRRR')
                                       || '" TODATE="'TO_CHAR(:MAINBLOCK.TODATE,'DD-MM-RRRR')
                                       || '" select1="'||:mainblock.SELECT1|| '"');
              • 4. Re: Web.show_document for All Records (%).
                Thanks a lot Sir,

                With your guidance, my problem is solved now .

                You are requested to give attention to my previous pending problem, i.e. changing Reports Current Path which is as follow:
                I want to change reports default path, so that I could use my own path (like c:\finance), wherein I put all my reports.

                You advised me to put the path, in a parameter like *"sourceDir" value="C:\FINANCE" in rwserver.conf* file of C:\Oracle\Middleware\asinst_1\config\ReportsServerComponent\RptSvr_hp_asinst_1 folder. But all in vein.

                Then I do the same in other rwserver.conf files of below folders also:


                After this, one more problem arises i.e. when I call a report from a form, Report Server asks for Username & Password for System User Authentication, everytime I want to run the report.

                I have also post this query in the form, but couldn't get response till now, as it is urgent, so I decided to post you Guru.

                Please guide me again, for which I will be greatfull to you.

                Thanks & Regards.

                Edited by: ocpdev on Jan 4, 2013 7:39 PM
                • 5. Re: Web.show_document for All Records (%).
                  Alok Dubey
                  To change the report server path, you can use the following statement to run the report from the forms.


                  This will enable us to set our working directory/report server name/server id etc.

                  It is necessary to pass the user id, password while calling the report, to hide this sensitive data, use pfaction parameter.

                  Alok Dubey