Press "Enter" to skip to content

How to Embed BI Publisher Report into a Page in Oracle Apex?

In this tutorial, you will learn how to embed BI Publisher Report into a page in Oracle Apex. Follow these steps:

Embed BI Publisher Report into a Page in Oracle Apex

  1. In Oracle Apex, click on the Shared Components > Report Queries and then click on the report query you want to embed the report for it. Then set the Output Format as PDF, View File as Inline and then copy the URL. As shown in the below image:

Copy BI Report URL - Oracle Apex

  1. Now save the changes and open the page in which you want to embed to BI Report in Oracle Apex page designer.
  2. Then create a region and select its type as URL and then click on the Attributes and paste the URL in the URL field as shown in the below image:

Oracle Apex - Create URL region.

Now save the changes and run. You will see the preview of the BI report you created.

Note: If you are using the page items in the BI report query, then you have to create page items in the page you are embedding the URL and populate the values to produce the output for the report.

See also:

Have you found the answer to your question? If not, you can discuss it with me in the comments section below or join my Q&A community OrclQA.com for developers and ask your question. It is FREE.

Vinish Kapoor

Follow

Hi, I am a full stack developer and writing about development. I document everything I learn and help thousands of people. foxinfotech.in is created, written, and maintained by me; it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub, and get notifications for new posts.

guest
9 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Bheem Vangi
Bheem Vangi
7 months ago

how to use where condition for report query & pass page items

Varduhi Kababjyan
Varduhi Kababjyan
5 months ago

Hi Vanish,

Is there a way to dynamically append date and time to Report Query Time at run time?

I tried report_name_%d%m%y and file_name_{$SYSDATE()$} with no luck.

BTW thank you for all your blog post. I refer to your tutorials very often and they are very informative and helpful.

Varduhi Kababjyan
Varduhi Kababjyan
Reply to  Vinish Kapoor
5 months ago

Hi Vinish,

Yes, I want the downloaded file to have the file name + the date and the time appended to it.

ex: file_name_10_17_2020_11_15_12.

Thank you

Varduhi
Varduhi
Reply to  Vinish Kapoor
4 months ago

Hi Vinish,

Thank you for the example :).

I change the file format from Pdf to xls and the file name is ‘f’ when I run export the query.

See the attached screenshot.

Thank you so much.

Varduhi

Screen Shot 2020-10-18 at 12.24.13 PM.png
Varduhi
Varduhi
Reply to  Vinish Kapoor
4 months ago

Thank you so much! I got it working.