Basic Jasper

- 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 https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html  and add it to the classpath.

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

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

- Open the ticket to us and provide the .jasper file in the ticket we'll upload your file into your Jasper report folder.

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

 

begin
  xlib_jasperreports.set_report_url('http://jasper.danytechcloud.net:8070/JasperReportsIntegration/reports');
  xlib_jasperreports.show_report (p_rep_name => :p_rep_name,
                                  p_rep_format => :p_rep_format,
                                  p_data_source => :p_data_source,
                                  p_out_filename => :p_out_filename,
                                  p_rep_encoding => :p_rep_encoding,
                                  p_additional_params => :p_additional_params);

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

a filename can be specified for the download for the "save as" dialog

 

 

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 "_")

   
  • 0 Kasutajad peavad seda kasulikuks
Kas see vastus oli kasulik?