Create Advance PDF Reports in Oracle APEX Comprising Grouping | Chart | Pivot Table - Part 33

By default, APEX has the ability to produce simple generic matrix reports comprising rows and columns. This video will show you how to produce advance report in APEX. Here, you will be provided with step-by-step instructions to generate:

Topics Covered in this video
====================================================
- A highly formatted MIS report
- Pivot Table
- Create Report Query
- Design report layout in Microsoft Word using XML data
- Data grouping and sorting
- Formatting reports using standard Microsoft Word tools
- Add conditional formatting to display data differently in the same report
- Add calculations
- Create parameterized report
- Upload RTF layout to APEX
- Attach custom report layout to the default report query
- Add link in the application to run advance reports

BI Publisher Desktop Link
===========================================

Download Source Code From Here:-

The content of this video is taken from my book "Create Rapid Low-Code Web Applications in Oracle APEX"

Completely Free Oracle APEX Course
==============================

[devatichetty]

Please advise the licensing implications for using BI publisher in Apex. Great video.

[skamransajjad]

Thanks for the video, I want to preview the PDF output in new tab instead of downloading it and then previewing it. Thanks in advance

[mutaheralsabbah]

Thanks... excellent work... but what are the previous settings because the test report shows an error?

[ahmedharoon]

thank you sir, very impressive, please inform (for my local environment) what are the requirements to install and configure to integrate BI Publisher into Oracle Apex? can you please guide us step-by-step from scratch ( what should i download and install, BI Publisher Server or Desktop or both ) OR any link from where i can learn this? regards

[arunbhandari]

Hey dear, I need a help with the same custom pdf report devlopment in 23 version it's giving url probited error..can you help me

[parthparth]

Nice Demo on BI Publisher Report From Oracle Apex
But madam, ABC CORPORATION assign to any variable, this variable to be put on each bi report
how to do that

[MarcoCiato]

It doesn't work on my Oracle APEX cloud. In Report queries the message is: "Report Queries are not supported" and if I try to create Report query, when I try to download pdf the message is: ORA-20987: The requested URL has been prohibited. Contact your administrator. Am I doing something wrong or do I have to make some requests for my Oracle Cloud? Thanks.

[daxmlai]

Can it work on my local network. My oracle db not on clouds. Any configuration requirements?