Downloads
Happy Users
Monthly Users
Special Highlights For You
An easy-to-use PL/SQL API
Developed directly for embedding JasperReports in Oracle projects (Oracle Forms, APEX, ADF, Java Web Projects)
Replacement of Oracle's Reports Server with minimal effort
Easy integration in Forms, Apex, JavaEE etc.
A lightweight PL/SQL API is included. The following code lines are required, to call a JasperReport from Forms:
/* Specify the report */
TEAM_J4O.set_report( P_PROJECT_NAME => ‘j4o_Demo’ ,
P_REPORT_NAME => ‘EmployeeExample’ ,
P_FORMAT => ‘PDF’ ,
P_LOCALE => ‘de_DE’ );
/* Pass the parameters */
TEAM_J4O.add_param( ‘deptId‘, :departments.department_id) ;
/* Call the report */
if not TEAM_J4O.get_report_view_url( P_URL => v_url,
P_ERR_CODE => v_err_code,
P_ERR_MSG => v_err_msg )
then
/* Display the PDF in the browser window */
web.show_document ( v_url, ‘_BLANK’ );
end if;
Convincing Features For You
Direct printing feature
By specifying the printer with the PL/SQL API, the report is directly printed. This can also be achieved by DB background processes (DBMS_JOB or DBMS_SCHEDULER). To determine the possible printers, the API also provides a function that returns all printers accessible to the J4O Server.
Display / Download PDF, Word, Excel etc.
Ability to display via a simple URL, directly from Forms. Using the J4O Server you don’t need to enter any password in the URL, when connecting from another application. For security reasons, the server generates a one-time token that can be used to display the report once.
Save the created PDF on the server
A directory on the server can also be used as an output destination to print multiple documents using batch printing. All you need to do is to specify the directory and the report name as the output destination for the report.
Direct sending of emails.
A created document can also be sent directly by email via the PL/SQL-API of the J4O server. You specify one or more recipients, CC or BCC and the email content. The document is then sent to the recipient as an attachment.
Deploying reports with different users
When executing the report, the database user can optionally be specified. In many projects, Oracle Reports uses the current user passed by Forms. To facilitate migration, the PL/SQL-API allows you to specify the database user for each print call.
Further advantages of the Jasper4Oracle server compared to the free TIBCO JasperServer
Simple administration interface
By specifying the printer with the PL/SQL API, the report is directly printed. This can also be achieved by DB background processes (DBMS_JOB or DBMS_SCHEDULER). To determine the possible printers, the API also provides a function that returns all printers accessible to the J4O Server.
Global Resources
If resources such as subreports, fonts, images, Java-classes (scriptlets), etc. need to be available in a global scope, these can be achieved by declaring its Jar-archieve as a global resource.
Same functionality in JasperStudio and J4O server
No expression changes are needed when referencing subreports deployed on the J4O Server. In comparison to the TIBCO JasperServer, the J4O server behaves like the Studio.
Easy deployment
Deployment takes place by storing a Jar-Archive in the directory structure on the J4O server. The Jar-Archive contains all resources of the report, including fonts, images and Java-classes (scriptlets). These Jar-Archives can easily be created from within Jasper-Studio.
Easy installation
The J4O server is a standalone application. All you need is a Java environment (the OpenJDK is sufficient). The application needs to be unpacked and started. The PL/SQL-API needs some DB permissions because it communicates with the server via REST. However, installation scripts are available for this.
Downloads
Test version „Jasper4Oracle Server“
Integration of JasperReports in Oracle Forms or Apex application with a PL/SQL API for replacing Oracle Reports. The PL/SQL API offers functions for printing, exporting, downloading, mailing and showing documents (PDF, Word, Excel etc.) in a Browser.
Features: JasperReports | PL/SQL | Oracle | Forms | Apex | ADF | Oracle Reports | Reports | Jasper
* The runtime of the timely restricted version is limited to 8 hours. After that a restart is required. Runtime limitations can be removed by purchasing a license key. The timely restricted version has no other limitations.
Flyer „Overview of the different JasperReports server“
Overview and comparison of the different JasperReports Servers: Tibco Community, Tibco Commercial and TEAM Jasper4Oracle server
Documentation „Jasper4Oracle Server – Installation Guide“
Jasper4Oracle Server – Installation Guide: Hints | Installation | Configuration | Use | Contact
Flyer „Jasper4Oracle Server – The perfect replacement for Oracle's Reports Server“
A short overview: Jasper4Oracle Server – the perfect replacement for Oracle’s Reports Server.
Downloads
Test version „Jasper4Oracle Server“
Integration of JasperReports in Oracle Forms or Apex application with a PL/SQL API for replacing Oracle Reports. The PL/SQL API offers functions for printing, exporting, downloading, mailing and showing documents (PDF, Word, Excel etc.) in a Browser.
Features: JasperReports | PL/SQL | Oracle | Forms | Apex | ADF | Oracle Reports | Reports | Jasper
* The runtime of the timely restricted version is limited to 8 hours. After that a restart is required. Runtime limitations can be removed by purchasing a license key. The timely restricted version has no other limitations.
Flyer „Overview of the different JasperReports server“
Overview and comparison of the different JasperReports Servers: Tibco Community, Tibco Commercial and TEAM Jasper4Oracle server
Documentation „Jasper4Oracle Server – Installation Guide“
Jasper4Oracle Server – Installation Guide: Hints | Installation | Configuration | Use | Contact
Flyer „Jasper4Oracle Server – The perfect replacement for Oracle's Reports Server“
A short overview: Jasper4Oracle Server – the perfect replacement for Oracle’s Reports Server.
Video
Templates
Have we caught your attention?
If you would like further information about JasperReports, or want to talk to a JasperReports expert, call us at +49 5254 8008-0, or leave your contact details -we will get in touch with you.