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:


begin
  xlib_jasperreports.set_report_url('http://jasper-east.us.revion.com:8080/JasperReportsIntegration/report');
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;

end;

 
Here is a description of the input parameters:

 

parameter

description

default value

required?

p_rep_name

specifies the report name

test

*

p_rep_format

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

pdf

*

p_data_source

configured data source, e.g. default, test

default

*

p_rep_encoding

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

UTF-8

 

p_additional_parameters

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

   
     

 

   

 

 

 

  • Jasper, Jasper reports
  • 0 Los Usuarios han Encontrado Esto Útil
¿Fue útil la respuesta?

Artículos Relacionados

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....