Print custom PDF Report Using PL/SQL Dynamic Region in Oracle Apex 19.1

Показать описание

How to Print custom PDF Report
Using PL/SQL Dynamic Region
in Oracle Apex 19.1
رابط دعم المحتوى على باترون

Рекомендации по теме

Комментарии

Code 1
--
declare
cursor c_emp
is
select EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO
from EMP

where EMPNO =:P4_EMPNO;

begin
htp.htmlopen; -- genera la etiqueta <HTML>
htp.headopen; -- genera la etiqueta <HEAD>
htp.title('Eployee Report'); -- genera la etiqueta <TITLE> y </TITLE>
htp.headclose; -- genera la etiqueta </HEAD>
htp.bodyopen; -- genera la etiqueta <BODY>
htp.header(1, 'Eployee Report'); -- genera la etiqueta <H1> y </H1>
htp.tableopen (cattributes => 'border=2 width=100% cellpadding=10 bgcolor=#F3F3F3'); -- genera la etiqueta <TABLE>
htp.tablerowopen (cattributes => 'bgcolor="#216BB9"'); -- genera la etiqueta <TR>
htp.tableheader(cvalue => '<font face="ARIAL" size="2.25" color="WHITE">' || 'Employee Number'); -- genera la etiqueta <TH> y </TH>
htp.tableheader(cvalue => '<font face="ARIAL" size="2.25" color="WHITE">' || 'Employee Name');
htp.tableheader(cvalue => '<font face="ARIAL" size="2.25" color="WHITE">' || 'Job');
htp.tableheader(cvalue => '<font face="ARIAL" size="2.25" color="WHITE">' || 'Manager');
htp.tableheader(cvalue => '<font face="ARIAL" size="2.25" color="WHITE">' || 'Hire Date');
htp.tableheader(cvalue => '<font face="ARIAL" size="2.25" color="WHITE">' || 'Salary');
htp.tableheader(cvalue => '<font face="ARIAL" size="2.25" color="WHITE">' || 'Commetion ');
htp.tableheader(cvalue => '<font face="ARIAL" size="2.25" color="WHITE">' || 'Department');

htp.tablerowclose; -- genera la etiqueta </TR>
htp.tablerowopen; -- genera la etiqueta <TR>

for r_emp in c_emp
loop
htp.tabledata(r_emp.EMPNO);
htp.tabledata(r_emp.ENAME, cattributes=>'align=left');
htp.tabledata(r_emp.JOB, cattributes=>'align=left');
htp.tabledata(r_emp.MGR, cattributes=>'align=left');
htp.tabledata(r_emp.HIREDATE, cattributes=>'align=left');
htp.tabledata(r_emp.SAL, cattributes=>'align=left');
htp.tabledata(r_emp.COMM,
htp.tabledata(r_emp.DEPTNO, cattributes=>'align=left');

htp.tablerowclose;
end loop;

htp.tablerowclose; -- genera la etiqueta </TR>
htp.tableclose; -- genera la etiqueta </TABLE>
htp.bodyclose; -- genera la etiqueta </BODY>
htp.htmlclose; -- genera la etiqueta </HTML>
end;

alisaleh

Great demo :) ..Thanks for sharing
I was able to implement however if I have to save this PDF to a blob file how would you do it?

MrBandhuraj

-- code 2
declare
V_SAL_TOTAL number;
V_COMM_TOTAL number;
V_COUNT number;
cursor c_emp is
select
EMPNO,
ENAME,
JOB,
--MGR,
APEX_ITEM.TEXT(4, MGR) MGR,
HIREDATE,
translate(SAL,
'0123456789',
unistr('\0660') || unistr('\0661') || unistr('\0662') ||
unistr('\0663') || unistr('\0664') || unistr('\0665') ||
unistr('\0666') || unistr('\0667') || unistr('\0668') ||
unistr('\0669')) as SAL,
COMM,

translate(DEPTNO,
'0123456789',
unistr('\0660') || unistr('\0661') || unistr('\0662') ||
unistr('\0663') || unistr('\0664') || unistr('\0665') ||
unistr('\0666') || unistr('\0667') || unistr('\0668') ||
unistr('\0669')) as DEPTNO,
APEX_ITEM.TEXT_FROM_LOV_QUERY(DEPTNO, 'SELECT DNAME, DEPTNO FROM DEPT') as DEPARTMENT
from
EMP;

