Printing in Oracle Apex

Name: Printing in Oracle Apex
Rating: 4.2 (9 reviews)

We will discuss all possible ways for Printing in Oracle Apex

Created byAli Saleh Ali

Last updated 4/2023

Arabic

What you'll learn

how to use jasper report
how to use jasper Server
How to use Dyanmic PL/SQL Region
how to use Pirt Designer
How to use Open source

Course content

3 sections • 30 lectures • 3h 9m total length

Deploy Jasper Reports Integration on Tomcat2:17
Create Jasper Report Using [ Jasper soft Studio ]11:45
Create Data adapter
Create Data Set
Create Report
Compile Report
Call Jasper Report From Tomcat Using Jasper Integration5:51
Create Data Source in Jasper integration
call Report from Jasper integration in tomcat
Configure Jasper API With Schema4:15
from User SYS
@sys_install.sql STOCK

from User STOCK
@user_install.sql

from User SYS
@sys_install_acl.sql STOCK
Call Jasper Report From APEX as Link1:51
http://localhost:8080/JasperReportsIntegration/report?_repName=product&_repFormat=pdf&_dataSource=STOCK&_repLocale=en_US&_repEncoding=ISO-8859-1
Call Jasper Report From APEX Using Jasper [ API ]4:42
begin
xlib_jasperreports.set_report_url('http://localhost:8080/JasperReportsIntegration/report');

xlib_jasperreports.show_report (p_rep_name => 'Product',
p_rep_format => 'pdf',
p_data_source => 'STOCK',
p_rep_locale => 'en-US',
p_out_filename => 'Product.PDF'

);
-- stop rendering of the current APEX page
apex_application.g_unrecoverable_error := true;
end;
Call Jasper Report From APEX Using java script [1]2:47
window.open(
"http://localhost:8080/JasperReportsIntegration/report?_repName=product&_repFormat=pdf&_dataSource=STOCK&_outFilename&_repLocale=en_US&_repEncoding=ISO-8859-1",
"Jasper Report",
"_blank");
Call Jasper Report From APEX Using java script [2] More Details5:17
var report_server = "http://localhost:8080/JasperReportsIntegration/report?" ;
var report_name = "product" ;
var report_format = "rtf" ;
var data_source = "STOCK" ;
var file_name = "product_report.pdf" ;
var report_loc = "en_US" ;
var report_enc = "ISO-8859-1" ;
var report = ""+report_server+"_repName="+report_name+"&_repFormat="+report_format+
"&_dataSource="+data_source+"&_repLocale="+report_loc+"&_repEncoding="+report_enc+"";
window.open( report, "Jasepr Report", "width=800,height=900");
Create Jasper Report with parameter Using [ Jasper soft Studio ]4:19
Call Jasper Report with Parameter From APEX Using Jasper API3:56
declare
l_additional_parameters varchar2(32767);
begin
-- construct additional parameter list
l_additional_parameters := 'P_PRODUCT_ID=' || :P5_PRODUCT_ID;
xlib_jasperreports.set_report_url('http://localhost:8080/JasperReportsIntegration/report');
xlib_jasperreports.show_report (p_rep_name => 'Product_1',
p_rep_format => 'pdf',
p_data_source => 'STOCK',
p_rep_locale => 'en-US',
p_out_filename => 'Product.PDF',
p_additional_params => l_additional_parameters

);
-- stop rendering of the current APEX page
apex_application.g_unrecoverable_error := true;
end;
Call Jasper Report with Parameter From APEX Using JavaScript2:54
var report_server = "http://localhost:8080/JasperReportsIntegration/report?" ;
var report_name = "product_1" ;
var report_format = "pdf" ;
var data_source = "STOCK" ;
var file_name = "product_report.pdf" ;
var report_loc = "en_US" ;
var report_enc = "ISO-8859-1" ;
var V_product_id = $( "#P5_PRODUCT_ID" ).val();
var report = ""+report_server+"_repName="+report_name+"&_repFormat="+report_format
+"&_dataSource="+data_source+"&_repLocale="+report_loc+"&_repEncoding="
+report_enc+"&P_PRODUCT_ID="+V_product_id+"";
window.open( report, "Jasepr Report", "width=800,height=900");

