1 Reply Latest reply: Feb 4, 2013 12:51 PM by Yogi RSS

    Calling BI Publisher Report with parameters from Apex

    Yogi
      Hi There,

      I am calling a BI Report from apex as given in the below url:

      http://dgielis.blogspot.com/2007/12/call-bi-publisher-report-from-apex.html

      However my BI Report has parameters. Does anybody know how to call the report by passing parameters from apex.

      Thanks
      Yogi

      Edited by: Yogi on Aug 26, 2010 1:15 PM

      Edited by: Yogi on Feb 4, 2013 10:51 AM
        • 1. Re: Calling BI Publisher Report with parameters from Apex
          Yogi
          Hi,

          I found a way to do this using javascript in "HTML Header" in the Page section of an APEX Page



          <script type="text/javascript">

          function invokeURL()
          {     

          var parameterId = document.getElementById("P2_PARAMETER").value;

          alert ("hello "+objectiveId);

          var url =
          "http://xxhost:port/xmlpserver/XXFOLDER_NAME/xxxx_test_report2.2/xxxx_test_report2.2.xdo?_xpf=&_xpt=0&_xdo=%2XXXX_XXX%2Fxxxx_test_report2.2%2Fxxxx_test_report2.2.xdo&G_PARAMETER_NAME="+parameterId+"&_xt=defaultlayout&_xf=pdf&_xmode=2";

          window.open(url);

          </script>





          This can invoked in a button by passing "javascript:invokeURL();" to the "Optional URL Redirect" section.


          Thanks
          Yogi

          Edited by: Yogi on Aug 26, 2010 11:14 AM

          Edited by: Yogi on Feb 4, 2013 10:51 AM