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
===========================================
www.oracle.com/middleware/tec...
Download Source Code From Here:-
drive.google.com/drive/folder...
The content of this video is taken from my book "Create Rapid Low-Code Web Applications in Oracle APEX"
www.amazon.com/Create-Rapid-L...
Completely Free Oracle APEX Course
==============================
• Free Oracle APEX Course

[@mundova184]

Hi. Thanks, I needed this. Regards.

[@TechMining69]

Glad it was helpful!

[@tariqmohammad2212]

Great video 👍

[@TechMining69]

Thanks 👍

[@arunbhandari361]

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

[@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.

[@devatichetty4323]

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

[@TechMining69]

For BI Publisher server licensing you have to contact Oracle Corporation in your region. We're coming up with another video in which we will demonstrate how to create such reports in JasperReport for free.

[@mutaheralsabbah9790]

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

[@TechMining69]

Please elaborate "previous settings".

[@skamransajjad7]

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

[@TechMining69]

You are welcome!

[@ahmedharoon2740]

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

[@TechMining69]

Stay tuned. We will upload this video in near future.

[@ar13147]

​@@TechMining69 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

[@parthparth8680]

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

[@TechMining69]

You can fetch this value in your report's SQL query from the company setup table. Of course, you need to have such a table in your schema where you have the company profile.

[@parthparth8680]

Madam, Thank you for your Valuable reply. Madam Scott schema, dept and emp table are there, Now I want to Each Dept PDF individual. That how to do either in specified folder or Specified ORACLE DIRECTORY .

[@daxmlai]

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

[@TechMining69]

We created this tutorial on Oracle APEX cloud. It works there. You need to create the query and upload RTF.

[@daxmlai]

@@TechMining69 Means no requirement of bipublisher server to be install

[@TechMining69]

Of course, you need the server for your local environment and need some configuration in APEX to use it as your print server. In near future, we will be uploading a video on Jasper Report which is a better alternative.