Create Custom PDF Report in Oracle Apex using BIRT

Create Custom PDF Report in Oracle Apex using BIRT

1. Download Birt Designer from Here Or any version you like


2. Download Birt Run-time from here Or any version you like

3. start design you report Emp_1 in Birt Designer

3.1. Create Data source
oracle.jdbc.OracleDriver (v10.2)
jdbc:oracle:thin:@localhost:1521:xe

3.2. Create your Data set
will contain you sql Query 

select * from  EMP

3.3. start Design You Report
3.4 Save You Report

4. Copy Birt Rn-time folder to tomcat setup source

C:\Program Files\Apache Software Foundation\Tomcat 9.0\webappsyo

5- Copy you report Emp_1 that you Created before to

C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\birt

6- don't forgit to copy your ojdbc file to
C:\Program Files\Apache Software Foundation\Tomcat 9.0\lib

7- in Oracle Apex App
create Button and make BehaviorRedirect to URL
and use this 
http://localhost:8080/Birt/run?__report=Emp_1.rptdesign&__format=pdf

where Emp_1 is your report Name


8- run your Page in Oracle Apex and Press You Button you will get

9- Finally Our Arabic Video

  

Thanks