install jasper server4:21
create data adaptor3:14
jdbc:oracle:thin:@localhost:1521/orclpdb
create data set in Jasper studio2:02
SELECT *
FROM "DEPT"
export report in PDF and understand Araibc font issue2:19
solve arabic font issue3:12
jasper server in Japser studio and publish report4:55
http://localhost:6060/jasperserver/
solve arabic font issue in jasper server2:28
add paramter to report4:22
SELECT *
FROM "EMP"
WHERE
"EMP"."DEPTNO" = $P{P_DEPTNO}
call jasper report from APEX10:49
DECLARE
v_blob BLOB;
v_file_type VARCHAR2 (25) := 'pdf';
v_file_name VARCHAR2 (25) := 'TEST_P.'||v_file_type;
v_vcContentDisposition VARCHAR2 (25) := 'inline';
v_DEPTNO NUMBER := :P3_DEPTNO;
v_hostname VARCHAR2(30) := 'localhost';
v_port NUMBER := '6060';
v_username VARCHAR2(50) := 'jasperadmin';
v_password VARCHAR2(50) := 'jasperadmin';
v_jasper_string VARCHAR2(30) := v_username || ';' || v_password;
v_login_url VARCHAR2(100) := 'http://' || v_hostname || ':' || v_port || '/jasperserver/rest/login';
v_report_url VARCHAR2(100) := 'http://' || v_hostname || ':' || v_port || '/jasperserver/rest_v2/reports/reports/' || v_file_name;
BEGIN
-- log into jasper server
v_blob := apex_web_service.make_rest_request_b(
p_url => v_login_url,
p_http_method => 'GET',
p_parm_name => apex_util.string_to_table('j_username;j_password',';'),
p_parm_value => apex_util.string_to_table(v_jasper_string,';')
);
-- download file
v_blob := apex_web_service.make_rest_request_b(
p_url => v_report_url,
p_http_method => 'GET',
p_parm_name => apex_util.string_to_table('P_DEPTNO',';'),
p_parm_value => apex_util.string_to_table(v_DEPTNO,';')
);
--OWA_UTIL.mime_header ('application/pdf', FALSE); -- view your pdf file
OWA_UTIL.MIME_HEADER( 'application/octet', FALSE ); -- download your pdf file
HTP.p('Content-Length: ' || DBMS_LOB.GETLENGTH(v_blob));
HTP.p('Content-Disposition: ' || v_vcContentDisposition ||'; filename="' || v_file_name || '"');
OWA_UTIL.http_header_close;
WPG_DOCLOAD.DOWNLOAD_FILE(v_blob);
APEX_APPLICATION.STOP_APEX_ENGINE;

END;
Call Report from APEX With dyaminc file type2:32
DECLARE
v_blob BLOB;
v_file_type VARCHAR2 (25) := :P3_TYPE ;
v_file_name VARCHAR2 (25) := 'TEST_P.'||v_file_type;
v_vcContentDisposition VARCHAR2 (25) := 'inline';
v_DEPTNO NUMBER := :P3_DEPTNO;
v_hostname VARCHAR2(30) := 'localhost';
v_port NUMBER := '6060';
v_username VARCHAR2(50) := 'jasperadmin';
v_password VARCHAR2(50) := 'jasperadmin';
v_jasper_string VARCHAR2(30) := v_username || ';' || v_password;
v_login_url VARCHAR2(100) := 'http://' || v_hostname || ':' || v_port || '/jasperserver/rest/login';
v_report_url VARCHAR2(100) := 'http://' || v_hostname || ':' || v_port || '/jasperserver/rest_v2/reports/reports/' || v_file_name;
BEGIN
-- log into jasper server
v_blob := apex_web_service.make_rest_request_b(
p_url => v_login_url,
p_http_method => 'GET',
p_parm_name => apex_util.string_to_table('j_username;j_password',';'),
p_parm_value => apex_util.string_to_table(v_jasper_string,';')
);
-- download file
v_blob := apex_web_service.make_rest_request_b(
p_url => v_report_url,
p_http_method => 'GET',
p_parm_name => apex_util.string_to_table('P_DEPTNO',';'),
p_parm_value => apex_util.string_to_table(v_DEPTNO,';')
);
--OWA_UTIL.mime_header ('application/pdf', FALSE); -- view your pdf file
OWA_UTIL.MIME_HEADER( 'application/octet', FALSE ); -- download your pdf file
HTP.p('Content-Length: ' || DBMS_LOB.GETLENGTH(v_blob));
HTP.p('Content-Disposition: ' || v_vcContentDisposition ||'; filename="' || v_file_name || '"');
OWA_UTIL.http_header_close;
WPG_DOCLOAD.DOWNLOAD_FILE(v_blob);
APEX_APPLICATION.STOP_APEX_ENGINE;

END;
Preview any Jasper report in Oracle APEX by one code using jasper server8:42
Download any Jasper report in Oracle APEX by one code using jasper server7:45

Requirements

Oracle APEX Basic

Description

Oracle Application Express (APEX) provides a range of features for printing reports and documents from within the application. Here are some key things to know about printing in Oracle APEX:

APEX provides a built-in print server called Oracle BI Publisher. BI Publisher allows you to design and generate reports in various formats like PDF, RTF, Excel, HTML, and more.
APEX also supports printing to PDF directly from the browser using the built-in printing functionality of modern browsers. This feature allows you to generate PDFs without the need for additional server-side software.
APEX allows you to customize the print layout by defining templates using a combination of HTML, CSS, and JavaScript. You can define templates for individual reports or for the entire application.
You can also use APEX's Dynamic Actions to control the printing behavior, such as hiding or showing certain elements on the page, setting print options, and more.
APEX also supports the use of third-party reporting tools like JasperReports and Oracle Reports if you need more advanced reporting capabilities.

We will discuss all possible ways for Printing in Oracle Apex

How to export yot repot in PDF ,DOCX ,XLSX and more

jasper report using jasper integration
jasper report using jasper server
PIRT designer
style vision
Using PL_SQL Dynamic Region
stimulsoft
AmandaDocxPrinter

and i will add more

APEX Office Print (AOP)
BI publisher

Who this course is for:

Oracle APEX Developer

Printing in Oracle Apex

What you'll learn

Explore related topics

Course content

Jasper Report In Oracle APEX11 lectures • 50min

Integrating JasperReports Server with APEX12 lectures • 57min

different ways for Printing In Oracle APEX7 lectures • 1hr 23min

Requirements

Description

Who this course is for: