Jasper Reports - how to

Below are steps to use Jasper reports:

- Download and Install Jasper Studio 6.21 from https://community.jaspersoft.com/project/jaspersoft-studio/releases

- You will first add the Oracle driver for JDBC which can be downloaded from http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html and add to the class path.

- Then you will create a new data source in Jasper Studio using the schema credentials we sent in the Jasper setup email.

- Create your new report with Jasper Studio and save it on your computer.

- Upload the .jasper file to the Jasper FTP folder using the credentials provided in our Jasper setup email.

- Call Jasper to report from your application with the API shown below:

xlib_jasperreports.show_report (p_rep_name => schema_name/report_name',

p_rep_format => 'pdf',

p_data_source => 'schema_name',

p_additional_params => 'head_sys_id='||:p25_id );

 -- stop rendering the current APEX page 

  apex_application.g_unrecoverable_error := true;


Here is a description of the input parameters:




default value



specifies the report name




the report format, e.g. pdf, html, html2, rtf, xls, jxl, csv, xlsx, pptx or docx




configured data source, e.g. default, test




the "charset" parameter for the content_type.
E.g.: ISO-8859-15, UTF-8, Windows-1252




all parameters are passed directly to the report (excluding the internal ones (prefixed with "_")







  • Jasper, Jasper reports
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to create an Oracle Wallet?

In order to secure your domain you need to the following:  We complete all necessary...

Can I use my domain name with Apex?

Absolutely, you will have full ftp/sftp access to the server as well.

Do you support SSL/https with APEX Hosting package?

Yes, we do. We can create temporary ssl certificate and when you are ready for a production you...

How do I send e-mail messages from PL/SQL?

Please follow this greate example: below: (http://www.orafaq.com/scripts/plsql/smtp.txt) rem...

How can I access APEX if I don't have domain name yet?

You can access APEX and develop your application even if you don't have domain name yet....