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

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

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

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

Can u please share me the PL/SQL code

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

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

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

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

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

ممكن translate function

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!

i followed your instruction. window.print() display current page for printing only. Example: i have 3 pages, when i click on print button, then only 1 page is printed. How to fix it?

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

Please send query code

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

How to export excel and pdf same report?

ما شاء الله عليك

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

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

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

auto print JavaScript code
window.print();

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