Integrate and Call Jasper Reports From Oracle APEX #43

kashifsbr · Sep'22

Please Provide detailed step by step guide that how to integrate and Call Jasper Report from Oracle Apex I'm new to Apex and Jasper Reporting.
My Environment is,
APEX 22.1.4
ORDS 22.2
Oracle DB 21c XE
APEX is working fine,
Now I have to Create Reports in Jasper Studio,
I Also have
Jasper Studio 6.20 Community Edition
Jasper Report Server 8.0 Community Edition
I Have created a test report in Jasper Studio (in connection with Oracle DB), and Successfully published on Jasper Report Server, Now i want to Call this report using APEX environment. Please guide.

solved #2
replies 13
views 1.7K
likes 0

Dietmar Aust daust · Sep'22 Team

Hi @kashifsbr,

is anything missing in the documentation?

Did you read the installation and usage instructions?
Did you install the sample application?

Best
~Dietmar.

1 Reply

kashifsbr · Sep'22 Author

Thank you, I was missing link to this document.
I have configured the Jasper Integration with APEX/ORDS on Apache Tomcat Server.

I have an other question not related to Jasper reporting, the reason for asking that might you can give some hints to handle the situation,
as I have already told my Environment details,
Windows 11
APEX 22.1.4
ORDS 22.2
just Moved ORDS to Apache tomcat server version 9.x,
I have To set the Configuration folder Path on ORDS startup, I have done this using windows environment variable, <JAVA_TOOLS_OPTION>
right now its working fine with these settings.
Is there any option to add this path in apache tomcat configuration file, (like web.xml), if yes please tell me How can i do this.

Dietmar Aust daust · Dec'22 Team

Hi @kashifsbr ,

I guess I would try setting it through the file setenv.bat in the Tomcat bin directory, similar to this:

Best,
Dietmar.

kashifsbr · Dec'22 Author

2 #5

Dear @daust
Thanks for the reply,
setenv.bat not found in the bin directory,
Any how I have resolved this problem by setting the values using Tomcat-Service Properties window.

kashifsbr accepted post #5 as the answer 2 years ago

kashifsbr unaccepted post #5 and accepted post #2 as the answer 2 years ago

Dietmar Aust daust · Dec'22 Team

Perfect!

The proof is in the pudding. Whatever works for you.
Actually, the file setenv.bat needs to be created first, it does not exist after installation. But this is a typical (and well documented) way to configure Tomcat.

Best
~Dietmar.

Muhammad Azeem azeemzahoor · May'23

@kashifsbr can I get your contact? I need your help

1 Reply

Muhammad Azeem azeemzahoor · May'23

#10

@daust I have followed all steps but integration test fails as shown in below screenshot. Please help.
Screenshot 2023-05-13 114833.png

kashifsbr · May'23 Author

#11

How you setup Database Connection?
Please Share the related information. your complete environment details.

Najeeb_Khan najeebalikhel · Jun'24

#12

@daust Kindly check your email I have followed your steps but still direct printing is not working

Najeeb_Khan najeebalikhel · Jun'24

#13

@daust my whatsapp no +923015887156
can I have your whatsapp no ?

Najeeb_Khan najeebalikhel · Jun'24

#14

@kashifsbr Can we have short call for quick overview for my environment?
Please whatsapp me +923015887156

Integrate and Call Jasper Reports From Oracle APEX #43

GitHub - daust/JasperReportsIntegration: JasperReportsIntegration provides an interface to use the JasperReports reporting engine in an Oracle database application, specifically with Oracle Application Express (Oracle APEX).