How to Download and Print PDF Classic Report in Oracle Apex

How to Download and Print PDF Classic Report in Oracle Apex

Steps On How to Download and Print PDF Classic Report In Oracle Apex.

Follow All The SQL Codes And Steps Below Correctly. In Today's Post I Will Discuss Download and Print PDF Report.
1. Create An Classic Report According To Your Needs
2. Goto Page Properties-html Header-paste The Following Code-

123456789101112131415161718192021<span class="pun">&lt;</span><span class="pln">script type</span><span class="pun">=</span><span class="str">"text/javascript"</span><span class="pun">&gt;</span><span class="kwd">function</span><span class="pln"> </span><span class="typ">Export</span><span class="pun">()</span><span class="pln"> </span><span class="pun">{</span><span class="pln">
    html2canvas</span><span class="pun">(</span><span class="pln">document</span><span class="pun">.</span><span class="pln">getElementById</span><span class="pun">(</span><span class="str">"PDF"</span><span class="pun">),</span><span class="pln"> </span><span class="pun">{</span><span class="pln">
        onrendered</span><span class="pun">:</span><span class="pln"> </span><span class="kwd">function</span><span class="pun">(</span><span class="pln">canvas</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln">
            </span><span class="kwd">var</span><span class="pln"> data</span><span class="pun">=</span><span class="pln">canvas</span><span class="pun">.</span><span class="pln">toDataURL</span><span class="pun">();</span><span class="pln">

            </span><span class="kwd">var</span><span class="pln"> docDefinition</span><span class="pun">=</span><span class="pln"> </span><span class="pun">{</span><span class="pln">
                content</span><span class="pun">:</span><span class="pln"> </span><span class="pun">[</span><span class="pln"> </span><span class="pun">{</span><span class="pln">
                    image</span><span class="pun">:</span><span class="pln"> data</span><span class="pun">,</span><span class="pln">
                    width</span><span class="pun">:</span><span class="pln"> </span><span class="lit">500</span><span class="pln">
                </span><span class="pun">}</span><span class="pln">

                </span><span class="pun">]</span><span class="pln">
            </span><span class="pun">}</span><span class="pln">

            </span><span class="pun">;</span><span class="pln">
            pdfMake</span><span class="pun">.</span><span class="pln">createPdf</span><span class="pun">(</span><span class="pln">docDefinition</span><span class="pun">).</span><span class="pln">download</span><span class="pun">(</span><span class="str">"Table.pdf"</span><span class="pun">);</span><span class="pln">
        </span><span class="pun">}</span><span class="pln">
    </span><span class="pun">});</span><span class="pln">
</span><span class="pun">}</span><span class="pln">

</span><span class="pun">&lt;/</span><span class="pln">script</span><span class="pun">&gt;</span>

3. Goto Region Properties- Static ID=PDF
4. Goto Region Properties Header Text- Paste The Following Code-

1<span class="pun">&lt;</span><span class="pln">input type</span><span class="pun">=</span><span class="str">"button"</span><span class="pln"> id</span><span class="pun">=</span><span class="str">"btnExport"</span><span class="pln"> </span><span class="kwd">value</span><span class="pun">=</span><span class="str">"Export"</span><span class="pln"> onclick</span><span class="pun">=</span><span class="str">"Export()"</span><span class="pln"> </span><span class="pun">/&gt;&lt;</span><span class="pln">script type</span><span class="pun">=</span><span class="str">"text/javascript"</span><span class="pln"> src</span><span class="pun">=</span><span class="str">"https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.22/pdfmake.min.js"</span><span class="pun">&gt;&lt;</span><span class="str">/script&gt;&lt;script type="text/</span><span class="pln">javascript</span><span class="str">" src="</span><span class="pln">https</span><span class="pun">:</span><span class="com">//cdnjs.cloudflare.com/ajax/libs/html2canvas/0.4.1/html2canvas.min.js"&gt;&lt;/script&gt;</span>
How to Download and Print PDF Classic Report in Oracle Apex

Then Enjoy.............

2 Comments

Hlo Sir

Previous Post Next Post