begin
select SUM(SAL), sum(comm), count (DEPTNO)into V_SAL_TOTAL, V_COMM_TOTAL, V_COUNT from EMP;
htp.p(
'
<table>
<caption style ="text-align=center;" >Employee Report</caption>
<thead>
<tr>
<th>emplyee number</th>
<th>Employee Name</th>
<th>Job</th>
<th>Manager</th>
<th>Hire Date</th>
<th>Salary </th>
<th>Commetion</th>
<th>Department No </th>
<th>Department Name </th>
</tr>
</thead>
<tbody>

'
);for r_emp in c_emp
loop
htp.p(
'
<tr>
<td>' || r_emp.EMPNO || '</td>
<td>' || r_emp.ENAME || '</td>
<td>' || r_emp.JOB || '</td>
<td>' || r_emp.MGR || '</td>
<td>' || r_emp.HIREDATE || '</td>
<td>' || r_emp.SAL || '</td>
<td>' || r_emp.COMM || '</td>
<td>' || r_emp.DEPTNO || '</td>
<td>' || r_emp.DEPARTMENT || '</td>
</tr>
'
);
end
loop;htp.p(
'

</tbody>
<tfoot>
<tr>
<th colspan="5"> Total</th>
<th>'||V_SAL_TOTAL||'</th>
<th>'||V_COMM_TOTAL||'</th>
<th>'||V_COUNT||'</th>
<th> </th>
</tr>
</tfoot>
</table>
'
);
htp.p (
' <style>
table {
font-family: "Helvetica Neue", Helvetica, sans-serif
}

caption {
text-align: left;
color: silver;
font-weight: bold;
text-transform: uppercase;
padding: 5px;
}

thead {
background: SteelBlue;
color: white;
}

th,
td {
padding: 5px 10px;
}

tbody tr:nth-child(even) {
background: WhiteSmoke;
}

tbody tr td:nth-child(2) {
text-align:center;
}

tbody tr td:nth-child(3),
tbody tr td:nth-child(4) {
text-align: right;
font-family: monospace;
}

tfoot {
background: SeaGreen;
color: white;
text-align: right;
}

tfoot tr th:last-child {
font-family: monospace;
}

</style>'
);
end;

alisaleh

how to repeat heading on 2nd page onward

yakaka

How can I get the Blob of PDF in pl/sql please.

abo-khaled

If i have two table how can i to print two page in pdf file ?

MrHaha

thanks your tutorials is very helpful, but better is that if you provide tutorials in english language...

SAD-ewhl

Hi Ali thank u for sharing PL/SQL code.
I tried very first PL/SQL code but when I click on the button nothing is happening

princesiddharha

Hi Sir
I followed this tutorial but print is not initiating the next page when there is more number of rows
what i'm i missing?
Thanks in advance

varshahr

كبف تمت عملية تعريب الارقام؟ هل هناك اداة جاهزة في ابكس لتعريب الارقام

jwadalsabee

Can you please guide me on how to save the generated PDF report(From a Dynamic region or a classic report) in Database as a BLOB type. Thanks!

patelbansari

Asalam o Alaikum!
Sir I use windo.print();
Wholl screen print but my need is only print data.

serialgamers

Hi sir,
Thanks for the video
i followed the same process but when i click the "pl/sql2" button blank sheet is getting generated with Page name in the header and page link in the footer(these page name and page link should not appear)
i have given window.print() when page loads
where i'm i doing wrong
Thanks in advance...

varshahr

Can u help me how to remove header from I click on print button in print also has header and footer of application

kaushik

Please share the code you write in "pl/sql and pl/sql 2 buttons"

awaisexilant

عند كتابة الفارزة لا يظهر الصفر مثلا عند وجو رقم 0.1 يظهر فقط .1 لا اعرف الحل

zainabalhilaly

How to export excel and pdf same report?

suvashishdas

جزيت خيرا ي هندسة ، وين احصل الملفات العليها الشرح لو تكرمت

wizzeico

auto print JavaScript code
window.print();

alisaleh

من فضلك اخ على صالح على كود كورس و شكرا

alihabboul

Print custom PDF Report Using PL/SQL Dynamic Region in Oracle Apex 19.1

Print custom PDF Report Using PLSQL Dynamic Region in Oracle Apex 20 1

Print custom PDF Report Using Report Query and Generic Report Layout

Print custom PDF Report Using PL/SQL Dynamic Region in Oracle Apex 19.1

Custom PDF Reports - Print On One Page

How Can I Print a Custom PDF Report Using PLSQL Dynamic Region in Oracle Apex 20.1?

React Print PDF: Build and generate PDF using React

Print custom PDF Report Using Layout [XSL] Designed By Altova StyleVision 2019 in Oracle Apex 19.1

Customize PDF Reports From User Interface In Odoo

How to print pdf report using button click event | generate report from button click

PDF Report Printing with Oracle Application Express 4.2.2 (Part 1)

How to Create PDF Report in Odoo 16 | Printed PDF Reports | Odoo 16 Development Tutorials

Print custom PDF Report Using Report Query and Custom Report Layout [XSL]

Report does not fit in print preview or on Pdf export

Appsheet Episode 15: How to generate PDF using Automation.

Printed PDF Reports in Odoo 17 | Odoo 17 Development Tutorials | Odoo 17 Features

Creating Custom PDF Reports with Geneticist Assistant

How to Adjust/ Resize PDF Pages ( Simple & Quick)

How to customize standard Data Model for : PO PDF Report - Oracle Fusion - Oracle BIP

How to Generate a PDF Invoice and Report in PHP: Complete Tutorial

Export Custom PDF Reports - Social Report Tutorial

How to create PDF file in less than 5 min using Javascript

Create Custom PDF Reports in Grafana Detailing Security Events | Share with Your Clients!

Create PDF And Excel Reports In Odoo 15 || Odoo 15 Excel Reporting | Odoo 15 PDF Reports

How to Download Report to PDF Using Plugin in Oracle Apex | | Lecture 64