Your browser was unable to load all of the resources. They may have been blocked by your firewall, proxy or browser configuration.
Press Ctrl+F5 or Ctrl+Shift+R to have your browser try again.

Integrate and Call Jasper Reports From Oracle APEX #43

#1

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 10
  • views 1.1K
  • likes 0
#2

Hi @kashifsbr,

is anything missing in the documentation?

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

Best
~Dietmar.

kashifsbr · Author
#3

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.

#4

Hi @kashifsbr ,

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

Greenshot 2022-12-02 11.59.43.png

Best,
Dietmar.

kashifsbr · Author

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.

Screenshot 2022-12-06 130719.png
kashifsbr accepted post #5 as the answer
#6
kashifsbr unaccepted post #5 and accepted post #2 as the answer
#7
#8

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.

#9

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

#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 · Author
#11

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