The package XLIB_JASPERREPORTS is the interface which accepts the parameters, generates the url and calls the integration on the locally installed J2EE server.
e.g.:
begin
xlib_jasperreports.set_report_url('http://localhost:8080/JasperReportsIntegration/report');
xlib_jasperreports.show_report (p_rep_name =>
:p5_rep_name,
p_rep_format
=> :p5_rep_format,
p_data_source
=> :p5_data_source,
p_out_filename
=> :p5_out_filename,
p_rep_locale
=> :p5_rep_locale,
p_rep_encoding
=> :p5_rep_encoding,
p_additional_params
=> :p5_additional_params);
-- stop rendering of 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 |
*
|
|
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_locale |
Locale string, composed of the |
de_DE |
|
p_rep_encoding |
the "charset" parameter for the content_type, a list of valid
entries can be found here.
|
UTF-8 |
|
p_additional_parameters | all parameters are passed directly to the report (excluding the the internal ones (prefixed with "_") | ||
The report files will have to be stored on the application server.
Copy
the compiled version (report.jasper)
of your report definition file (test.jrxml)
into the
directory OC_JASPER_CONFIG_HOME/reports/.
You can also create subdirectories to organize your reports. For
example if you have different reports in your application application1
for sales and for controlling:
You can specify input parameters for the reports and use them as a
filter. They have to be defined as STRING,
they cannot be number or any other data type. This is due to how the
integration calls the reports. See the report demo/orders.jrxml or demo/top_orders.jrxml as a sample. Both
use the input parameter pAppUser
for filtering the data set.
You can control the behaviour when exporting the report into the different report formats like pdf, html, rtf, xls, jxl, csv, xlsx, pptx or docx.
You can find the configuration reference at: