This discussion is archived
1 Reply Latest reply: Feb 4, 2013 10:51 AM by Yogi RSS

Calling BI Publisher Report with parameters from Apex

Yogi Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points