Jasper4Oracle Server, brought to you by TEAM, comes as a new technology that is meant to avoid the time-consuming problems that arise during migration projects. Jasper4Oracle Server has been developed based on developers experience in this field and also on the feedback gathered from our customers.

120

Downloads

417

Happy Users

417

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;

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

Via the administration interface, you can quickly and easily view errors and report runtimes.

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.

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.

Download

Flyer „Overview of the different JasperReports server“

Overview and comparison of the different JasperReports Servers: Tibco Community, Tibco Commercial and TEAM Jasper4Oracle server

Download

Documentation „Jasper4Oracle Server – Installation Guide“

Jasper4Oracle Server – Installation Guide: Hints | Installation | Configuration | Use | Contact

Download

Flyer „Jasper4Oracle Server – The perfect replacement for the Oracle Reports Server“

A short overview: Jasper4Oracle Server – the perfect replacement for Oracle’s Reports Server.

Download

Video

Templates

Template1 Create Helper Procedure in Database Template 2 Show a PDF in Forms Template3 Download a PDF from Froms Template 4 Send a PDF as email Template 5 Save a PDF on the Server Template 6 List available printers Template 7 Print a Report on a Printer

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.

  • This field is for validation purposes and should be left unchanged.

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.

  • This field is for validation purposes and should be left unchanged.