Oracle APEX & JasperReports Integration for FREE PDF Printing
ฝัง
- เผยแพร่เมื่อ 2 ต.ค. 2024
- This step-by-step tutorial will teach you how to create an environment on your local PC to integrate Oracle APEX with JasperReports to generate advanced reports comprising grouping, headers, footers, calculations, and more.
PREREQUISITES
--------------------------
• How to Install Oracle ...
• Oracle APEX Applicatio...
Download JasperReports Integration Kit
-----------------------------------------------------------------
github.com/dau...
Download Jaspersoft Studio version 6.20.1
----------------------------------------------------------------------
sourceforge.ne...
Download Source Code
--------------------------------------
drive.google.c...
01:25 - Download and install JasperReports Integration Kit
01:54 - Install J2EE Application and Configure Data Sources
02:58 - Set and get the configuration directory
setConfigDir.cmd ..\webapp\jri.war c:\app\JasperReportsIntegration
getConfigDir.cmd ..\webapp\jri.war
03:29 - Configure database access
04:01 - Deploy the J2EE application
04:35 - Testing JasperReports integration installation
05:16 - Installation of database objects
07:22 - Download and install Jaspersoft Studio version 6.20.1
08:11 - Create a Connection to Datasource in Jaspersoft Studio using the ojdbc8 driver
10:31 - Create a Report in Jaspersoft Studio with parameters
21:36 - Integrating report with Oracle APEX
24:12 - Handling "Unexpected token '%', '%PDF-1.5 %'... is not valid JSON" error
when i click the button, i have trhe following error
An error occured.
Please contact your local administrator.
On page I got: An error occured.
Please contact your local administrator.
Got something like this in Tomcat console:
09:06:25 [INFO] jasper.webapp.ReportWrapper.service - *** servlet /report START
09:06:25 [INFO] oc.servlet.ServletUtilities.logRequestParameters - Request parameters:
09:06:25 [INFO] oc.servlet.ServletUtilities.logRequestParameters - _repName: umowa6
09:06:25 [INFO] oc.servlet.ServletUtilities.logRequestParameters - _repFormat: pdf
09:06:25 [INFO] oc.servlet.ServletUtilities.logRequestParameters - _dataSource: default
09:06:25 [INFO] oc.servlet.ServletUtilities.logRequestParameters - _outFilename: umowa6.pdf
09:06:25 [INFO] oc.servlet.ServletUtilities.logRequestParameters - _repLocale: en-US
09:06:25 [INFO] oc.servlet.ServletUtilities.logRequestParameters - _repEncoding: UTF-8
09:06:25 [INFO] oc.servlet.ServletUtilities.logRequestParameters - _imagesURI: wwv_flow.show?p_request=APPLICATION_PROCESS%3DJRI_SHOW_IMAGE&p_flow_id=100&p_flow_step_id=0&p_instance=16071753227566&x01=#IMAGE_NAME#
09:06:25 [INFO] oc.servlet.ServletUtilities.logRequestParameters - _printIsEnabled: false
09:06:25 [INFO] oc.servlet.ServletUtilities.logRequestParameters - _printCopies: 1
09:06:25 [INFO] oc.servlet.ServletUtilities.logRequestParameters - _printDuplex: false
09:06:25 [INFO] oc.servlet.ServletUtilities.logRequestParameters - _printCollate: false
09:06:25 [INFO] oc.servlet.ServletUtilities.logRequestParameters - _saveIsEnabled: false
09:06:25 [INFO] oc.servlet.ServletUtilities.logRequestParameters - P_KLUCZUMOWY: 202
09:06:25 [INFO] jasper.webapp.ReportWrapper.service - using report file: path..
eports\umowa6.jasper
09:06:25 [INFO] oc.db.ConnectionUtility.getConnection - successfully connected to jdbc:oracle:thin:@XXXXXXXXX:YYYY:ZZZZZ with user: AAAA
Hello sir
Why when I press the print button the following error appears?
"XLIB_JASPERREPORTS.SET_REPORT_URL' must be declared"
Please help
thank u soo much for all the efforts your are making to give us these very useful videos.
Most welcome!
Good Work. My report is empty, no data. Apex 23, ords23 with jdk 21, oracle 21c xe, tomcat 9 started with java 17. Empty even without parameters, just text. Thanks for the reply
one more thing is that i am trying to configure tomcat 9 to apply ssl. i have domain registered with namecheap and downloaded positive ssl crertificate files. i created jks file from .crt file and applied in server.xml but no luck. can you please guide me to apply ssl in tomcat 9 or give me link if you already have video on it. thanks
great efforts to help us to learn Oracle Apex for our practicle life... thanks very much sir.
Most welcome! Keep watching.
Does Jasper work with Oracle Autonomous cloud? Pls let me know.
Good Question. I hope that she answer you. We wolud like implement APEX in ATP
Clearly explained . Thanks fo help us. Question : How implement Jasper Report with Oracle APEX Cloud in ATP ??
all set but how to make not download the pdf??????, just preview that pdf in new tab after that its on user so he download the file if he want
"ORA-01403: no data found Contact your application administrator. " any idea about this error when pl/sql code is run.
Did you manage to fix the mistake? figured out what was causing this error?
When I run below command it gives me error
setConfigDir.cmd ..\webapp\jri.war C:\app\JasperReportsIntegration
Exception in thread "main" java.lang.NoClassDefFoundError: ///lib/commons-configuration-1/8/jar
any suggestion?
if i have multi selected value item in jasper how can i call this parameter in process at apex
THANK YOU VERY MUCH.
Good work. I have tried this but no luck getting error
Message Could not connect via JDBC: Listener refused the connection with the following error:
Description The server encountered an unexpected condition that prevented it from fulfilling the request.
Exception
java.lang.RuntimeException: Could not connect via JDBC: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
any help?
Watch this video first in which we used 21c pluggable database (xepdb1). th-cam.com/video/6D5epm0WCFs/w-d-xo.html
@@TechMining69 i have seen this video and installed accordingly. it work fine i can access from remote computer through tomcat. every thing is working fine.
but when i installed Jasper Report server i am having error mentioned above. more over do you have video to ssl tomcat ?
@@TechMining69 do i need to install java EE ?
Have you selected the ojdbc8 file on the driverclass path tab?
@@TechMining69 i am on test report section where no ojdbc8 was selected anywhere. please help me to resolve this error. i have followed all the steps in your video but no luck.
is this anything to install or to take care which is not clearly described in video like to install some thing like java EE etc??
Keep it up. Nice work
Thanks, will do!
Really Thanks
Most welcome
Hi. All good.
Hello 👋. All good.